To copy a table from an image on iPhone, open the picture in Photos, touch and hold a word in the table, drag the grab points over the rows you want, and tap Copy. Paste into Numbers or Excel. Live Text copies the words and numbers, but rows often paste as single cells, so plan to split them into columns.
What Live Text on iPhone copies from a table image
Live Text is the iPhone feature that recognizes text inside photos, screenshots and paused video. From a table image it copies characters and line breaks. It does not copy the grid itself, so the cell borders, column positions and alignment are gone by the time the text reaches another app.
That distinction explains most of the surprises. A table in an image is a picture of text arranged in columns. Live Text reads the text in reading order, line by line, and hands it over as plain text. A spreadsheet then has to decide where one value ends and the next begins.
What usually comes through well:
- printed digits and letters in a clear, upright photo or screenshot
- the order of lines from top to bottom
- short labels such as column headings
What often needs fixing:
- column boundaries, which become spaces or tabs, or vanish
- empty cells, which leave no trace, so later values shift left
- multi-line cells, which become separate lines
- symbols such as currency signs, minus signs and brackets around negatives
Apple sets the device baseline. Its support article on copying text from photos on iPhone or iPad says Live Text needs "an iPhone XS, iPhone XR, or later with iOS 15 or later", and that not every region and language is supported.
Turning on Live Text and selecting table rows in Photos
Live Text has a switch in Settings, under General, then Language and Region. Once it is on, open the image in Photos, touch and hold a word, and drag the grab points to cover the rows. Tap Copy, or tap Select All to take every piece of text in the image.
The full sequence, following Apple's steps:
- Open Settings, tap General, then Language & Region, and turn on Live Text.
- Open Photos and tap the image that holds the table.
- Touch and hold a word in the first row you want.
- Drag the grab points down and across until the selection covers the last row.
- Tap Copy.
- Open Numbers or Excel, tap a cell, and paste.
Select All is tempting, but it also grabs titles, page numbers and any stray text around the table. On a screenshot of a bank app, that means status bar times and button labels. Selecting only the rows saves cleanup.
Selection on a dense table can jump between columns. If your finger drags into a neighbouring column, the selection may follow the reading order rather than your finger. Zoom in on the image first, so each row is large on screen, and the grab points become easier to steer.
Apple renames buttons and moves menus between iOS releases. If your Photos screen looks different from these steps, touch and hold on a word is the method to fall back on.
Why does a Live Text table paste as one column on iPhone?
A Live Text table pastes as one column because the copied text holds line breaks between rows but no tab characters between columns. A spreadsheet puts each line into its own cell down column A, with all the values from that row joined by spaces. Nothing is lost; the column structure just was never part of the copy.
Some pastes behave a little differently. A table with wide gaps between columns can paste with each value on its own line, so a five-column row becomes five cells in a vertical stack. That happens when the recognizer treats each column block as a separate paragraph. You can tell which kind of paste you have by looking at the first few cells:
- One line per row:
03/14 Hardware Depot 42.10in a single cell. Split on spaces. - One line per value:
03/14, thenHardware Depot, then42.10in three cells below each other. Reshape every group of cells into one row.
On Android the same thing happens with its own text tools, and copying text from a photo on Android into a spreadsheet shows that phone's version of the fix.
Splitting a pasted iPhone table into columns in Numbers or Excel
Splitting a pasted table means turning each line of text into separate cells for date, description and amount. The easiest place is a computer, where Excel's Text to Columns or the TEXTSPLIT function do it in seconds. On the iPhone itself, a few formulas in Excel or Numbers can pull the first and last values out of each line.
Most table rows follow a pattern: a date or label at the start, an amount at the end, and free text in the middle. Pull the ends off first, then whatever is left is the middle column.
A worked example
These five lines are an example paste from a made-up receipt table, each one in its own cell from A2 to A6:
| Cell | Pasted text (example) |
|---|---|
| A2 | 03/14 Hardware Depot 42.10 |
| A3 | 03/14 Corner Bakery 6.75 |
| A4 | 03/15 City Parking 12.00 |
| A5 | 03/16 Office Supply Co 88.49 |
| A6 | 03/16 Corner Bakery 4.20 |
In Excel, put the date formula in B2, the amount formula in C2 and the description formula in D2, then fill all three down. The date is the text before the first space:
=LEFT(A2, FIND(" ", A2) - 1)
The amount is the text after the last space. This formula swaps the last space for a marker and takes everything after it:
=VALUE(MID(A2, FIND("|", SUBSTITUTE(A2, " ", "|", LEN(A2) - LEN(SUBSTITUTE(A2, " ", "")))) + 1, 20))
The description is what remains between the two:
=TRIM(MID(A2, LEN(B2) + 2, LEN(A2) - LEN(B2) - LEN(TEXT(C2, "0.00")) - 2))
Row 2 then reads 03/14, Hardware Depot and 42.10 in columns B, D and C. The description formula assumes amounts are printed with two decimals, which is true for this example. A description with its own spaces, such as "Office Supply Co", stays whole because only the first and last spaces are used.
Numbers on the iPhone has LEFT, MID, FIND and SUBSTITUTE as well, so the same approach works there with small changes. Typing long formulas on a phone keyboard is slow, though, and a computer is worth the trip for more than a screen of rows.
Did any amounts change when copying the iPhone table image?
Text recognition can change a digit without any warning, so check copied amounts against the image before using them. The fastest check is a total. Add the amount column in the sheet and compare it with a total printed in the image, or with your own sum of the image values for a short table.
For the example above, the amounts add up to 153.54. If the image prints a total, it should match exactly. A difference that is a round number, such as 9.00 or 0.50, often points to one misread digit. A difference equal to one whole row means a line was skipped during selection.
Digits that text recognition tends to confuse in photos:
- 1 and 7, especially in some fonts
- 3, 5, 6, 8 and 0 when the image is blurry
- a comma and a full stop, which changes 1,250 into 1.250
- a minus sign, which can vanish entirely
Also count the rows. Five lines in the image should give five rows in the sheet. Then check one row from the middle of the table by eye, value by value, since a total cannot catch two errors that cancel out.
Copy from the sharpest image you have. A screenshot is better than a photo of a screen, and a photo taken flat and in good light is better than one at an angle.
When to skip Live Text for a table image on iPhone
Skip Live Text when the table is long, has many columns, or will be used for money that has to be right. Live Text is built for grabbing a phone number or a paragraph, not for rebuilding a grid. Tools that detect tables keep the columns and save you the splitting step.
Better options, by situation:
- A table photo you want in Excel now. The Excel app has a Data from Picture option. Microsoft's guide to inserting data from a picture in Excel says you tap Insert, then Data from Picture, frame the data until a red border appears, and then review any issues it flags before inserting.
- A table that is really a PDF. If the image is a screenshot of a PDF, go back to the PDF. Its text is already stored as characters, which removes recognition errors.
- A long table to work on with a keyboard. Move the image or PDF to a Mac. Sending a bank statement from iPhone to Mac with AirDrop explains where the file lands.
- Regular conversions of the same kind of document. A dedicated converter is worth a look. Choosing between desktop software and online tools to convert PDF to Excel weighs the trade-offs.
For bank statements in particular, a statement PDF beats any image of it. FastBankConvert is built to turn a statement PDF into rows with dates, descriptions, amounts and balances in their own columns, and to warn you before download when the balances do not add up. It is getting ready to open, and you can sign up from Get started.