# Convert PDF to Excel on Mac Free: Preview and Numbers

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-16
- Category: Free tools you already own
- Canonical: https://cheapbankconvert.com/blog/convert-pdf-to-excel-on-mac-free

> Convert PDF to Excel on a Mac free with Preview and Numbers: copy the statement table, fix the paste, and export to Excel or CSV without new software.
You can convert a PDF to Excel on a Mac free with two apps that came with it: Preview to select and copy the statement table, and Numbers to paste it, split the columns and export an Excel or CSV file. It works on PDFs from online banking. It is slow on long statements and cannot read scans.

## Does Excel for Mac import PDF files?

Some versions of Excel for Mac can import a PDF through the Data tab, but the option depends on your version and build, so check before you plan around it. If the menu is missing, Preview and Numbers do the same job with software already on your Mac.

Microsoft documents a PDF connector under Data, Get Data, From File, From PDF. Its [import data from external data sources page](https://support.microsoft.com/en-us/office/import-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a) lists Excel for Microsoft 365 on Windows and Mac among the products it applies to. A page that covers several platforms does not promise that every build has every connector. The quick test is to open Excel, click the Data tab and look under Get Data for a From File entry that offers From PDF.

If you have it, the import route is the better one for tables, because Excel finds the table for you instead of making you copy it by hand. The steps are written up in [importing a PDF to Excel with Get Data](/blog/import-pdf-to-excel-free), so this post does not repeat them.

If you do not have it, nothing stops you. Preview comes with every Mac, Numbers is Apple's free spreadsheet app, and Numbers can write an .xlsx file. The rest of this post follows that route, since it needs no account and costs nothing.

One limit applies to every method here: the PDF must contain real text. If you can drag your cursor across a line in Preview and highlight words, it does. If the page highlights as one big picture, it is a scan, and copying will return nothing. Scans need OCR first, which [converting a scanned PDF to Excel for free](/blog/convert-scanned-pdf-to-excel-free) covers.

## Copying a statement table from Mac Preview into Numbers

The Preview route has four short stages: select the table text, copy it, paste it into a blank Numbers sheet, and split the result into columns. It takes a few minutes for a one-page statement and grows with every page, because Preview copies one selection at a time.

Here is the full step list, with an example statement in mind. The sample is one page of a checking statement with a date, a description, a withdrawal, a deposit and a balance column.

1. Open the PDF in Preview by double-clicking it. If another app opens it, right-click the file and choose Open With, then Preview.
2. Switch to the text selection tool. In Preview's toolbar the tool menu offers Text Selection. The cursor should turn into an I-beam over the text.
3. Drag from the first character of the first transaction to the last character of the last balance on the page. Leave out the header block and the footer.
4. Press Command-C to copy.
5. Open Numbers and start a blank spreadsheet. Click cell A1.
6. Press Command-V to paste. Numbers puts the text into cells, usually one line of the statement per row.
7. Check the result against the PDF. Count the rows, and compare the first and last balance.
8. Split the columns if they landed together in one cell (see the edge case below).
9. Choose File, Export To, then Excel or CSV, and save the file.

### What a clean paste looks like

A clean paste puts each transaction on its own row, with the date, description and amounts in separate columns. You get it only when the copied text carries breaks between columns, which some statements do and many do not. Here is an example of the result you want, with made-up values:

| Date | Description | Withdrawal | Deposit | Balance |
| --- | --- | --- | --- | --- |
| 03/02 | Example Grocer #114 | 48.20 | | 1,951.80 |
| 03/03 | Payroll deposit | | 1,200.00 | 3,151.80 |
| 03/05 | Example Power Co | 96.75 | | 3,055.05 |

If your paste looks like this, skip to the export step. If it looks like a single long column, read the edge case section below.

### Multi-page statements

Preview selects text across pages if you drag through them in continuous scroll mode, but each page includes its own header, footer and page number, and those land in your rows. A faster habit is to copy page by page, paste each into the next empty row of the same Numbers sheet, and delete the stray header lines afterwards. For statements that run past two or three pages, expect to repeat this loop for every page.

Selecting only the table matters more than it seems. If you drag across the account summary at the top, its numbers end up in column A beside your dates, and sorting later mixes them in with your transactions.

## Mac Shortcuts for free PDF text extraction

The Shortcuts app on a Mac can pull text out of a PDF without you dragging a selection, but it returns plain text, not a table. It saves the selection step. It does not solve the column problem, so you still land on the same cleanup.

Shortcuts is the Apple app for building small automations from actions. In the action list, look for actions that work with PDFs and text, and chain them so that a PDF goes in and text comes out on the clipboard. You can then paste into Numbers exactly as in the step list above. The set of actions varies by macOS version, so open the action search in Shortcuts and try searching for "PDF" and "text" rather than relying on a name from a blog.

The honest case for building one is volume. If you handle the same kind of statement every month, a shortcut that takes the file and fills the clipboard removes the dragging. If you convert one statement a quarter, building and testing the shortcut takes longer than selecting text by hand.

What a shortcut cannot do:

- It cannot tell a table from a paragraph, so the columns arrive as a line of text.
- It does not remove repeated page headers, page numbers or the footer disclaimer.
- It cannot read a scanned page that has no text layer.

Treat Shortcuts as a replacement for steps 2 to 4 in the list above, and nothing more. Everything after the paste, the splitting, the checking and the export, stays manual.

## Exporting Numbers to Excel or CSV on a Mac

Numbers exports through the File menu: File, Export To, then Excel or CSV. Excel gives you an .xlsx workbook that keeps formatting. CSV gives you a plain text file of values that opens in any spreadsheet or budgeting app. Pick Excel for working files and CSV for imports.

### Export to Excel

Choose File, Export To, Excel. Numbers writes an .xlsx workbook. Click Next, name the file, pick a folder and save.

Open the saved file in Excel and check three things before you trust it:

1. The amount columns are numbers, not text. Click a cell and look for a left-aligned value or a small green triangle. If you see either, the number is stored as text and a sum will skip it.
2. Dates are real dates. Click one and see whether Excel shows it as a date in the formula bar.
3. The row count matches the PDF.

### Export to CSV

Choose File, Export To, CSV. Numbers writes the table as comma-separated text. A CSV holds one sheet only, has no formatting, and keeps whatever the cells show, so fix thousands separators and negative signs first. If a budgeting app is your goal, the rules for a CSV that imports cleanly are in [converting a PDF to CSV for free](/blog/convert-pdf-to-csv-free#what-makes-a-free-csv-file-import-cleanly).

Mac users sometimes ask about converting to CSV with no spreadsheet app at all. The answer is that you do not skip the table step: something has to turn lines of text into columns, and Numbers is the free tool for that on a Mac.

### Fixing text numbers after export

Amounts pasted from a PDF often arrive as text, especially negatives written as 1,234.56- or with a trailing CR. In Numbers, select the amount column and set its data format to Number before exporting, then confirm a total at the bottom of the column matches the PDF. A sum that returns zero is the sign of text numbers.

## Mac paste edge case: every column on one line

When every column of a statement lands in one cell, Preview copied the text as a line and not as a table. The rows have not collapsed in the file. Numbers received one string per line, so you split each string into columns yourself.

This happens most with statements that use spaces to line up their columns, instead of a drawn grid. Preview has no way to know where one column ends and the next begins, so it hands over each visual line as a block of text.

Here is the before state, with made-up values. Column A holds this on each row:

`03/02 Example Grocer #114 48.20 1,951.80`

### How to split it

Numbers does not have a Text to Columns command like Excel does, but it can split text on a delimiter in another way. Two practical options:

- **Paste into Excel instead.** If you own Excel, paste the single column there and use Data, Text to Columns. The method is described in [Text to Columns for copied PDF data](/blog/how-to-copy-a-pdf-into-excel#text-to-columns-splitting-copied-pdf-data). It splits on spaces, which works for dates and amounts.
- **Use a separator-aware paste.** If you paste into a plain text editor first and replace runs of spaces with a tab or comma, Numbers will place tab-separated text into columns when you paste it back.

### The description problem

Splitting on spaces breaks the description. "Example Grocer #114" becomes three columns, and a description of five words becomes five. The fix is to split from the right: the last two items on a line are the amount and the balance, and the first item is the date. Everything in between is the description. Do the split, then join the middle pieces back together with a formula, such as TEXTJOIN in Excel.

Wrapped lines add a second problem. A long description that wraps in the PDF arrives as two rows, and the second has no date or amount. Merge those back into the row above before you sort or total anything. Deleting them is the common mistake, because it throws away part of the payee name.

## Is the free Mac route worth it for a 20-page statement?

For a 20-page statement the free Mac route is rarely worth it: plan on roughly an hour or more of copying, splitting and checking. For one or two pages it is a good deal. The break-even depends on your time, and you can measure it with a single page.

These numbers are estimates, not measurements. Time yourself on one page of your own statement to get real ones. The table assumes a statement with about 40 rows per page, using the steps above.

| Statement length | Copy and paste | Split and fix columns | Check against the PDF | Rough total |
| --- | --- | --- | --- | --- |
| 2 pages | 3 min | 5 min | 3 min | 10 to 15 min |
| 10 pages | 10 min | 20 min | 10 min | 40 to 50 min |
| 20 pages | 20 min | 40 min | 20 min | 80 min or more |

The check step grows because every added page adds rows where a dropped line or a stray header can hide. Compare the opening and closing balances of the statement with your totals to catch a gap, and then scan for the page boundaries, where most lost rows sit.

### Putting a price on the hour

Multiply the minutes by what your time is worth. At an example rate of $20 an hour, 80 minutes costs about $27 of your time. [CheapBankConvert](/get-started) lists $5.99 for a statement of 11 to 40 pages, with the first 2 pages previewed free, though it is still getting ready to open and those are early prices. A converter wins when your time is worth more than a few dollars an hour and the file is long.

The Mac route wins when the statement is short, you convert one now and then, or the document is not sensitive to the small errors a hand-built sheet can carry. It also wins when you simply want to learn how the data is laid out.

For the full price arithmetic across options, see [what a cheap bank statement converter costs per statement](/blog/cheap-bank-statement-converter). If you also have a Microsoft 365 plan, the Word route is another free path, written up in [converting a PDF to Excel with Office 365](/blog/convert-pdf-to-excel-office-365). If you like to compare tools you can run yourself, [open source PDF to Excel converters](/blog/pdf-to-excel-converter-open-source) are the third option, with a larger setup cost.