Convert a PDF Bank Statement to Excel on a Mac

TL;DR On a Mac, you have three realistic ways to get a PDF bank statement into Excel: copy and paste from Preview (fine for a page or two), import and clean in Excel for Mac or Numbers (better for a few statements), or use a converter that runs in the browser and gives you a ready-made Excel or CSV file (best for many pages or regular work). Whichever you choose, finish the same way: one row per transaction, real dates, one signed amount column, and a check that the opening balance plus all transactions equals the closing balance. Some Windows-only tricks, such as importing PDFs with Power Query, may not be available in your version of Excel for Mac, so don't count on them.

Most guides to converting bank statements assume Windows. That's frustrating if you're on a MacBook, because a few of the standard recommendations either don't exist on macOS or work differently. The good news is that you don't need Windows to do this well. macOS has decent built-in tools, Excel for Mac handles the clean-up, and browser-based converters don't care what operating system you use.

This guide covers each approach, the Mac-specific quirks you'll hit, how to clean the result, and how to prove the spreadsheet is complete.

What you're aiming for

Whatever method you use, the end result should be a table like this:

The figures are illustrative.

• One row per transaction. Wrapped descriptions joined back to their line.
• Real dates, not text, in the order your bank uses.
• One signed Amount column. Money in positive, money out negative.
• The balance, if your statement shows it, for checking.
• No headers, page footers or subtotals mixed into the data.

Before you start: is it a real PDF or a scan?

Open the statement in Preview and try to select a word with the text tool. If you can highlight individual words, it's a digital PDF with real text, and any of the methods below will work.

If clicking selects the whole page like a picture, it's a scanned image. You'll need text recognition first. Recent versions of macOS include Live Text, which lets you select text in images, and some PDF tools can run OCR. Accuracy varies with scan quality, so check the numbers carefully. Our guide to OCR accuracy on scanned bank statements explains what usually goes wrong and how to spot it.

Method 1: copy from Preview and paste into Excel

Good for: one or two pages, occasional use.

1. Open the PDF in Preview.
2. Select the transaction area with the text selection tool. Holding the Option key while dragging lets you select a rectangular block in many cases, which helps avoid grabbing headers and footers.
3. Copy with Command+C.
4. In Excel for Mac, click cell A1 on a blank sheet and paste with Command+V.

What usually happens next:

• Everything lands in column A. Use Data, then Text to Columns. Choose Delimited and try Space, or choose Fixed width and set the column breaks yourself.
• Descriptions with spaces get split across several columns. Fixed width usually handles this better than Delimited.
• Wrapped lines become separate rows. You'll need to join them back. Sort or filter to find rows with no amount, then merge their text into the row above.
• Amounts arrive as text. Fix with VALUE or NUMBERVALUE (see clean-up below).

If pasting into Excel gives a mess, try pasting into TextEdit first with Command+Shift+V (paste and match style) to see what you actually copied, then paste that into Excel. Sometimes the plain text version splits more cleanly.

Method 2: open in Numbers, then move to Excel

Good for: a few pages, especially if you don't have Excel.

Numbers is free on every Mac. Copying a table from Preview into Numbers sometimes keeps the columns better than Excel does, depending on how the PDF was built. Try it on one page and compare.

Once the data is in Numbers:

1. Clean it there, or
2. Export to Excel with File, then Export To, then Excel. You can then continue in Excel for Mac, or upload the file to Google Sheets.

Numbers also opens CSV files well, so if your bank offers a CSV download for recent months, opening it in Numbers is a quick way to check it before importing anywhere.

Method 3: Excel for Mac's own tools

Excel for Mac has steadily gained Power Query features, but some data connectors that exist on Windows, including importing directly from PDF, have historically been missing or limited on Mac. Check Microsoft's current documentation for your version before relying on it. If your version can't import PDFs, you'll get the data into Excel by pasting or by opening a converted file, and then use Excel for the clean-up, which it handles perfectly well on a Mac.

The clean-up tools that work the same on Mac and Windows include Text to Columns, Flash Fill, TEXTSPLIT and TEXTBEFORE/TEXTAFTER in recent versions, NUMBERVALUE, DATE, Remove Duplicates, tables and pivot tables.

If you want to read about the Windows Power Query route, our Power Query bank statement guide covers it.

Method 4: a browser-based converter

Good for: many pages, multiple statements, regular bookkeeping work.

A converter that runs in the browser works the same on a Mac as anywhere else. SheetStatement reads the statement PDF, puts each transaction on one row with a signed amount, and checks the opening balance plus activity against the closing balance before you download Excel or CSV, or files for QuickBooks and Xero. It works in Safari, Chrome or Firefox. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

The advantage is less clean-up: dates, descriptions and amounts arrive in the right columns, and you can see straight away whether the statement balances.

For a wider comparison of approaches, including their pros and cons, see PDF to Excel bank statement methods compared.

Which method should you choose?

The real cost of the manual methods isn't the copying; it's the checking and fixing afterwards. If you find yourself spending more than a few minutes per page, the time is usually better spent elsewhere.

Cleaning the data in Excel for Mac

Whatever method you used, finish with these checks.

Dates

Dates are the most common problem. If your statement uses a different date order from your Mac's region settings, Excel will misread some dates and leave others as text. Check by sorting: if dates don't sort into the statement period, or some are left-aligned, they're not right.

To rebuild a text date in MM/DD/YYYY form:

=DATE(RIGHT(A2,4), LEFT(A2,2), MID(A2,4,2))

For DD/MM/YYYY, swap the month and day parts:

=DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))

If the statement shows dates without a year, add the year from the statement period. Your Mac's date format is set in System Settings under language and region; Excel for Mac uses it when interpreting typed or pasted dates. Our guide to fixing bank statement dates in Excel covers more cases.

Amounts

Text amounts with dollar signs, commas or trailing minus signs won't sum. Convert them:

=NUMBERVALUE(SUBSTITUTE(B2,"$",""))

For a trailing minus such as 45.00-:

=IF(RIGHT(B2,1)="-", -NUMBERVALUE(LEFT(B2,LEN(B2)-1)), NUMBERVALUE(B2))

If your statement has separate withdrawal and deposit columns, create one signed amount:

=N(D2) - N(C2)

where C is withdrawals and D is deposits. See separating debit and credit columns for the reverse.

Stray rows

Filter the Amount column for blanks. Rows without an amount are usually headers, page footers, "balance forward" lines or the second half of a wrapped description. Delete the first three kinds; join wrapped descriptions to the row above. Our guide to cleaning bank statement data in Excel covers more techniques.

Credit card statements

Credit card statements work the other way around: purchases increase the balance owed and payments reduce it. Decide on one sign convention before you combine card data with your checking account. For spending analysis, purchases negative and payments positive is usually easiest, so both accounts can sit in the same table.

Non-breaking spaces

Text copied from PDFs sometimes contains non-breaking spaces that look like normal spaces but stop numbers from converting. Remove them with:

=SUBSTITUTE(B2, CHAR(160), "")

Prove the statement balances

This step is what separates a spreadsheet you can trust from one that only looks right. Turn the data into a table (Command+T) named Tx, then:

=ROUND(OpeningBalance + SUM(Tx[Amount]) - ClosingBalance, 2)

The result should be 0. If it isn't:

• Equals one transaction: a row is missing, often at the top or bottom of a page that you didn't select when copying.
• Twice a transaction: a sign is wrong.
• A round number: a misread digit, common with scans.

Copy and paste methods are especially prone to missing a row at a page break, because you select each page separately. If the statement shows a running balance, you can find exactly where an error starts by recalculating the balance on each row; see our running balance formula guide. The free balance checker is a quick way to confirm totals.

Keyboard shortcuts worth knowing on Mac

A few Excel for Mac shortcuts speed up clean-up considerably:

• Command+T: turn a range into a table.
• Command+Shift+L: turn filters on or off.
• Command+D: fill a formula down.
• Control+Shift+Down arrow or Command+Shift+Down arrow, depending on your settings: select to the end of the data.
• Command+Option+V: Paste Special, useful for pasting values only after a formula.

Shortcut behaviour can differ slightly between Excel versions and keyboard settings, so if one doesn't work, check Excel's Help menu for your version.

A worked example: a freelancer on a MacBook

A freelance photographer needs six months of checking account statements in Excel for her accountant. She uses a MacBook and Excel for Mac.

1. Check the PDFs. She can select text in Preview, so they're digital.
2. Try copy and paste. The first page pastes into column A. Fixed-width Text to Columns splits it reasonably, but descriptions with merchant locations wrap onto second lines, and it takes twenty minutes for one page.
3. Switch to a converter. Six statements are twenty-two pages. She uploads them to a converter in Safari, downloads Excel files, and opens them in Excel for Mac.
4. Check dates and amounts. Dates are real dates in the right order. Amounts are signed numbers.
5. Balance. Five statements balance immediately. One is out by the value of a single deposit; a line at the top of page three was missed. She adds it from the PDF.
6. Combine. She appends the six tables into one with a Statement column. Our guide to combining multiple bank statements shows how.
7. Categorize. She adds a Category column using a keyword lookup table; see Excel formulas to categorize transactions.

She sends her accountant the original PDFs and the workbook.

Organizing statement files in Finder

A little file discipline makes everything easier later, particularly at tax time.

• One folder per account, with a subfolder per year if you keep many years.
• Consistent names such as checking-2026-03.pdf. Finder sorts these correctly, so a missing month stands out.
• Keep the original PDFs next to the spreadsheet. If a number is ever questioned, you can go straight back to the source.
• Use tags if you like: a colour tag for "converted" and another for "reconciled" lets you see progress at a glance.
• Back up. Statements are worth keeping; check how long your accountant or local rules suggest keeping financial records.

If you're converting a large backlog, such as a year or more of statements for catch-up bookkeeping, work one account at a time and balance each statement before moving on. Our guide to catching up on bookkeeping from bank statements covers the workflow.

Using Google Sheets on a Mac

If you don't have Excel, Google Sheets in the browser is a solid alternative. You can upload a CSV or Excel file and work there, or paste data directly. Our guide to bank statement PDFs in Google Sheets covers that route, and Google Sheets QUERY for bank transactions shows how to summarize the data once it's in.

Importing into accounting software from a Mac

Accounting tools like QuickBooks Online and Xero are browser-based, so the Mac makes no difference to importing. Export a CSV from Excel for Mac with File, then Save As, choosing CSV UTF-8 or Comma Separated Values, then upload. See importing into QuickBooks Online and Xero's CSV import format.

If you use desktop accounting software, check whether there's a Mac version. Some desktop accounting packages are Windows-only, and the Mac editions, where they exist, can have different import options. QuickBooks Desktop for Mac, for instance, has differed from the Windows edition over the years; check Intuit's documentation for your version.

Convert bank statements on your Mac

Upload a statement PDF to SheetStatement from Safari or any browser, check the rows and the balance check, and download Excel or CSV. The free plan includes 3 pages a month, enough to test it on a real statement.

FAQ

Can Excel for Mac import a PDF directly?

Importing PDFs directly through Power Query has historically been a Windows feature. Check Microsoft's documentation for your version of Excel for Mac. If it isn't available, paste the data or open a converted Excel or CSV file instead.

What's the quickest free way on a Mac?

For a page or two, copy from Preview and paste into Excel or Numbers, then use Text to Columns. For more pages, a converter saves a lot of clean-up time.

Why does everything paste into one column?

PDFs store text positions, not table cells. Use Text to Columns with fixed width to split the data, or try pasting into Numbers instead.

How do I convert a scanned statement on a Mac?

You'll need text recognition first. macOS Live Text and some PDF tools can recognize text in images. Check every figure carefully, because scans produce more errors than digital PDFs.

Why are some dates wrong after pasting?

The statement's date order doesn't match your Mac's region settings. Rebuild the dates with DATE, LEFT, MID and RIGHT, or change the import settings.

How do I know the spreadsheet is complete?

Check that the opening balance plus all amounts equals the closing balance. If it doesn't, look for a missing row at a page break.

Is it safe to upload statements?

See the security page for how SheetStatement processes and stores files, and review any service's policy before uploading financial documents.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.