How to convert PDF to Excel in 4 steps
- Open the PDF. Select it or drop it on the page. Type its password if it has one.
- Choose how the sheets are laid out (see below), and the pages if you need only some.
- Convert. Press Convert to Excel. Tables are found from their lines or from how their columns line up.
- Download the .xlsx file, or CSV files if you ticked that, and open it in Excel, Google Sheets, Numbers or LibreOffice.
A sheet per table, a sheet per page, or everything on one sheet
- A sheet for each table (the default) gives every table its own tab, named after its page, such as “Page 2 Table 1”.
- A sheet for each page keeps each page together: its tables and its other lines of text, in the order they appear.
- All tables on one sheet stacks every table. When a table runs over several pages with the same columns, it becomes one long table, and the column names repeated at the top of each page are left out. This is the layout for statements and long reports.
Real numbers, not text
The most common problem with PDF to Excel is numbers that look right but don’t add up, because they arrive as text. Here every amount becomes a value Excel can calculate with, shown the way the PDF showed it:
| In the PDF | In Excel |
|---|---|
$1,234.50 | 1234.5, shown as $1,234.50 |
(250.00) or 250.00- | −250, shown in brackets or with the minus after |
1.234,56 (European) | 1234.56 |
12.5% | 0.125, shown as 12.5% |
1,250.00 Dr / Cr | −1250 / 1250, shown with Dr or Cr |
12.500 or 1.500.000 (dots for thousands) | 12500 and 1500000 |
15/04/2026, Apr 15, 2026 | a real date |
15/08/52 | 15 August 1952 (two-digit years as Excel reads them: 00–29 are 2000–2029, 30–99 are 1930–1999) |
0012345678, R10 | text, so codes stay exactly as written |
The decimal mark and the order of day and month are decided for each column from all of its cells, so one odd entry can’t flip a whole column. When dates such as 03/04/2026 could be read either way, the tool uses the order you choose under the options. When nothing in a column shows whether 12.500 means twelve and a half or twelve thousand five hundred, your device’s own number style decides; if that doesn’t settle it either, the cell stays as text, exactly as in the PDF, rather than risk a number 1000 times off.
Tables that run over several pages
Statements, price lists and reports often break one table across many pages, repeating the column names each time. With All tables on one sheet, pages with the same columns are joined into one table with one header row, frozen at the top so it stays in view as you scroll. Descriptions that wrap onto a second line stay in the same cell instead of becoming an extra row. Page headers, footers and page numbers are left out by default (untick the option to keep them); the rows of a table are always kept, even at the very top or foot of a page.
Bank statements, invoices and payslips
These are the documents people most often turn into spreadsheets, and the ones that should never sit on someone else’s server. This converter reads them on your device. For a year of statements, merge the monthly PDFs into one first, then choose All tables on one sheet for a single list of transactions.
For statements on one sheet with a balance column, the tool also checks the running balance: the money in and out since each balance shown should turn it into the next one, including statements that print the balance only once a day. The result screen says when every balance adds up, or names the sheet rows that don’t, so most misread or missing amounts show up straight away. Statements without a balance column can’t be checked this way, so it is still worth comparing the totals with the PDF.
CSV files
Tick CSV instead of Excel for plain files any program can read. Numbers are written as plain values (1234.5, -250), percentages keep their sign (12.5%), and dates are written as 2026-04-15. Text that a spreadsheet would run as a formula, such as a cell starting with =, +, - or @, gets an apostrophe in front, so it opens as text and can’t run anything.
Debit and credit columns, or one amount column
Banks lay statements out in a few common ways, and each converts cleanly:
- Separate Debit and Credit columns stay separate, each a column of numbers, with the balance beside them.
- One Amount column with money out shown as a minus, in brackets or with a minus after the number becomes positive and negative numbers in one column, ready to total.
- Amounts marked Dr or Cr, common in South Asian and UK statements, become negative (Dr) and positive (Cr) numbers that still show Dr or Cr.
- Opening, brought-forward and closing balance lines that line up with the columns stay as rows, so you can check them against the balance column.
Sort, filter and total your statement
Once the transactions are in one sheet, click any cell in the table and press Ctrl+T (Cmd+T on a Mac) to make it an Excel table. Each column gets a filter button: show only one shop, sort by the largest amount, or filter one month of dates. Because the dates are real dates, =SUMIFS(C:C, A:A, ">="&DATE(2026,4,1), A:A, "<"&DATE(2026,5,1)) totals one month’s spending, and a PivotTable sums each month in a few clicks.
What converts well, and what to check
- Converts best: PDFs made by accounting software, spreadsheets or online banking, where the text is real text.
- Check: tables without lines and with headings stacked over several rows, and pages that mix several small tables side by side.
- Can’t convert yet: scanned pages. They are pictures of a table with no text inside; reading them needs text recognition (OCR), which this tool doesn’t do. It tells you which pages are scans.
If your PDF is mostly text with a table or two, PDF to Word keeps the text and the tables together.
Check your sheet in 30 seconds
- Compare one total: add up a column with
=SUM()and check it against the PDF. - Type
=ISNUMBER(C2)next to an amount. TRUE means it is a real number. - Count the rows: the last row number minus the header should match the number of lines in the PDF table.
Password-protected PDFs
Statements are often protected with a password. Type it when asked; it is used on your device only. To save a copy of the PDF without the password, use Unlock PDF.
No caps, no sign-up, no upload
Many online converters stop at one file, 15 MB or a few tasks an hour, and most upload your file to do the work. Here there is no account, no counter and no upload. The only limit is your device’s memory; for a very long PDF on a phone, split it and convert the parts.
On Mac, Windows, iPhone, Android and Google Sheets
The tool runs in any modern browser, so it works the same on a computer or a phone. The .xlsx file opens in Excel, Numbers, LibreOffice Calc and Google Sheets (File > Import). Excel for Microsoft 365 can also import a PDF itself (Data > Get Data > From File > From PDF): it lists the tables it finds, joins similar tables on consecutive pages, and you choose which to load. It works best on simple tables; results vary with the layout.
Frequently asked questions
Is my PDF uploaded to a server?
Is there a limit on pages, files or file size?
Will the numbers work in formulas, or are they stored as text?
$1,234.50 becomes 1234.5 shown as currency, (250.00) and 250.00- become −250, 12.5% becomes 0.125 shown as a percentage, and dates become real dates. SUM, sorting and filters work straight away. Account numbers and codes with leading zeros stay as text on purpose, so no digits are lost.Can I put all PDF pages on one Excel sheet?
Will the Excel file keep my PDF’s formatting?
Can I convert a bank statement PDF to Excel?
Does it work with scanned PDFs?
Can I convert a password-protected PDF?
Last updated: 2026-11-20