How to Get a Table Out of a PDF Into Excel

Retyping a table from a PDF into a spreadsheet by hand is the kind of task that eats an afternoon for no good reason. If the PDF has real, selectable text laid out like a table, you can get most of the way there automatically instead.

Convert it

Open PDF to Excel and drop in the file. Each page becomes its own sheet in the output workbook, named by page number, so a table that spans several pages stays easy to find rather than getting mixed into one sheet.

How it actually works

There's no reliable way for a browser to know which part of a PDF is genuinely "a table" versus text that just happens to line up - so this looks at where each piece of text sits on the page and groups it into rows and columns based on that spacing. It works well on a PDF with a clear, simple table: an exported report, an invoice, a data listing. It works less well on merged cells, multi-column layouts, or dense prose, where the spacing doesn't map cleanly onto a grid. Check the result before relying on it, especially for anything with irregular layout.

If the PDF is a scan, OCR it first

This needs real, selectable text to work with - a scanned image has no text behind it at all to extract. If your PDF is a scan, run it through OCR PDF first to add a text layer, then convert the result here.

Common questions

Will this work on any PDF? It needs real, selectable text arranged like a table. A scanned image has nothing to extract until it's been through OCR; dense prose or a complex, merged-cell layout may not come out cleanly either way.

How accurate is the row and column detection? It's a best-effort heuristic based on text position, not true table recognition - good on a simple, clean table, less reliable on anything irregular.

Is my file uploaded anywhere? No. The PDF is read and converted entirely in your browser.