PDF

PDF to Excel

Details

How to use PDF to Excel

What the tool does, how to run it, and what to expect from the result.

How the conversion works

The PDF is opened in the browser with the pdf.js engine and every text item on the selected pages is read along with its position on the page. Items are then grouped into rows by their vertical coordinate, and within each row a new column begins wherever there is a wide horizontal gap between one item and the next. Rows are padded to a consistent width, blank rows are dropped, and the result is written to a spreadsheet.

The workbook is a real one. It is built with a spreadsheet library and written in the Open XML format Excel actually uses, with the sheet named for the export, so it opens in Excel, Numbers, LibreOffice, and Google Sheets without a warning about the file not matching its extension. CSV output uses proper quoting, so a cell containing a comma, a quote mark, or a newline survives intact.

Everything happens in the tab. The PDF is read into memory, parsed on the main thread, and the finished file is handed to you as a download from an in-memory blob. That matters for the documents people usually convert here: bank statements, invoices, payroll exports, and internal reports that have no business being uploaded to a stranger server.

  • Text position drives the row and column inference
  • Output is a genuine .xlsx workbook or a properly quoted CSV
  • Parsing and assembly both happen locally in the browser tab

When to use XLSX and when to use CSV

Auto mode looks at what it found. If no detected row has content in a second column, the data is really a list rather than a table, and a spreadsheet with one populated column is a worse artifact than a plain CSV. In that case the export switches to CSV and says why, which is more useful than silently producing a workbook that misrepresents the source.

Force XLSX is there for when you know the structure is a table even if the layout confused the detector, typically because columns are close together. Force CSV is there for the opposite case, and for feeding another program that would rather read text than parse a workbook.

Page range selection is the other lever. A fifty page report with the table on pages twelve to fifteen converts far better when you say so, because everything else on those other pages, headers, footers, body paragraphs, would otherwise flow into the same sheet as more rows.

What positional table detection can and cannot do

This is heuristic extraction, and being clear about that saves disappointment. The detector works from coordinates, not from an understanding of the document. It does not read ruling lines or cell borders, it does not identify a header row, it does not handle merged cells, and it puts every selected page into one sheet rather than one sheet per page.

The consequence is predictable. A clean, well-spaced financial table converts almost perfectly. A dense table where columns nearly touch may merge two columns into one cell, because the gap between them was not wide enough to read as a boundary. A table with wrapped text in a cell will split that wrap across two rows, because the second line sits at a different vertical position.

The other hard limit is scanned documents. If a PDF is an image of a page rather than text, there is nothing to extract, and the tool says so plainly instead of returning an empty sheet. Run it through OCR first to produce a text layer, then convert. Password-protected files need the password supplied before the text can be read at all.

  • No ruling-line detection, no header detection, no merged cells
  • All selected pages flow into a single sheet
  • Scan-only PDFs have no text to extract and need OCR first
Tips

Getting a better result out of PDF to Excel

Specific settings and thresholds, not general advice.

  • Set a page range before converting. Excluding the pages without tables is the single biggest quality improvement available.
  • Check the row preview before downloading. It shows the first few inferred rows and reveals a bad column split immediately.
  • If columns merged, try force XLSX anyway and split the cell in the spreadsheet. That is often faster than fighting the source layout.
  • Wrapped text inside a cell will land on two rows, because the second line sits lower on the page. Expect to rejoin those by hand.
  • For a scanned document, run OCR first to add a text layer, then come back. There is no shortcut around a missing text layer.
  • Choose CSV when the result is feeding another program, and XLSX when a person is going to open it.
Limits

What PDF to Excel does not do

The honest boundary, so you do not lose time finding it yourself.

  • Column detection is positional, so tightly spaced columns can merge and wrapped cell text splits across rows.
  • It does not read ruling lines, detect header rows, or handle merged cells, and all selected pages land in one sheet.
  • Scan-only PDFs contain no extractable text and must be run through OCR first.
  • Formatting, fonts, colors, and formulas are not preserved, because a PDF only contains rendered values.
At a glance

Who PDF to Excel is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

People moving statements, reports, and table-heavy PDF data into spreadsheets for review and reuse.

Ideal for

Table-first extraction from text-based PDFs where spreadsheet output matters more than exact page layout.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Is this PDF to Excel converter free?

Yes. It runs in your browser with no signup, no watermark on the output, and no per-file charge.

Does my PDF get uploaded?

No. The PDF is parsed in your browser and the spreadsheet is built there too. The only network request is a usage count containing the tool name, never the document.

Is the output a real Excel file?

Yes. It is written in the Open XML format Excel uses, so it opens cleanly in Excel, Numbers, LibreOffice, and Google Sheets. It is not an HTML table with the extension changed.

Why did it give me a CSV instead of a spreadsheet?

Because auto mode found no second column with content, which means the text is a list rather than a table. A CSV is the more honest export in that case. Use force XLSX if you disagree.

Will it work on a scanned PDF?

No. A scan is an image with no text layer, so there is nothing to extract. The tool tells you rather than returning an empty file. Run OCR first to add a text layer, then convert.

Why are two columns merged into one cell?

Because the horizontal gap between them was too narrow to read as a column boundary. The detector infers columns from spacing, so tightly packed tables sometimes collapse. Widening the source layout, if you control it, fixes this.

Can I convert only some pages?

Yes. Choose a custom range such as 1-3,5. Narrowing the range is usually the single biggest improvement, because it keeps body text and page furniture out of the sheet.

Does it keep formulas, formatting, or colors?

No. A PDF does not contain formulas at all, only rendered text, so what comes out is values. Formatting, fonts, and cell colors are not carried across.

Does it handle password-protected PDFs?

Yes, if you supply the password. Without it the text cannot be read and the conversion cannot start.

Is there a file size limit?

No limit is set in the code, but the whole PDF is read into memory and parsed on the main thread, so a very large document is bounded by your device and will make the tab busy while it works.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon