Move a Claude table to Excel or Google Sheets

To move a Claude table to Excel or Google Sheets, ask for CSV and import the saved .csv with the correct separator. Try copying a small table from the browser first. Check afterward: numbers that look right may still be stored as text.

Try copying a small table first

Select the visible table, copy it, and paste it into cell A1 of an empty worksheet. Check that headers and values land in separate cells. If you see pipe characters, separator dashes, or a whole row in one cell, use the CSV steps below.

Compare row and column counts with the original. Before editing, keep the assumptions in a Google Docs note, or save the original reply.

Ask for CSV with an explicit structure

For a supplier comparison, specify the columns and rules:

“Return this table as CSV in a code block with columns Supplier, UnitCostUSD, Quantity, and Notes. Include one header row. Preserve the values, omit currency symbols and thousands separators, leave unknown values empty, and quote fields containing commas.”

For example:

Supplier,UnitCostUSD,Quantity,Notes
Supplier A,12.50,80,Standard delivery
Supplier B,11.75,100,"Delivery included, minimum 100 units"
Supplier C,13.10,60,Collection required

Save only the CSV contents as supplier-comparison.csv in a plain-text editor, using UTF-8 encoding. Leave out code fences and introductory text.

Compare rows and values with the original before importing. Reformatting can still change values or drop rows. Keep notes in their own column.

CSV is a plain-text format without cell styling. Keep images and long code or equation explanations in the accompanying document. Use a workbook for multiple sheets and calculations.

Import the file into Excel

In desktop Excel, follow Microsoft’s import steps:

1. Open the destination workbook.
2. Select Data → From Text/CSV.
3. Select your .csv file.
4. Choose Import.
5. Set Delimiter to match the file, usually a comma.
6. Check the preview for the expected columns.
7. Choose Load when the preview is correct.

Use Transform Data to set column types before loading. Opening a CSV directly leaves those choices to Excel’s default interpretations.

The supplier example needs four columns. The comma in “Delivery included, minimum 100 units” belongs in Notes. Fix any extra column before loading.

Import the same CSV into Google Sheets

Follow Google’s file-import steps:

1. Open a spreadsheet.
2. Select File → Import.
3. Open Upload.
4. Choose Select a file from your device.
5. Select your CSV file.
6. Choose the intended Import location.
7. Set Separator type to match the file.
8. Click Import data.

Choose a fresh sheet to protect working calculations. Keep the CSV in case you need another import.

If simple comma-separated text landed in one column, select it and use Data → Split text to columns, then choose the separator. See Google’s column-splitting guide for the controls. For quoted commas or line breaks, use the file importer and check the cells.

Fix numbers without damaging identifiers

Before copying formulas down, check the values. Supplier A’s unit cost times its quantity should give 1,000. Even if that works, look for numbers stored as text.

In Excel, select numeric cells flagged as text, open the error indicator, and choose Convert to Number. If there’s no warning, try the other methods in Microsoft’s conversion instructions.

In Sheets, try =VALUE(B2) in a spare column. The VALUE function turns recognized numeric text into a number. It returns an error when it can’t read the text as a number. Check the results before replacing the original column.

Keep product codes, account references, and postal codes as text when the digits identify something. Converting 00127 to a number removes meaningful zeros. Microsoft explains how to keep leading zeros during import. Apply currency formatting after the underlying values are correct.

Ask for an Excel file when you need formulas

As of November 2026, Claude’s file-creation feature can make downloadable .xlsx spreadsheets with working formulas. It is available across Claude plans, though your organization’s settings can restrict it.

Ask for a workbook when you need multiple sheets, calculations, or charts: “Create an Excel file from this supplier table. Keep the source data on one sheet and calculate quantity times unit cost on another. Put delivery assumptions beside the totals.”

Check the downloaded workbook’s formulas and displayed values against the source data. Download the artifacts ZIP to keep the latest versions of supporting files together.

Use Claude inside Excel or Sheets for ongoing work

The Claude for Excel add-in answers workbook questions, changes models, and fills in templates.

Claude for Google Workspace is in beta on supported paid plans. Its sidebar edits the open spreadsheet and fixes formulas.

From a Claude conversation, the separate Google Sheets connector creates and edits Sheets files. The Drive connector searches, uploads, and shares using your connected account’s permissions.

Use these integrations for ongoing spreadsheet work. For a one-time transfer, CSV or a downloaded workbook is enough. DocMyChat doesn’t sync either app with your conversation.

Questions