How to convert a PDF to Excel
Choose the PDF. Its pages are read on this device and every table becomes rows and columns at once, so the preview shows the spreadsheet before you save it. Download it as an Excel file (.xlsx) or a CSV file, or copy it and paste it into Google Sheets or Excel.
The tool reads where each piece of text sits on the page: words on the same line make a row, and the stretches of the page that the rows fill make the columns, so a column of amounts lined up on the right stays one column. Text above and below a table, such as a bank's name or an address, comes out as rows of its own unless you untick it.
Amounts become numbers that Excel can add up. 1,234.56, (45.00) and 12.50- are read as numbers, and each cell keeps the decimals, thousands separators, currency sign or percent the PDF shows. The tool sees whether the file writes 1,234.56 or 1.234,56; choose it yourself if a file mixes both. Dates, account numbers that start with 0 and everything else stay text, exactly as the PDF writes them.
On a statement that runs over several pages, the column headings repeated at the top of each page are left out, so the rows follow on in one sheet. Choose a sheet for each page instead if the pages hold different tables.
Worked example
The example is a two-page bank statement made on this page: an opening balance and 9 transactions under the headings Date, Description, Amount and Balance. The spreadsheet has 13 rows: the bank's name, the statement's title, the headings once and the 10 lines of the table, with the amounts and balances as numbers. The headings and the bank's name repeated on page 2 are left out.
Before you rely on the result
One PDF of up to 200 MB at a time, without a password. Only text stored as text is read: a scanned page is a picture and needs OCR, which this tool does not do. Columns come from where the text sits, so a table needs no lines between its cells, but a cell that holds several lines of text gives a row for each line unless you join them. Merged cells, colours, fonts and lines do not come across, and text turned on its side is left out. In the CSV file, text that starts with =, +, - or @ gets an apostrophe in front, so a spreadsheet does not run it as a formula. Nothing is uploaded.
Cite this page
ToolOctopus. “PDF to Excel converter.” Updated . https://tooloctopus.com/pdf-to-excel.
Add an access date if your instructions require one.
Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. License and source code.