It is the end of the month and you need to know how much you actually spent on food, fuel and subscriptions. Your bank will happily give you a PDF statement, twelve pages of neat little rows, but it will not give you a spreadsheet. So you start copying rows by hand, or you paste the whole thing into Excel and watch every transaction land in a single column with the dates, descriptions and amounts glued together.
Getting tables out of a PDF and into Excel is one of the most common office chores there is, and one of the most tedious to do by hand. This guide explains how PDF-to-Excel extraction works, which PDFs convert cleanly, and how to turn the result into a spreadsheet you can actually calculate with.
Why copy and paste does not work
A PDF table is not really a table. It is text placed at exact positions on the page, with lines drawn around it for your eyes. When you copy it, most PDF readers give you the text in reading order, one line at a time, with no idea which piece belongs in which column. Paste that into Excel and everything lands in column A.
A proper extraction tool does the opposite: it looks at where each piece of text sits on the page, finds the rows and columns, and rebuilds the grid, so each value goes into its own cell.
How to convert a PDF to Excel
- Check the PDF has real text. Try selecting a single number with your mouse. If you can, it will convert. If the whole page selects as one picture, it is a scan; run it through OCR PDF first.
- Remove any password. Bank and card statements often arrive protected. Use Unlock PDF with the password your bank gave you; our guide on removing a password from a PDF explains the usual formats.
- Open PDF to Excel and choose the file (up to 100 MB).
- Download the .xlsx workbook and open it in Excel, Google Sheets, Numbers or LibreOffice Calc.
The file is sent over HTTPS and deleted from the server as soon as the workbook is returned.
What you get in the workbook
The extraction runs on our server with pdfplumber, an open-source library that detects table grids and reads the text in each cell. The result is organised predictably:
| In the PDF | In the Excel file |
|---|---|
| Each table it detects | Its own sheet, named Table_1, Table_2 and so on |
| The first row of each table | Used as the column headings |
| No detectable tables | A sheet with the text, one line per row, with the page number beside it |
| Colours, fonts and cell shading | Not carried over; you get the data itself |
That last fallback is more useful than it sounds. Even when a PDF has no ruled tables, getting every line of text into rows with page numbers means you can filter, search and split it in Excel instead of retyping it.
Which PDFs convert best
The best results come from PDFs that were generated by software, where the table has clear structure:
- Bank and card statements downloaded from online banking
- Invoices and purchase orders from accounting or shop software
- Price lists, stock reports and timetables
- Financial reports and data appendices
Tables become harder to detect when they have no visible lines, use merged cells across columns, span several pages with repeated headers, or are drawn as images. Those still convert, but expect to spend a little time adjusting columns.
Scanned PDFs are the one type that cannot be extracted directly, because a scan is a photograph of a page. Running OCR PDF first gives the page a text layer. For the cleanest recognition, use a straight, well-lit scan at a decent resolution.
Cleaning up the spreadsheet
Extraction gets the data into cells. A few minutes of tidying turns it into something you can calculate with.
Numbers stored as text. If amounts sit on the left of their cells, or SUM returns zero, Excel is treating them as text. Select the column and use Data, Text to Columns, then Finish, or use the VALUE function. Currency symbols and thousands separators sometimes need removing first with Find and Replace.
Dates as text. Statements write dates in many ways. Text to Columns lets you pick the date format (DMY or MDY) so Excel recognises them properly, which matters when you sort by date.
Tables split across sheets. A statement with one table per page produces one sheet per page. Copy them into a single sheet and delete the repeated heading rows. If you do this every month, Power Query in Excel can combine sheets automatically.
Credits and debits in separate columns. Many statements put money in and money out in different columns. A simple formula such as =C2-D2 gives you a single signed amount per row, which is much easier to total.
Descriptions split over two lines. Long transaction descriptions sometimes wrap onto a second row. Sort by date and amount, and the stray description rows (with no amount) stand out, ready to merge or delete.
Turning a statement into a budget
Once the transactions are in a clean sheet, the useful part begins:
- Add a Category column and label each row: groceries, rent, fuel, subscriptions.
- Create a PivotTable with Category as rows and Amount as values. In seconds you see where the money went.
- Filter by description to find every charge from one shop or service, which is the fastest way to find subscriptions you forgot about.
- Compare months by extracting each month's statement and adding a Month column.
This is the job that PDF-to-Excel saves the most time on. What used to be an evening of retyping becomes ten minutes of sorting.
Only need to edit text? Use Word instead
If the PDF is mostly paragraphs with a table or two, and you need to change the wording rather than calculate, Word is the better destination. PDF to Word rebuilds text, tables and images as an editable document. Our guide to converting PDF to Word without losing formatting explains what to expect.
Going the other way
Once your spreadsheet is ready to share, it is often best sent as a PDF so the layout cannot be accidentally changed. Excel to PDF handles that; set a print area first so wide sheets do not split across pages. And if your data arrives as CSV rather than PDF, CSV to Excel converts it directly with no extraction needed.
Handling financial documents safely
Statements and invoices contain some of the most sensitive data you have: account numbers, balances, addresses and a record of where you spend your money. A few habits keep that data safe:
- Only upload what you need. Extract the relevant pages first with Split PDF, which works in your browser without uploading the file.
- Know where the file goes. With PDF to Excel, the file is sent over HTTPS, converted and deleted from the server as soon as the workbook is returned. Nothing is kept.
- Protect the spreadsheet if you share it. A workbook of transactions is just as sensitive as the statement it came from.
- Redact before sharing statements with landlords or agencies who only need to see certain entries. Our guide to redacting a PDF properly explains how to remove account numbers permanently.
Frequently asked questions
How are tables arranged in the Excel file?
Each table the tool finds goes on its own sheet, named Table_1, Table_2 and so on, with the first row used as headings.
What if my PDF has no tables?
The text is exported instead, one line per row with the page number beside it, so you can still work with it in Excel.
Does it work with scanned statements?
Not directly. Scans contain no text. Use OCR PDF first, then convert the result.
Why are my numbers not adding up?
They have been imported as text. Convert them with Text to Columns or the VALUE function.
Are colours and formatting kept?
No. The tool extracts the data in each cell; formatting is not carried over.
Is it free?
Yes, with no sign-up or watermark.
The PDF is where your numbers start, not where they should stay. Check that the file has real text, extract it with PDF to Excel, spend a few minutes turning text into numbers, and the spreadsheet is ready to answer the questions the PDF never could.
