Bank statement or invoice from PDF to Excel

Updated on October 15, 2026

Your accountant wants last quarter’s expenses in a spreadsheet. Or you’re self-employed and just want to see how much you spent on equipment, training or your car. Your bank only gives you PDF statements, and typing them over takes an evening.

Converting a PDF to Excel solves that, as long as the PDF contains real text. This guide explains how it works, where it stops and how to check the result.

First: does your PDF contain real text?

This is the most important question. Open the PDF and try to select an amount with your mouse.

• Can you select it? Then it’s a digital PDF, like the statements from your online banking or invoices from accounting software. You can convert those.
• Can’t you select it? Then it’s a scan or a photo: a picture of the page without readable text. The tool can’t find any numbers in it. So a paper invoice that you scan can’t be converted to Excel.

A tip if you handle a lot of statements: first ask your bank whether you can export your transactions as a CSV file. Your bank’s CSV export is more reliable than any PDF conversion. Use the PDF route for what you can’t get any other way: an old statement, an invoice with a table, an overview from a supplier.

PDF to Excel, step by step

1. Open PDF to Excel.
2. Drag your PDF into the tool or click to choose it.
3. Choose a layout. Pick One sheet per page or Everything on one sheet. For a statement of several pages, one sheet is usually easier to filter and add up.
4. Click Convert to Excel.
5. Download the .xlsx file. It opens in Excel, LibreOffice Calc, Numbers and Google Sheets.

What happens to your table

The tool recognizes tables by their borders, cell backgrounds and column structure. Amounts, percentages and numbers with a thousands separator become real numbers, so you can calculate with them. In tables with lines, cells that span several columns stay merged. Text that runs over two lines in a cell ends up in one cell.

Text outside the tables is kept, row by row, in the order of the page. The tool leaves out page numbers. Headers and footers that come back on most pages are meant to appear only once, but that doesn’t always work. So check that no repeated lines ended up between your transactions.

Amounts like 1.234,56 or -12,50 become real numbers. That’s the European style: a period between the thousands and a comma before the decimals. An amount that can be read in two ways, such as 1.500 in a document without any other decimals, stays text. That way, no wrong value ends up in your spreadsheet. Two things you do yourself:

• Dates stay text. Want to sort on them or calculate with them? Convert that column to dates in Excel.
• A separate D/C or Debit/Credit column stays a column of letters, and the amount next to it is positive. You add the minus sign for expenses yourself, for example with a formula.

Always check the result yourself

A conversion is automatic. Take five minutes for these checks before you send the file on:

• Does the balance add up? The opening balance plus all transactions should give the closing balance. One formula in an empty cell and you know.
• Are all amounts numbers? An amount on the left side of the cell is often text. Excel then leaves it out of the total.
• Debit and credit: check whether expenses are shown as negative numbers or in a separate column, and that it’s the same everywhere.
• Page breaks: check the first and last line of each page. That’s where things go wrong most often.

Why not upload it?

A bank statement says more than you think. Besides your account number and balance, it shows who you pay: your doctor, your union, your landlord. That’s data you’d rather not leave on the server of an unknown service. And many online tools upload your file to their server.

With PDFCommunity, your files are processed on your own device and not uploaded. Are you an accountant working with client data? PDF tools and the GDPR explains how that works. This isn’t legal advice. Check it yourself in your browser’s network tab; Verify that no PDF is uploaded shows you how.

Still need to bundle invoices for your accountant afterwards? Read Combine invoices for your accountant.

Good to know

• No scans. Scanned invoices or photos of receipts don’t give you usable numbers.
• Complex layouts with columns without borders, or tables that run over two pages, can mix up rows. Check those extra carefully.
• Password on the PDF? Some banks protect their statements. The tool asks for the password you know, and the password stays in your browser. Want a copy without a password? Use Unlock PDF.
• Large yearly overviews can be slow or too heavy on a phone. Use a computer.

Frequently asked questions