# Live Text on Mac: Copy Rows From a Scanned Statement - Author: CheapBankConvert (https://cheapbankconvert.com) - Published: 2026-10-17 - Category: Free tools you already own - Canonical: https://cheapbankconvert.com/blog/live-text-on-mac > Use Live Text on a Mac to copy rows from a scanned statement in Preview for free, paste them into Numbers or Excel, and fix the columns. Live Text on a Mac recognises the words in an image, so you can copy rows from a scanned statement for free. Open the scan or a screenshot of it in Preview, drag across the transaction lines, Control-click and choose Copy Text. Paste into Numbers or Excel, then split the text into date, description and amount columns. ## What Live Text on Mac can read from a scanned statement Live Text on a Mac reads printed text in an image and lets you select it as if it were typed. A scanned statement is an image of a page, so Live Text can pull its words and numbers out. It reads clean, straight, high-contrast print best, and smudged or faint copies worst. Apple's Preview guide on [interacting with text in a photo](https://support.apple.com/guide/preview/interact-with-text-in-a-photo-prvw625a5b2c/mac) describes the feature for photos and images, and notes that Live Text is not available in every region or language. Bank statements in English are a good fit. What it does not read well: - **Handwriting.** Notes in the margin come out garbled or not at all. - **Tiny print.** A statement shrunk to fit two pages per sheet reads less reliably, and small decimal points are easy to lose. - **Shaded rows.** Grey banding behind every other line can hide light digits. If your file is a PDF from online banking rather than a scan, you do not need Live Text. Its text is already selectable, and the Preview-to-Numbers route in [converting a PDF to Excel on a Mac for free](/blog/convert-pdf-to-excel-on-mac-free) is the better path. ## Copying statement rows with Live Text in Preview, step by step Copying with Live Text takes one selection per block of rows. Start from an image of the page, select the rows, copy the text and paste it into a spreadsheet. If a scanned PDF will not let you select anything, take a screenshot of the page first, because Apple documents Live Text for images. 1. Open the scanned statement in Preview. 2. Try dragging across a transaction line. If nothing highlights, press Command-Shift-4 and drag a box around the transaction table to save a screenshot. Open that screenshot in Preview. 3. If you still cannot select text, choose Tools, Text Selection, as Apple's guide suggests. 4. Drag from the first date to the last balance in the block you want. Leave out the logo, address and page footer. 5. Control-click the selection and choose Copy Text. 6. Open a blank sheet in Numbers or Excel, click cell A1 and paste. 7. Count the pasted rows against the printed page before you do anything else. Work one page at a time. A long selection that crosses a page break picks up the footer, the page number and the next page's header as extra rows. ## Why do Live Text rows paste into a single column? Live Text rows paste into one column because the copied text has line breaks between rows but only spaces between columns. A spreadsheet treats each line as one cell. The fix is to split each line from both ends: the date at the start, the amounts at the end, and the description in the middle. Here is an example, with made-up values. After pasting, cell A1 holds: `04/09 CORNER HARDWARE 18.62 2,407.15` What you want is four cells: `04/09`, `CORNER HARDWARE`, `18.62` and `2,407.15`. In Excel, Data, Text to Columns, split on spaces, works only when every description has the same number of words; otherwise the amounts land in different columns. In Microsoft 365 Excel, formulas split from both ends instead: `=TEXTBEFORE(A1," ")` returns the date, `=TEXTAFTER(A1," ",-1)` the balance, and `=TEXTAFTER(TEXTBEFORE(A1," ",-1)," ",-1)` the amount. In Numbers, paste the text into TextEdit first, replace the spaces before each amount with a tab, and paste again so Numbers fills separate columns. [Snipping Tool text actions on Windows](/blog/snipping-tool-text-actions) produce the same one-column result, so the same split applies if you switch computers. ## Live Text versus Preview's Embed Text for a whole scanned PDF Live Text suits a page or two. For a long scanned PDF, Preview's Embed Text is faster, because it recognises every page at once and saves a PDF whose text you can select anywhere. Apple's guide to [embedding text in a PDF](https://support.apple.com/guide/preview/prvw1ddb1cdf/mac) puts it under File, Export, Embed Text. Apple notes that the option appears only if no text was recognised in the document before. Once the file has a text layer, you can select rows directly in Preview with no screenshots, and the paste-and-split routine above stays the same. Pick by page count: | Statement | Better choice | Why | | --- | --- | --- | | One or two scanned pages | Live Text on a screenshot | No export step, done in minutes | | Five or more scanned pages | Embed Text, then select | One recognition pass for all pages | | A PDF from online banking | Neither | Its text is already selectable | You do not need a paid PDF editor for either route. [Free PDF reader versus PDF editor](/blog/free-pdf-reader-vs-pdf-editor) explains when an editor earns its price, and copying statement text is not one of those times. ## Does Live Text on a Mac misread statement amounts? Live Text can misread amounts, as any OCR can, and the damage is quiet. An 8 read as a 3, a 1 read as a 7 or a dropped decimal point gives a believable number that is simply wrong. Check every page against the balances the bank printed before you trust the totals. A quick balance check, using an example page: 1. Take the opening balance for the page, for example 2,425.77. 2. Subtract the withdrawals you pasted and add the deposits. 3. Compare the result with the last balance printed on that page. 4. If they differ, the gap often points at the bad digit. A gap of 50.00 hints at a 5 read as a 0, or a missing line. Scanned statements often come from paper mail or an emailed attachment you printed. If your bank sends statements by email, [what to know about bank statements by email](/blog/bank-statements-by-email) covers the delivery risks, and the original attachment may already be a text PDF that skips this whole process. [CheapBankConvert](/get-started) is built for that kind of text-based PDF and plans to show a free 2-page preview before you pay; it is not open yet.