How to Convert PDF to Excel and Keep the Numbers
Most PDF-to-Excel problems are not caused by the converter. They come from choosing the wrong path for the file in front of you. This page shows, from test conversions of invoices, bank statements, long lists, scans and Arabic tables, which route and which layout give you a spreadsheet you can actually work with. When you are ready, the PDF to Excel converter does the conversion itself.
Open the PDF to Excel converterWhat kind of PDF do you have?
Open the PDF and try to select a line of text with your mouse. The answer decides almost everything:
- The text highlights. It is a digital PDF, usually exported from accounting software, a website or Excel itself. The converter reads the text and its position directly, so numbers come out exactly as in the PDF. This is the easy case.
- Nothing highlights, or only the whole page. It is a scan or a photo saved as PDF. The text is recognised with OCR first, which takes longer and can misread characters. See Scanned PDFs and OCR.
- The text highlights, but the page looks like a scan. It is a scan that already has a hidden text layer, made by a scanner or by OCR PDF. The converter uses that text; for Arabic and Hebrew pages it reads the picture again, because their hidden text often comes out in broken rows.
- A password prompt appears. Remove the password with Unlock PDF first (you need to know it), then convert the unlocked copy.
Each file can be up to 50 MB, and a conversion that runs for more than 10 minutes is stopped. That limit mostly affects long scans; cut them into parts with Split PDF and convert the parts one by one.
Convert PDF to Excel step by step
- Check the OCR setting (scans only). For a digital PDF there is nothing to set. For a scan, open "Scanned PDF? OCR settings" and tick the languages of the text.
- Add your PDF. Click "Choose PDF" or drop the file onto the page. Files up to 50 MB are accepted; password-protected files are caught before anything is uploaded.
- Wait for the table detection. The rows and columns of every page are found on our server, which takes seconds for a digital PDF and longer for a scan.
- Check the preview and pick a layout. Look at the first rows of each page, then choose "Same layout as the PDF", "Multiple sheets (one per page)" or "One sheet".
- Download the .xlsx. Click "Download .xlsx" and open it in Excel, Google Sheets, LibreOffice Calc or Numbers.
Which layout should you choose?
After the file is processed you see a preview of every page and choose one of three layouts. Choose by what you will do with the spreadsheet:
| Layout | What you get | Best for |
|---|---|---|
| Same layout as the PDF | Text, numbers, pictures, lines and colours where they are on the page, one sheet per page. Built from many narrow columns so nothing moves. | Documents that must look like the original: invoices, forms, reports you will print or edit |
| Multiple sheets (one per page) | Only the detected tables, one worksheet per PDF page, in normal columns | Separate pages, for example one invoice or one report per page |
| One sheet | Only the detected tables, all pages one below the other in one worksheet, with a "Page N" row between pages | Bank statements and lists that run across many pages and should be filtered or totalled together |
Two things we noticed in testing are worth knowing before you pick:
- Tables without lines are recognised by the table layouts when they have several rows with clear gaps between the columns, as on most bank statements. A short list of only two or three rows without lines can end up as one cell per row; "Same layout as the PDF" keeps such small lists in their columns.
- "Same layout as the PDF" is for looking, not for calculating. Its narrow columns keep everything in place and print well, but sorting or filtering across them is awkward. For formulas and pivot tables, use one of the table layouts.
Convert with "One sheet" (statements, long lists) →
Convert with one sheet per page →
Each result can be downloaded once. To try another layout, convert the PDF again; the preview shows you the rows before you choose.
What ends up in the cells
| In the PDF | In Excel |
|---|---|
1,250.00, 4.50, 12,400 | Real numbers you can add up, with the same number of decimals |
(100.00), -45 | Negative numbers, shown in brackets like the original |
14%, -8.2% | Percentages (stored as 0.14 and -0.082) |
$1,250.00, 1,250.00 €, £5 | Numbers with the currency sign in the cell format |
007, long account or card numbers | Kept as text, so leading zeros and digits are not lost |
Dates such as 21/11/2026 | Text, exactly as written (Excel cannot know whether 01/02 means January or February) |
European decimals such as 1.250,00 | Text; see Problems and fixes |
| Bold text, colours, cell backgrounds | Kept |
Excel or CSV?
Choose PDF to Excel when you want a finished workbook: sheets, formatting, a preview, and a file that opens directly in Excel, Google Sheets, LibreOffice Calc or Numbers.
Choose PDF to CSV when the data goes somewhere else: a database import, a script, an accounting or analytics tool. CSV is plain text without sheets or formatting, so it loads quickly into other software. You can choose the separator (comma, semicolon or tab), and a multi-page file can come as one CSV or one CSV per page in a ZIP.
If you need the full text and formatting of the document rather than its tables, neither is right. Use PDF to Word.
Scanned PDFs and OCR
In the default "Automatic" mode, every page without selectable text is read with OCR, and the result tells you when OCR was used. Before you upload, open "Scanned PDF? OCR settings" on the tool page and tick the languages in the document; more than 30 are available, including Arabic, English, French, Spanish, German, Turkish, Persian, Urdu, Hebrew and Chinese.
Two habits make the biggest difference:
- Improve the scan, not the settings. A straight, sharp scan at 300 dpi beats any option. Pale or blurry pages are read better after Enhance PDF.
- Check every number. OCR can swap similar digits. In one of our test scans, an amount of 2,500.00 came back as 2,900. In a financial table a single wrong digit matters, so compare the totals with the PDF before you rely on the sheet.
If the text from a scan with a hidden text layer looks wrong, choose OCR mode "Always": every page is then read again from the picture.
Handwritten tables are the exception: OCR is made for printed text and reads handwriting poorly, so expect to type most of a handwritten table yourself.
Read every page with OCR (Arabic and English) →
Arabic and Hebrew tables
Columns keep the same visual order as in the PDF. In the two table layouts, a page with Arabic or Hebrew text becomes a right-to-left sheet (column A on the right), so sorting and formulas follow the reading direction. "Same layout as the PDF" places every cell exactly where it is on the page. Words are put back in their real reading order, and amounts still become numbers.
Scanned Arabic pages are read with OCR. Check names in the result: in our tests, letters such as alef with hamza were sometimes read without the hamza (أحمد as آحمد).
Common situations
Bank statements
Use "One sheet": the transactions of all pages end up in one list, with Debit, Credit and Balance in their own columns as numbers. Afterwards, filter out the repeated header rows and the "Page N" rows, then turn the date column into real dates with Data › Text to Columns › Date (DMY or MDY, as in your statement). For scanned statements, see OCR for bank statements.
Invoices and expense reports
If each page is a separate invoice, use "Multiple sheets (one per page)" so every invoice stays on its own sheet. To keep an invoice looking like the original for printing or small corrections, use "Same layout as the PDF".
Price lists and data reports
Choose a table layout. Clean tables with clear columns convert best; check merged cells and entries that wrap onto two lines in the preview.
Only some pages, or several PDFs
Each conversion handles one whole file. Take the pages you need out first with Extract PDF Pages, or combine several PDFs with Merge PDF, then convert the result.
Copy and paste, or convert?
Selecting a table in a PDF viewer and pasting it into Excel often looks fine for a few lines, but a PDF stores text as positioned words, not as cells. Pasted tables usually land in a single column, with each line as one cell, or with columns shifted where a cell was empty. Copy and paste is enough for a short list you will check by eye. For anything longer than a few rows, for amounts you want to add up, or for several pages, convert the file: the converter places every value in its own cell, keeps empty cells empty and turns amounts into numbers.
Excel's own PDF import
Excel for Microsoft 365 on Windows can import tables from a PDF itself: Data › Get Data › From File › From PDF. It works well for digital PDFs with clean tables and is handy when the same report arrives every month, because the import can be refreshed. It is not available in Excel for Mac or in older versions such as Excel 2019, it does not read scanned pages, and you have to pick the tables one by one. Use the converter when you are on a Mac, a phone or an older Excel, when the PDF is scanned, or when you want the whole document in one step.
PDF to Google Sheets
Google Sheets cannot open a PDF as a spreadsheet. Convert the PDF to Excel first, then either upload the .xlsx to Google Drive and choose Open with › Google Sheets, or in an open sheet use File › Import › Upload. Numbers, percentages and negative amounts arrive as real numbers. If you only need the raw data in an existing sheet, PDF to CSV and File › Import work just as well.
Phone, tablet and Mac
The converter runs in the browser, so nothing needs to be installed:
- iPhone and iPad: open the tool in Safari, choose the PDF from Files, and open the downloaded .xlsx in Numbers, Excel or Google Sheets.
- Android: choose the PDF from Downloads or Google Drive in Chrome, then open the .xlsx in Google Sheets or the Excel app.
- Mac: works in Safari, Chrome, Firefox and Edge; the file opens in Numbers, which comes free with every Mac, or in Excel.
Checking a wide table is easier on a large screen, so for long statements use a computer if you can.
Problems and fixes
- A small table ended up in one cell per row. It has no lines and too few rows to recognise columns. Use "Same layout as the PDF", or split the cells in Excel with Data › Text to Columns › Delimited › Space.
- Columns look shifted or merged. Merged cells and entries over several lines are the hardest cases. Check the preview, try the other table layout, and fix the remaining cells in Excel.
- Numbers with a comma as decimal sign stay text. For
1.250,00, select the column, replace "." with nothing and then "," with ".", or use Data › Text to Columns › Advanced and set the decimal separator to a comma. - Dates do not sort correctly. They are text. Convert them with Data › Text to Columns › Date and choose the order used in the PDF.
- "No readable text" message. OCR is turned off or the scan is too poor. Set OCR to "Automatic" or "Always", or use a clearer scan.
- "The file is password-protected" message. Remove the password with Unlock PDF, then convert the unlocked file.
- The file is too large or takes too long. Compress or split it, or keep only the pages you need with Remove PDF Pages.
- The download stops or never arrives. A download manager such as IDM can catch the file before the page does. Try again, or pause the download manager for this site.
Frequently asked questions
How do I convert a PDF to Excel?
Open PDF to Excel, choose your PDF and wait until the tables are detected. Check the preview, pick a layout and click "Download .xlsx".
Is the PDF to Excel converter free?
Yes. There is no sign-up and no watermark. Each PDF can be up to 50 MB.
Which layout should I choose?
"One sheet" for statements and lists over many pages, "Multiple sheets" when every page is a separate document, and "Same layout as the PDF" when the sheet must look like the original for printing.
Will the numbers be real numbers in Excel?
Yes. Amounts such as 1,250.00, (100.00), -45, 14% and $1,250.00 become numbers you can add up, in every layout. Numbers with leading zeros and long account numbers stay text, so no digits are lost.
Why are my dates text?
A date such as 01/02/2026 can mean January or February, so it is kept exactly as written. Convert the column with Data, Text to Columns, Date, and choose the order used in the PDF.
Can I convert a scanned PDF to Excel?
Yes. Scanned pages are read with OCR automatically; choose the languages under "Scanned PDF? OCR settings". Compare totals with the PDF afterwards, because OCR can misread digits.
Does it work with Arabic tables?
Yes. Columns keep the order of the PDF, pages with Arabic or Hebrew text become right-to-left sheets in the table layouts, and amounts still become numbers. Check names after OCR.
Can I convert only some pages?
Each conversion handles the whole file. Take the pages you need out first with Extract PDF Pages, or remove the others with Remove PDF Pages, then convert the result.
Can I combine several PDFs into one workbook?
Merge the PDFs first with Merge PDF, then convert the merged file with "One sheet" or "Multiple sheets".
I downloaded the file and need a different layout. What now?
Each result can be downloaded once. Convert the PDF again and choose the other layout; the preview shows the rows before you decide.
Should I use Excel or CSV?
Excel for a finished workbook with sheets and formatting. CSV when the data goes into a database, a script or an accounting tool.
Can I just copy a table from the PDF into Excel?
For a few lines, yes. Longer tables usually paste into one column or with shifted columns, because a PDF has no cells. Converting places every value in its own cell and turns amounts into numbers.
Does Excel have a PDF import?
Excel for Microsoft 365 on Windows has Data, Get Data, From File, From PDF for digital PDFs. It is not in Excel for Mac or older versions and does not read scans; the converter works on any device and with scanned pages.
How do I get a PDF into Google Sheets?
Convert it to Excel, then upload the .xlsx to Google Drive and open it with Google Sheets, or use File, Import in an open sheet.
Can I convert a PDF to Excel on my phone?
Yes. The converter runs in the browser on iPhone, iPad and Android. Open the .xlsx in Google Sheets, Numbers or the Excel app.
Is my file safe?
The PDF is sent over an encrypted connection and deleted right after the tables are extracted. The extracted data is deleted after you download the Excel file, or automatically after about one hour.
Ready to convert your PDF?
Open the converter, drop your PDF, check the preview and download the .xlsx file.
Convert PDF to Excel nowNeed another format? The Convert PDF Guide shows which one fits your goal.