Claude to Excel: Three Ways to Get Claude's Data into a Spreadsheet

How to copy a Claude table to Excel

For a table that's already in a Claude answer, this is the quickest way to get it into Excel:

1. Select only the table. Drag from the first header cell to the last cell of the rendered table. Start and stop inside the table so no surrounding text comes along.
2. Copy with Ctrl+C (Cmd+C on a Mac).
3. Paste into Excel. Click the top-left cell where the data should start and press Ctrl+V (Cmd+V). Each cell of Claude's table fills one Excel cell.
4. Check the values. Numbers and dates that Excel recognized sit right-aligned. Anything left-aligned is still text — see the fixes further down.

That's the whole job for a small table.

Which Claude to Excel route should you use?

Pick by where the data starts and where you'll keep working on it. Pasting suits a table that's already in a chat, CSV suits long or reusable data, a created .xlsx suits a finished file assembled from a conversation, and the add-in suits work on a workbook you already have open.

The first three start on claude.ai and end with data in Excel. The add-in works the other way round: it starts in Excel and brings Claude to the workbook.

Route 1: paste the table, or ask for CSV

Selecting and pasting works because the browser hands Excel a real table. What goes wrong is usually one of these:

• Everything lands in column A. You pasted text, not a table — typically Markdown from the copy button under the response, where each row reads like | Region | Q1 | Q2 |. Select column A, choose Data → Text to Columns → Delimited (Microsoft's wizard guide), tick Other and type |. Delete the empty first and last columns and the row of dashes.
• Numbers stay as text. Values like "1,200 units", "$4.5k" or "12%" with a trailing note can't be calculated. Ask Claude to give numbers without units in the cells and put units in the header instead.
• Dates flip day and month. Excel reads dates using your system's regional settings. Ask Claude for ISO dates (2026-09-27), which Excel reads the same way everywhere.
• Columns come out too narrow. Select the columns and double-click any column border to AutoFit them.

When CSV is the better choice

For longer tables — or when the data will also go into a database or another app — ask Claude for the same data as CSV instead of a rendered table. A prompt such as "Give me that table as CSV in a code block, with a header row and no units in the numeric columns" works well.

1. Copy the CSV from the code block.
2. Paste it into a plain-text editor and save it with a .csv extension.
3. In Excel on Windows, import it with Data → From Text/CSV (Microsoft's CSV import guide), check the preview, and click Load. (You can also simply open the .csv file in Excel on any platform.)

The import preview lets you check the delimiter and column types first, which is why it copes with large tables better than pasting.

Route 2: ask Claude to create an .xlsx file

Claude on claude.ai can write and run code to produce real Excel files, which you then download from the chat. This is Claude's file creation feature, and it's available on every plan in the web app, Claude Desktop and the mobile apps.

1. On Free, Pro or Max, open Settings → Capabilities and turn on Code execution and file creation.
2. In a chat, describe the spreadsheet: the sheets you want, the column headers, and any totals or summary rows.
3. Wait for Claude to build the file, then download it from the conversation.
4. Open it in Excel and check the numbers before you rely on them.

This route suits data scattered across a conversation — figures from several answers, a comparison refined over a few turns — because Claude assembles it into one workbook. It creates a new file from your instructions, not a copy of the chat, so review it like any spreadsheet someone else built. For the same feature applied to PDFs and Word files, see whether Claude can create a PDF.

Route 3: what is Claude for Excel?

Claude for Excel is an add-in that runs Claude inside Microsoft Excel and works on the workbook you have open. It answers questions with cell-level citations, updates values while keeping formulas intact, debugs errors, builds and populates models, and uses Excel's own sort, filter, pivot table and conditional formatting features.

It needs a Pro, Max, Team or Enterprise plan. It does not read your claude.ai conversations — it's for work that belongs in the spreadsheet itself.

To install it, get the Claude for Microsoft 365 listing from Microsoft AppSource, or search for "Claude" in Excel's add-ins store and sign in with your paid Claude account. Unrelated AI add-ins show up in the same search, so check the name and publisher before you click Add.

The same listing covers Word; admin deployment and the Word side are on the Claude for Word add-in page, and the full Excel feature list is in Claude's documentation for Claude for Excel. Review each change the add-in makes before you save or share the workbook.

Does the Claude to PDF extension export to Excel?

No. The browser extension exports conversations to PDF, Word, Google Docs and Markdown — there is no Excel or CSV button, and it doesn't create .xlsx files. For tables headed to a spreadsheet, the three routes above are the right tools.

It helps when a conversation mixes tables with explanation you also want to keep: exporting the chat to Word writes every table as a real Word table, so you keep a readable record and can still copy any table from Word into Excel with its cells intact. If the table is going into a document rather than a sheet, copying a table from Claude to Word covers the cleanup.

Prompts that make tables easier to move

A table designed for a spreadsheet saves most of the cleanup:

• "One value per cell." No "12 (up 3%)" — put the change in its own column.
• "No units or currency symbols in numeric cells." Put them in the header: "Revenue (USD)".
• "Dates as YYYY-MM-DD." Avoids day/month swaps.
• "No merged or grouped header rows." A single header row imports cleanly.
• "Add a total row only at the end." Subtotals in the middle get in the way of sorting and pivot tables.

If the table will grow over several turns, ask for the final version as CSV or as an .xlsx file once, rather than copying each draft.