How to Convert PDF to Excel: Pulling Tables and Data Into a Real Spreadsheet
Every finance team, every research assistant and every analyst has done it at least once: opened a PDF full of figures and started retyping them into a spreadsheet, cell by cell. It is slow, and it introduces errors you will not notice until a total looks wrong. A PDF to Excel converter reads the numbers off the page and rebuilds them as rows and columns you can sort, filter and sum. This guide covers how to extract tables from PDF, what the .xlsx output actually looks like, which layouts convert cleanly, and the two things that trip people up most.
1. What a PDF to Excel Conversion Really Does
A PDF does not contain a table. This surprises people, so it is worth saying plainly. What a PDF contains is a list of instructions: put this glyph at this coordinate, in this font, at this size. When you look at a printed quarterly report you see columns, but the file has no idea that a column exists. There is no row, no header, no cell — only ink placed at positions.
A spreadsheet is the exact opposite. An .xlsx file is an ECMA-376 Office Open XML workbook, a structured package that describes sheets, rows and addressable cells. Nothing about position, everything about structure.
So a PDF to XLSX conversion is a reconstruction, not a format swap. The converter reads the text on each page along with where it sits, groups items that share a baseline into rows, works out where the columns are by finding the vertical alignments that text repeatedly starts from, and writes the result into a worksheet. Columns that end up empty are dropped so you are not left with a spreadsheet full of blank gaps. That is how you convert a PDF table to Excel without typing anything.
2. How to Convert PDF to Excel Online Free (Step-by-Step)
No account, no email, no trial period. To convert PDF to Excel free with the tool at the top of this page:
Add your PDFs
Drop one or more .pdf files onto the panel, or click to browse. Anything that is not a PDF is refused with a clear notice rather than failing silently halfway through.
Run the extraction
Press convert. A progress readout names the file being processed and shows how far along the queue it is, so a long batch never leaves you guessing.
Preview, then download
The parsed grid appears on screen with a tab per worksheet so you can check it before committing. Then download the .xlsx and open it anywhere.
The preview step is the part most online PDF to Excel tools skip, and it is the most useful one. Seeing the first fifty rows of each sheet before you download tells you in two seconds whether the column detection landed the way you hoped, which saves opening a spreadsheet only to discover it needs work.
3. What You Actually Get: Sheets, Columns and File Names
Knowing the shape of the output in advance makes it far easier to work with. Here is exactly what lands in your downloads folder.
- One worksheet per page. A fourteen-page report becomes a workbook with fourteen tabs, named Page_1 through Page_14. Nothing is merged across pages, so a table that runs over three pages arrives as three sheets you can stack yourself.
- A single .xlsx file. The download is one Excel workbook, named after your PDF. Convert Q3-summary.pdf and you get Q3-summary.xlsx.
- Rows in reading order. Lines are written top to bottom and left to right, exactly as they appear on the page.
- No empty filler columns. Column positions that never hold a value are removed before the sheet is written.
Can I get a CSV, or open it in Google Sheets?
People search for a PDF to CSV converter constantly, so let us be exact: this tool produces .xlsx and only .xlsx. That is not the limitation it sounds like. An .xlsx workbook opens natively in Excel, Google Sheets, LibreOffice Calc, Apple Numbers and every serious data tool, and any of them will re-save a sheet as CSV in two clicks. Upload the workbook to Drive and Sheets converts it on open, which is how you get PDF to Google Sheets without a separate service in the middle.
4. Which Tables Convert Cleanly, and Which Need Tidying
Search convert PDF to Excel without losing formatting and every result promises a flawless copy. The truthful answer is more useful. Because a PDF stores position rather than structure, a converter has to infer the grid, and inference works beautifully on some layouts and imperfectly on others. Knowing which is which before you start is worth more than a promise.
Extracts reliably
- Machine-generated tables with consistent alignment
- Financial statements, price lists and ledgers
- Exported reports from accounting or database systems
- Single-line rows with one value per column
- Every character of text, including symbols and currency marks
Needs a tidy-up
- Merged cells and stacked, multi-level headers
- Cells whose text wraps onto a second line
- Borders, shading, fonts and cell colours
- Rotated or vertical column labels
- Footnotes and captions sitting inside the table area
The pattern is consistent: data comes across, styling does not. Cell borders and fills are visual decoration in the source page and there is nothing structural to carry over, so expect a plain grid and restyle it in seconds with Excel’s own table formatting. If your document is mostly prose with the occasional figure rather than a genuine grid, the PDF to Word converter will give you a better starting point than a spreadsheet ever could.
5. Why Your Numbers Arrive as Text (and How to Fix It in 20 Seconds)
This is the question people ask straight after their first conversion, usually phrased as “why won’t my extracted column add up?” Here is what is happening and how to solve it.
Values are written into the workbook exactly as they were read from the page, which means they arrive as text rather than as numbers. That is deliberate and it is the safe default: it protects long reference codes from losing their leading zeros, keeps order numbers from being reinterpreted as dates, and preserves currency symbols and thousands separators precisely as printed. The trade is that SUM will return zero until you convert the column.
Three ways to turn the column into real numbers
- Text to Columns. Select the column, open the Data tab, choose Text to Columns and click Finish without changing anything. Excel re-reads the column and converts what it can.
- Paste Special. Copy an empty cell, select the column, and use Paste Special with the Multiply operation. Every value is coerced to a number in one pass.
- A VALUE formula. In a helper column, use =VALUE(A2) and fill down — the safest option when some rows should stay as text.
If your figures include currency symbols or non-breaking spaces, strip those first with find-and-replace, then convert. Two minutes of this once beats retyping a hundred rows.
6. Scanned PDFs, Bank Statements and Invoices
If a page comes back holding a single cell that says there is no extractable text, your PDF is a scan. It is not a failure of the conversion — it is the tool telling you the truth instead of handing you an empty workbook and letting you find out later.
A document that came from a scanner, a photocopier or a phone camera contains photographs of pages. Your eyes read the numbers; the file holds only pixels. There is no text to position, so there is no grid to rebuild. To convert a scanned PDF to Excel, take two steps:
- Run the file through our free PDF OCR tool to recognise the characters and add a real text layer.
- Bring the result back here and extract it to a spreadsheet.
One honest caveat: OCR quality depends entirely on the scan. A clean, straight 300 DPI scan of a printed bank statement to Excel job reads well; a tilted photo of a crumpled receipt will not, and no tool anywhere changes that. For invoice data extraction, scan flat, scan bright, and always check totals against the original. A password-protected PDF also cannot be read until the password is removed in the application that set it.
7. Converting Several PDFs Into One Workbook
Twelve monthly reports in the same format is a common shape of work, and doing them one at a time is tedious. Add all of them at once and you get a single workbook back. Each page of each document becomes its own sheet, and the tab name carries the source filename as a prefix so you always know which report a sheet came from. That makes batch PDF to Excel conversion a single operation rather than twelve.
Two practical notes. Excel caps worksheet names at 31 characters, so very long filenames are shortened in the tab label — the data itself is untouched. And when you convert more than one document together, the download is named for the batch rather than for any one file. If you only need pages 40 to 60 of a long annual report, pull them out first with the page extractor or the PDF splitter. A shorter input means fewer sheets to sift through and a workbook that opens faster.
8. Why Cortexis Is the Best Free PDF to Excel Converter
Plenty of sites will convert PDF to spreadsheet. Most make it deliberately awkward until you pay. Here is the difference, stated so you can check every line yourself.
Genuinely free, no trial
No account, no email address, no card and no countdown. What you are using is the whole product, not a sampler.
No file size limit
A two-page invoice or a 400-page annual report. There is no premium tier above this one to upsell you to.
No watermark, no row cap
Free converters love to give you the first ten rows. Your workbook comes out complete and unstamped.
Your documents stay private
Files are never stored on our servers, never retained after your session, and never used for training or analytics.
Preview before you download
Check the parsed grid sheet by sheet on screen first, so a bad extraction costs you seconds rather than a wasted download.
An honest account of the result
We tell you which layouts convert cleanly and which need a tidy-up before you spend time on it, not after.
It sits inside a wider set of free document tools built on identical terms, so you can merge a stack of reports into one file before extracting, or reorder the pages so the sheets arrive in the order you want them.
9. Frequently Asked Questions (FAQ)
How do I convert PDF to Excel for free without signing up?
Open the converter at the top of this page, add your PDF, run the extraction and download the .xlsx. There is no account, no email verification, no watermark and no row limit on the output. It is free every time, not free for the first few files.
Why is my whole table crammed into one column?
That usually means the source table separates its columns with spaces rather than by aligning text at consistent positions, so there is no repeated alignment to detect. Convert it anyway, then use Text to Columns in Excel with space as the delimiter — between the two steps you will still get there far faster than retyping.
Can I convert a scanned PDF or a photo of a table into Excel?
Not directly, because a scan holds no text to extract and you will see a note saying so on those pages. Run the file through our free PDF OCR tool first to create a text layer, then bring it back here. Results depend on scan quality, so check the figures against the original.
Does it export to CSV or straight into Google Sheets?
The download is an .xlsx workbook. Google Sheets, Excel, LibreOffice and Numbers all open that format directly, and any of them will save it out as CSV in a couple of clicks if that is what you need next.
Is there a limit on file size or how many PDFs I can convert?
No. There is no size cap and no daily quota. Larger documents simply take longer to work through, and a laptop will get through a very long report faster than a phone will.
Are my documents safe when I convert them?
Your files are never stored on our servers, never queued or logged, and nothing is retained once your session ends. Your documents are never used for training or analytics.
Need something else from the same document? The PDF compressor gets a heavy report under an upload limit, the image extractor pulls out embedded charts and logos, and the PDF to JPG converter turns a page into a picture you can drop into a slide deck. If you would rather automate this kind of data work than click through it, our free Python development course covers the spreadsheet and file-handling libraries that sit behind tools like this one.