How to import a PDF bank statement into a spreadsheet: four ways compared

The four ways at a glance

Pick by what you have in hand, not by what sounds clever. The table is the short version. The sections below explain each row.

None of these fixes a scanned statement. A scan is a picture of numbers. The free PDF to text tool linked below shows in seconds whether your PDF has any text at all.

Way 1: the built-in PDF import

Newer Excel versions can read a PDF directly. On the Data tab, open Get Data, then From File, then From PDF. Pick the file. A Navigator window lists the tables and pages the program found. Select one or several, then choose Load, or Transform Data to clean them first.

Microsoft added this in 2020, first for Office 365 subscribers. Its version table today lists the PDF connector for Microsoft 365 and Microsoft 365 Apps for Enterprise. The same table does not list it for Office 2016 or Office 2019 (the one-time purchase editions). It also notes that the PDF connector needs .NET Framework 4.5 or later. Excel on the web and other spreadsheet programs differ, so check Microsoft's page for your version.

It works well when the statement is a real text PDF with a clear table: a header row, one transaction per row, and visible lines or steady spacing between columns. Then you get proper columns for date, description and amount.

It breaks on bank layouts in predictable ways:

• A long description wraps onto a second line, and the second line becomes a row with no date or amount.
• Two columns that sit close together merge into one cell.
• Debit and credit are separate columns on page 1 and one signed column on page 2, so the tables do not join.
• Page headers, footers and the "balance carried forward" lines arrive as data rows.
• Dates and amounts arrive as text, for example 1.234,56 where your computer expects 1,234.56.

Microsoft's PDF connector has settings for some of this, but you set them by editing the query, not in a dialog. The function is called Pdf.Tables. StartPage and EndPage limit the pages. MultiPageTables decides whether similar tables on neighbouring pages are joined, and it is on by default. EnforceBorderLines decides whether drawn lines always count as cell edges, and it is off by default. If you are comfortable in the query editor, try these. If not, expect to clean the result by hand.

Several statements at once: Microsoft says to use a folder connector instead of picking files one by one. It is a bigger setup, so it pays off only if you do this every month.

Way 2: copy and paste from the PDF viewer

Open the PDF, select the transactions, copy, and paste into a sheet. It takes a minute and needs nothing installed.

It works when you need three lines from one page. It fails on anything bigger. Most of the time every line pastes into one column as a single piece of text: date, description and amount run together. You then split it with Text to Columns on the Data tab. That wizard splits on a delimiter or at a fixed width. Descriptions that contain spaces make the fixed width fragile, because one long name moves every figure to the right.

Other things that go wrong:

• Selecting across a page break picks up headers and footers.
• Amounts paste as text. A cell that looks like a number but sits on the left is text, and a sum ignores it.
• A minus sign or a trailing "CR" or "DR" does not turn into a negative number by itself.

Use it for a quick look. Do not build a month of bookkeeping on it.

Way 3: ask the bank for a CSV or spreadsheet download

This is the cleanest route when it exists. Most online banking has a download or export option on the transactions page. Look for CSV, XLS or XLSX in the export menu. A file the bank generates from its own records has one transaction per row, a real date column and real numbers.

Check these before you rely on it:

• How far back it goes. Many banks let you export only a limited range, while the PDF statements go back further. Ask the bank how far back each goes.
• Whether the file includes the running balance. Without it you cannot do the balance check in the next section.
• Whether the format fits your tool. Banks differ on date order, decimal commas and sign conventions.

A CSV opens by double-clicking, or through Data, then From Text/CSV. Microsoft notes that when Excel opens a CSV, it uses your current default data format settings to read each column. If a date or an amount comes out wrong, use the import wizard and set the column format yourself instead of fixing cells afterwards.

Way 4: a desktop converter

A desktop converter is a program on your own computer that reads the PDF and writes rows. It is built for the layouts that trip up the built-in import. A good one understands that a wrapped line belongs to the transaction above it, and it reads debit and credit columns correctly.

It suits you if you handle many statements, or you do this every month, or you do not want to upload bank files anywhere.

What to check in any converter, desktop or online:

• It reads text PDFs. Ask plainly whether it handles scans, and do not assume it does.
• It checks the arithmetic: opening balance plus movements equals closing balance.
• It exports to the format your next step needs, such as CSV, XLSX or a file your accounting software imports.
• It shows you the rows before you save them, so you can correct a line.

No converter is perfect. Layouts vary from bank to bank. Treat the output as a draft you review.

Before you upload a statement to an online converter

A bank statement holds your name, your address, your account number and every payment you made. An online converter receives all of it. Most are run by people you cannot identify.

The FBI Denver office warned in March 2025 about a scam built on free online document converters. It says the sites do the job they advertise, but the resulting file can hide malware. It also says such tools can scrape the files you submit for personal information, banking information, email addresses and passwords. The FBI's advice is to slow down and keep your virus scan up to date and scan files before opening them.

If you still decide to use one, check this list first:

1. Who runs it. A company name, a postal address and a way to contact them, not just a form.
2. What it says about your files. A clear statement of how long it keeps them and whether it deletes them. No statement is a bad sign.
3. Whether the address starts with https, and whether you typed the address yourself. Search ads and look-alike names are how people end up on the wrong site.
4. Whether it asks you to install something or to sign up with a card before it converts one page. That is a reason to leave.

If any answer is unclear, do not upload. A desktop tool or a bank CSV avoids the question.

Check the result before you use it

Whatever you used, run the balance check. It takes two minutes.

1. Take the opening balance from the top of the statement.
2. Add all credits and subtract all debits from your rows.
3. The result must equal the closing balance printed on the statement.

A difference means a row is wrong or missing. A flipped sign changes the total by twice the amount. A debit of 50.00 read as a credit moves the total by 100.00, so a gap of 100.00 points to a 50.00 line. A gap equal to one amount points to a missing or doubled row.

Then check the first and last row of every page, where lines get lost or doubled. A matching total does not prove every row is right, because two errors can cancel, but it is the best quick test you have. Keep the original PDF: it is the record.

Questions

Keep reading

More guides

About Ledgerpour

Ledgerpour is our Windows app that turns PDF bank and credit card statements that contain text into CSV, XLSX, QBO or CAMT.053 files, and checks that the balances add up before you import. It does not read scanned pages. Review the converted data before you use it in your books. It is not in the Microsoft Store yet.

Sources

• Microsoft Support: Power Query data sources in Excel versions
• Microsoft Learn: Power Query PDF connector
• Microsoft Excel blog (2020): Announcing data import from PDF documents
• Microsoft Support: Import or export text (.txt or .csv) files
• Microsoft Support: Split text into different columns with the Convert Text to Columns Wizard
• FBI Denver (2025-03-07): Online File Converter Scam

Checked 2026-11-03.