AI tables break when pasted into Sheets or Docs
Last verified: Claude Fable 5 / GPT-5 era models · July 2026
The table looks perfect in the chat. Then you paste it into Google Sheets and the whole thing lands in one cell, or into Google Docs and the pipes show up as literal text. So someone rebuilds it column by column, which is exactly the work the AI was meant to remove. This page gives you a prompt that makes the AI output the right format for wherever the table is going, plus the two paste paths that actually work.
Part 1 · The generator prompt
Paste this into a fresh Claude or ChatGPT chat. It interviews you about where your tables go and how your numbers should look, then hands back a table block you paste at the top of any chat so the AI produces the right format instead of a table that shatters on paste.
You're going to build my company's TABLE OUTPUT BLOCK: a reusable instruction block I'll paste into any AI chat that produces tables, so they land cleanly wherever I paste them. Interview me first, one question at a time. Where I don't know, propose a sensible default and move on: 1. Where do our AI-produced tables usually go: Google Sheets or Excel (a spreadsheet), or Google Docs or Word (a document)? Sometimes both? 2. What kinds of table do we make most (pricing, comparisons, schedules, data summaries) and roughly how many columns? 3. Number conventions: currency format, decimal places, thousands separators, how we show percentages and dates. 4. Any structure rules: header row style, a totals row, columns that must always appear, maximum width before it should become a list instead. 5. What goes wrong today: everything in one cell, wrong split points, literal pipes in Docs, numbers turning into text or dates? Then output my TABLE OUTPUT BLOCK as one copy-paste block containing: (a) one line of context, (b) the destination rule: for a spreadsheet, output the table as CSV or TSV in a code block, never as a markdown table; for a document, output a standard markdown table; ask which destination if I haven't said, (c) our number, currency, date and percentage conventions, (d) structure rules: header row, totals, mandatory columns, and when to use a list instead of a table, (e) a self-audit that checks the format matches the destination and the number conventions before output, then appends "Table check: pass" or lists what is off. Keep it under 400 words so it fits any project-instructions field. After you output it, tell me the exact steps to paste each format cleanly (CSV or TSV into a spreadsheet, markdown into Docs) and the two mistakes most likely to still break a table.
Part 2 · The two paste paths that actually work
The block makes the AI output the right format. These are the paste steps that keep it intact.
- Into Google Sheets or Excel: ask the AI for the table as CSV or TSV in a code block, not a markdown table. Copy it, then in Sheets use Edit → Paste, and if it lands in one cell, Data → Split text to columns. TSV (tab-separated) usually splits automatically on paste; CSV may need the split step.
- Into Google Docs or Word: ask for a standard markdown table, then in Docs use Edit → Paste from Markdown, not Ctrl+V, which turns it into a real Docs table. Ctrl+V is what leaves the pipes and dashes as literal text.
- Store the table block in your AI tool's project instructions so the AI already knows your destinations and number conventions, and just name the destination when it matters ("give me this as CSV for Sheets").
- If a table is more than a handful of columns wide, the block tells the AI to offer a list instead. Wide tables are the ones that break most on paste and read worst in a document.
Part 3 · A worked example
Here is the block the generator hands back, for our running example company, the fictional consultancy Fenwick & Cole.
CONTEXT: Fenwick & Cole tables are usually pricing and option comparisons, going into either client documents (Google Docs) or working spreadsheets (Google Sheets). DESTINATION RULE: if the table is for a spreadsheet, output it as CSV or TSV inside a code block, never as a markdown table. If it is for a document, output a standard markdown table. If I haven't said which, ask before producing the table. NUMBERS: currency as £4,000 (no decimals unless I ask), thousands separated with commas, percentages as 12% (no decimal unless needed), dates as 4 July 2026. STRUCTURE: header row always present, and bold in document tables. Pricing tables end with a Total row. Maximum four columns; if the content needs more, offer a list instead. Never put long prose in a cell. SELF-AUDIT: before output, confirm the format matches the destination (CSV/TSV for a spreadsheet, markdown for a document) and the numbers follow the conventions above. Append "Table check: pass", or list what is off.
Common questions
Why do AI tables break when I paste them into Excel or Sheets?
The AI gives you a markdown table: text with pipe characters and dashes. Spreadsheets don't read markdown, so the whole thing pastes into a single cell. Spreadsheets do read CSV and TSV, where columns are separated by commas or tabs. Ask the AI for CSV or TSV instead of a markdown table and the columns land in the right cells.
How do I get AI to output a table I can paste into a spreadsheet?
Tell it to output the table as CSV or TSV in a code block rather than a markdown table. Copy that, paste into the sheet, and if it arrives in one cell use Data then Split text to columns. TSV usually splits on paste automatically. The generator prompt on this page bakes that destination rule into a reusable block so you don't ask each time.
How do I paste an AI table into Google Docs without broken formatting?
Ask the AI for a standard markdown table, then in Google Docs use Edit then Paste from Markdown instead of Ctrl+V. Paste from Markdown turns the table into a real Docs table; Ctrl+V leaves the pipes and dashes as literal characters. This is the same paste path that fixes AI Markdown generally in Google Docs.
The prompt is the aspirin. Stored context is the cure.
The table block you just generated is exactly what an AI Brain stores as always-on context. Paste it and this table lands cleanly; installed, the AI already knows your destinations and number conventions and formats every table for where it's going, so nobody rebuilds columns by hand. This page proved it on your own tables. The install is how the right format becomes automatic.
What else does AI get wrong that you fix by hand?Browse the other fixes →