Yes, you can convert a PDF to Excel for $0, as long as the PDF holds real text and not a picture of text. Excel can import tables from a PDF itself, and Word, Google Docs and plain copy and paste all work as backups. Expect to spend time cleaning the result.
Can I convert PDF to Excel with Microsoft Excel alone?
Excel can convert a PDF by itself if your version has the Get Data tool, which reads tables straight out of a PDF file. Microsoft lists a PDF connector among the data sources it supports in Microsoft's list of Excel data sources. Check your Data tab for Get Data.
The tool does not turn the PDF into a spreadsheet in one click. It scans the file, offers you a list of the tables it found, and loads the one you pick. On a bank statement, that list may hold one table per page, or one joined table when the pages share a layout, plus a few false hits such as the summary box on page one.
The rest of this post compares that route with three others. If you want the click-by-click version of the Excel route, the Get Data from PDF steps cover every screen.
What "convert" means here
A PDF stores where each word sits on a page. It does not store rows and columns. Every free method is therefore a guess: the software looks at how words line up and decides which ones form a table. A statement with clean ruled lines gives the software an easy guess. A statement with loose spacing, wrapped descriptions and a logo in the corner gives it a harder one.
That is why the same file can import perfectly through one method and badly through another. It is also why the answer to "can I turn a PDF into an Excel spreadsheet" is yes, with a condition: you will probably check and repair what comes out.
A quick test before you start
Open the PDF and try to select one line of text with your cursor. If the highlight follows the words, the file holds text and every method below can work. If the highlight draws a box around the whole page, the file is an image, and the section on OCR applies to you.
Four $0 ways to turn a PDF into an Excel file, ranked by effort
The four free methods are Excel Get Data, opening the PDF in Word, Google Docs plus Sheets, and copy and paste. They are ranked here by the work needed to get usable rows from a bank statement, with the least work first. The minutes are my estimates for a five-page text statement, not measured results.
| Rank | Method | What you need | Estimated minutes for five pages | Typical result |
|---|---|---|---|---|
| 1 | Excel Get Data | Excel with the Get Data tool | 10 to 15 | Tables by page or joined across pages, columns mostly right |
| 2 | Word reflow | Word and Excel | 20 to 30 | A Word table that survives paste if the layout is simple |
| 3 | Google Docs and Sheets | A Google account | 20 to 30 | Text with columns often merged, needs splitting |
| 4 | Copy and paste | Any PDF reader and Excel | 30 to 45 | Everything lands in column A until you split it |
Treat these minutes as a starting range. A statement with long wrapped descriptions will push any method to the high end, and a short statement with a tidy grid will beat the low end.
Why Excel Get Data ranks first
Excel keeps the table structure the PDF suggests, and it lets you keep working inside the same tool. You can load all pages, join them and fix columns with Power Query without copying anything by hand. The weakness is the setup: you need the right Excel version, and you need to choose the right table from the list.
Why Word reflow ranks second
Word opens a PDF by rebuilding it as an editable document. For a simple statement, the transaction list comes out as a Word table that you can paste into Excel. For a busy layout, Word often turns the page into floating text boxes, and then you are back to retyping. It costs nothing to try, so it is a sensible second attempt.
Why Google Docs and Sheets ranks third
Google Drive can open a PDF in Google Docs and read the text. Google's help page on converting images and PDFs to text says that bold, italics and line breaks are likely to be kept, while tables and columns are not likely to be detected. That matches what a statement shows: the words arrive, but the grid does not. The Google Sheets route in detail covers the splitting step.
Why copy and paste ranks last
Selecting the table in a PDF reader and pasting into Excel needs no extra tools, so it works everywhere. It also gives the least structure, because each statement line often pastes as one long string in a single cell. You then split that string yourself. The people who do this most often are the ones who have no other tool, and the time adds up on a statement with hundreds of lines.
Which PDF files won't convert to Excel without OCR?
Scanned PDFs and photographed statements will not convert without OCR, short for optical character recognition, which is software that reads the shape of letters in an image and turns them into text. If you cannot select the text in a PDF, none of the four methods above can read it directly.
You can tell the types apart in a few seconds:
- Text PDF: downloaded from online banking. You can select and search the words. Every method works.
- Scanned PDF: made on a flatbed scanner or a phone app. Each page is an image. Searching for a word you can plainly see finds nothing.
- Mixed PDF: a text statement with a scanned page added, for example a page the bank mailed that you scanned and merged. Part of it converts, and part of it gives nothing.
What happens when OCR is missing
Excel's Get Data will show an empty Navigator list or only a page with no usable table. Word may open the file and show each page as a picture. Copy and paste will paste nothing at all, or a blank cell. This is the classic "why does my PDF give nothing?" case, and the fix is not a different free setting. The file needs OCR first.
Google Docs is the one built-in route that runs OCR for you, as the Google help page above describes, and that makes it the first free thing to try on a scan. Google lists conditions for good results, including sharp images, text that is not too small and pages that are right side up. A phone photo of a statement taken at an angle breaks those conditions, and the result will show it in the numbers.
The risk of OCR on money columns
OCR on a bank statement carries a particular danger. A misread digit still looks like a number, so the file seems fine. A 3 read as an 8 changes an amount without raising any error. If you OCR a statement, check the running balance column against the printed one before you trust any row. The best prevention is to download the PDF from your bank instead of scanning a paper copy, because the downloaded file holds exact text.
What a $0 PDF to Excel method costs in cleanup time
A free method costs no money but costs your time, and the time depends on how many repairs the output needs. The repairs for a bank statement are the same few every time: joining pages, removing repeated headers, splitting merged columns, fixing dates and turning text amounts into numbers.
A worked example
Here is an example with made-up numbers. Say you convert a five-page statement with 140 transaction lines through Get Data. These are estimates, not measurements:
| Step | Estimated minutes |
|---|---|
| Open the file and pick the five tables | 4 |
| Append the pages into one table | 3 |
| Remove header rows repeated on each page | 3 |
| Fix dates and amounts stored as text | 4 |
| Check the total against the statement | 3 |
| Total | 17 |
If you value your time at $20 an hour, 17 minutes is about $5.67. At $30 an hour it is $8.50. Run the sum with your own rate. The arithmetic matters because a paid conversion of a statement this size can cost less than that. CheapBankConvert, for instance, lists $2.99 for a statement of up to 10 pages as early pricing, with the first 2 pages free to preview.
The cleanup that people forget
Two repairs catch people late. The first is the negative amounts problem: some statements print debits as positive numbers in a Withdrawals column, and the import keeps them that way, so a sum of the column gives nonsense until you flip signs. The second is the wrapped description, where a long payee name runs onto a second line and arrives as a separate row with no amount. Delete or merge those rows, or your row count and your balance will not match the statement.
Counting the first time versus the tenth
The first conversion is the slow one, because you are learning the clicks. The second goes faster. A repeat conversion with the same bank goes faster again, because the layout is the same each month. If you convert one statement a year, you pay the learning cost every year. If you convert one a month, the free method gets cheaper per statement as you go.
When not to DIY a PDF to Excel conversion
Doing the conversion yourself stops making sense when the cleanup time costs more than a paid conversion, when the file needs OCR, or when an error in the numbers would cost you. Those three cases cover most of the situations where people regret the free route.
Consider paying in these cases:
- The statement is long. Past about ten pages, every extra page adds another table to join and another set of repairs.
- The PDF is a scan. Free OCR is hit and miss on money columns, and a wrong digit may stay hidden.
- You have many statements. Twelve months of statements at 17 minutes each is more than three hours.
- The numbers go to someone else. A tax preparer, a lender or a landlord will rely on them, and a silent error is expensive.
- You need the amounts as real numbers. Text amounts break sums, and the fix is yet another step.
What a paid option looks like here
If you decide to pay, pay for the one document and nothing more. CheapBankConvert charges once per statement and shows the first 2 pages converted before you pay. It is not open yet, so Get started puts you on the list rather than converting today.
A simple decision rule
Try the free method on one statement and time yourself. If you finish in under ten minutes with correct totals, keep doing it that way. If you pass twenty minutes, or the totals do not match the statement, price the paid option. The point is to decide with numbers from your own file. For the Mac version of these methods, copying a statement into Numbers on a Mac has its own steps, and copy and paste cleanup with Text to Columns covers the last-resort method in full. If you only need to know why a PDF will not open in Excel at all, the guide to putting a PDF into Excel explains the difference between opening and importing.