HavenSkills

Claude Excel (XLSX) skills

Claude skills for spreadsheets: build tables, update formulas and charts, and recalculate workbooks before sharing.

Recommended starting points

Format-specific skills

Multi-format skills

How Claude XLSX skills handle real workbooks

A spreadsheet is not a table. It is formulas, cross-sheet references, number formats and charts that all have to stay consistent after an agent touches the file. A Claude XLSX skill earns its place by writing formulas instead of frozen values, and by leaving you a workbook you can recalculate and audit.

Formulas, not pasted numbers

The failure mode that costs the most time is a column of plausible numbers with no formulas behind it. Next month the input changes and the total does not. Ask for the formula and the cell range explicitly, then change one input and watch whether the dependent cells move. If they do not, the agent wrote values instead of formulas.

  • Ask for formulas and say which cells they belong in.
  • Recalculate after the edit and compare two totals.
  • Never send a workbook where the total is a typed value.

Multiple sheets and cross-sheet references

Cross-sheet references are where an automated edit most often goes wrong: a formula that pointed at 'Q3 Inputs' ends up pointing at the active sheet, and the error is invisible until someone reads the number. Name the sheets in your request and re-check any total that pulls from another sheet. Totals built from several sheets deserve a second look against the source.

  • Name the sheets in the request.
  • Check references that span sheets, not only within one.

Charts, number formats and formatting

Charts can survive an edit while pointing at a stale range, so open each chart and confirm the source range matches the new rows. Number formats are the quiet one: a percentage written as 0.185 shows 0.185 until the cell format changes, and a currency column can silently drop its symbol. Check one currency column, one percentage column and every chart's data range.

  • Check one chart and one currency column after the edit.
  • Percentages are stored as decimals; check the format.

When the output should leave as CSV

CSV carries values, not formulas, styles or multiple sheets, which is exactly what an import into another system wants. It is the wrong output when a person has to recalculate anything later. If a workflow needs both, ask for the workbook first and export a CSV from the finished file, then check that the export has no hidden columns and no extra header rows.

  • CSV for exchange, XLSX for anything with formulas.
  • Confirm the export contains only the rows you meant to send.

Choose an Excel skill by the outputs you need

Use the dedicated XLSX skill for working formulas, charts and workbook edits. A cross-format skill can help when a workbook and a separate report need to share the same numbers. Either way, ask for formulas, not values, and name the sheets you expect the agent to touch.

How to check the result

Recalculate the file, change one input and inspect a dependent total. Confirm any CSV export only includes the data intended for that file, and open each chart to check its source range still covers the new rows.

Frequently asked questions

Which Claude skill should I use for Excel formulas?

Start with Anthropic XLSX and ask for formulas rather than results. After the edit, change one input cell and check that the dependent totals move; if they stay frozen, the agent wrote values instead of formulas.

Can a Claude XLSX skill update a spreadsheet I already built?

It can edit an existing workbook when you give it the file and say which range to change, but formulas, charts and formats are the parts most likely to shift. Keep the original, then compare formulas and chart ranges against your copy before sharing.

Should I ask for XLSX or CSV?

Choose XLSX for formulas, styles and multiple sheets. Choose CSV for exchanging plain tabular data. A CSV keeps values only, so anything that has to be recalculated later should stay in XLSX.

How do I check a workbook before sharing it?

Recalculate first, then check one currency column, one percentage column and every chart's source range. Test one cross-sheet total against the source sheet; that is where a broken reference usually hides.

How do I get both a spreadsheet and a CSV from one job?

Ask for the workbook first and export the CSV from the finished file, rather than running two separate edits. Then scan the export for hidden columns, extra header rows and values that should have been blank.