Copied a table from a photo and it pasted into one column
Short answer
Live Text copies the words of a table, not its cells, so the paste lands in one column (or one cell). Paste the copied text into the free paste-to-columns tool, choose how it's split (“2+ spaces” or “every N lines is a row”), and copy the result — tab-separated rows paste into Excel or Numbers as real columns. For whole tables, a table scanner like QuickScan skips the rebuilding.
What Live Text copies
Live Text — pressing and holding on text in a photo, then Copy — recognizes text, not table structure. It hands over the words in reading order. Depending on the table's spacing, you get one of two shapes:
A row per line: A-1042 Copy paper A4 24 4.50 — the cells of a row joined by spaces.
A cell per line: A-1042 / Copy paper A4 / 24 / 4.50 — every cell on its own line, row after row.
A spreadsheet only splits pasted text into columns at tab characters. Spaces and line breaks aren't enough, so everything goes down column A — or, in Numbers, into the cell you were editing.
How to rebuild the columns
- In Photos, press and hold on the table's text, drag to select it all (or tap Select All) and tap Copy.
- Open the paste-to-columns tool and paste.
- Pick the shape: columns separated by 2+ spaces or tabs for a row per line, or every N lines is one row for a cell per line (set N to the number of columns).
- Check the preview, then Copy as rows and paste into Excel, Numbers or Google Sheets — or download a CSV.
The tool runs in your browser; the text isn't sent anywhere.
Pasting into Numbers: one cell vs columns
In Numbers, double-tapping a cell starts editing its text, and a paste then goes into that single cell. Instead, tap the top-left cell once to select it (without the keyboard appearing for editing), then paste. Tab-separated rows fill the cells to the right and below. In Excel, select the cell and paste normally.
Where this approach struggles
- Cells with single spaces inside and between them:
Copy paper A4 24can't be split reliably by spaces alone — use “every N lines” if Live Text gave one cell per line, or fix the few rows by hand. - Empty cells: Live Text skips them, so later values shift left. Check rows with gaps.
- Long tables: selecting a whole page with Live Text is fiddly, and every misplaced value is yours to find.
When to use a table scanner instead
For more than a few rows, a scanner that sees the table's structure is faster and safer. QuickScan finds the rows and columns from the photo — using ruling lines and alignment, not just reading order — keeps empty cells in place, highlights the cells it's unsure about, and exports an Excel or CSV file. See copy a table from a photo into Numbers.
On a computer? Point your iPhone's camera at the code to open QuickScan in the App Store.
3 free exports, then a one-time unlock. No subscription.
Questions
Why does a table copied with Live Text paste into one column?
Live Text recognizes text, not table structure. It copies the words in reading order — one row per line, or one cell per line — without the tabs a spreadsheet needs to split them into columns.
How do I paste so that values go into separate columns?
Values separated by tabs fill separate columns when pasted into Excel, Numbers or Google Sheets. Turn the copied text into tab-separated rows first — the free paste-to-columns tool does that in your browser.
Why does Numbers paste everything into one cell?
If you double-tap a cell, Numbers is editing that cell's text and pastes everything into it. Select the cell once (without editing it), then paste: tab-separated text fills the cells to the right and below.
Is there a way to copy a photo's table as cells directly?
Not with Live Text, as of October 2026. A table scanner such as QuickScan reads the rows and columns and exports a spreadsheet file instead.