Convert PDF Text to XLSX
PDF to XLSX is a text handoff for spreadsheet users, not an automatic table-recognition service. The worker extracts characters from the PDF and writes each non-empty extracted line into a simple worksheet, one line per row in a single column. That can give an analyst searchable text to sort, copy, annotate, or use as a starting point for a real model. It does not reconstruct the original tables, layout, images, or charts. A PDF that looks like a grid still supplies a visual page description rather than dependable spreadsheet cells. Scanned pages need OCR before this route can see their words, and even OCR cannot restore the source's intended columns or formulas. Keep the PDF open beside the XLSX, validate important numbers, and treat the workbook as an extraction draft rather than a finished financial or operational spreadsheet.
Use this without the search next time. Prathom Workbench puts Prathom's tools in your toolbar.
Add to Chrome — freeDrop your PDF file here, or click to browse
Up to 50 MB. Deleted automatically after 30 minutes.
What it does
- Extracts selectable PDF text before writing an XLSX workbook
- Places extracted lines in a simple one-column worksheet
- Explains why PDF tables, page layout, images, and charts are not rebuilt
- Searchable PDFs work best; image-only pages need OCR first
- No watermark and no sign-up
How to use PDF to XLSX
- 1
Check for selectable text
Open the PDF and try to select a sentence. If the page is a scan, run OCR first because this conversion reads stored characters and does not recognize letters from page images.
- 2
Extract lines into the workbook
The server creates a temporary text intermediate, removes empty lines, and writes the remaining lines to a simple XLSX worksheet. Each extracted line becomes a row in one column rather than a detected spreadsheet record.
- 3
Rebuild the useful structure
Open the workbook with the source PDF beside it. Check reading order and numbers, then create real headers, cells, formulas, filters, and tables manually if the data will drive a decision or calculation.
How it works
The worker handles this conversion in two deliberately narrow steps. First, it runs the PDF text extractor with layout information enabled. That option can make ordinary lines and spaces more useful, but it still produces a flat text stream. It does not turn a page's drawing coordinates into a spreadsheet schema. If the PDF contains a title above a table, a repeated footer, or two columns, those objects remain clues in the extracted line order rather than workbook metadata.
Second, the worker creates an XLSX package with one worksheet. Each non-empty line from the intermediate text is written to the next row in column A. The result is a valid workbook that spreadsheet software can open, search, copy, and edit. It is intentionally not presented as a recovered Excel version of the PDF. There are no promises of detected columns, numeric typing, formulas, filters, merged cells, page tabs, images, or charts. The simple shape makes the boundary visible: the workbook contains extracted words, while a human decides which words belong in which cells.
What to check in the worksheet
Begin with reading order. A single-column result can still contain a two-column article in an order that follows PDF object placement rather than the path a reader would take. Compare headings, footnotes, captions, and repeated page furniture with the source. Remove duplicated headers only after confirming that they are page furniture and not repeated data. If a value looks split across lines, do not join it by guesswork when a calculation will depend on it.
Next, rebuild the data model. Create explicit columns for fields such as date, account, description, quantity, and amount. Apply number and date formats only after checking separators, currency symbols, negative values, and decimal precision. Add formulas yourself and recalculate them in the target spreadsheet application. A visual total in the PDF is not a formula in the XLSX, and a value that sits near a label is not proof that the two belong to the same record.
Tables need a source comparison pass. A table may use shading, borders, indentation, or white space to communicate a relationship that the text extractor cannot encode. Recreate it as a real worksheet table only after identifying its header and row boundaries. For a chart, locate the underlying data or enter it from a verified source; extracted axis labels do not recreate plotted series. Likewise, copy images separately if they carry information that words alone cannot convey.
When this route fits
Use PDF to XLSX when the immediate need is a searchable text inventory, a review queue, or a starting point for manual spreadsheet cleanup. It can reduce retyping for text-heavy reports and make a long document easier to inspect in a familiar grid. It is a poor fit when the requested deliverable is an exact financial model, an audited data import, a form with meaningful positions, or a workbook that must preserve the PDF's appearance. For those cases, obtain structured source data, use OCR and validation where necessary, and retain the PDF as the authoritative visual reference.
Examples
A text-based budget appendix
The finance team gets a searchable starting point for locating department names and amounts without retyping every line. The workbook is not a budget model: visual row boundaries, merged headings, subtotals, and column relationships must be checked against the PDF and rebuilt as cells before formulas or approvals depend on them.
A scanned shipment register after OCR
OCR gives the extractor characters to pass into the workbook, but it does not make the result a trustworthy register. Dates, tracking numbers, quantities, handwriting, and barcode content need a page-by-page comparison. The barcode and handwritten marks are not reconstructed as spreadsheet objects, so the source remains essential evidence.
Frequently asked questions
Will PDF to XLSX turn a visible PDF table into real spreadsheet cells?
No. PDF text is extracted first and the resulting non-empty lines are placed in one simple worksheet column. The converter does not infer dependable rows, columns, merged cells, headers, formulas, totals, or cell types from visual alignment. A table can therefore appear as a sequence of lines rather than a usable grid. Rebuild and verify any important table manually before sorting, calculating, importing, or approving its values.
Can this create an Excel workbook from a scanned or photographed PDF?
Only when the PDF already has a usable text layer, or after OCR has added one. This route extracts stored characters; it does not read pixels, handwriting, checkboxes, or barcodes. OCR can supply approximate words and digits, but it may misread a decimal, sign, date, or identifier. Compare the workbook with the page images, and do not use an OCR-derived spreadsheet as the sole source for financial, inventory, legal, or safety decisions.
Are images, charts, and the original page layout included in the XLSX?
No. Images, charts, logos, annotations, page breaks, fonts, positions, and other visual objects are outside the extracted text stream, so they are not reconstructed in the workbook. A chart's labels may appear as text while its plotted values and visual relationships are absent. Obtain source data or approved image assets separately, then recreate the visual material intentionally if the spreadsheet needs to communicate it.
What happens to my PDF after the XLSX is generated?
The PDF is uploaded to the server because this conversion uses the office worker. The worker creates a temporary extracted-text file and an XLSX result, and the source, intermediate, and result are deleted after 30 minutes. That is a short processing window, not a records policy. Keep the original PDF and downloaded workbook where required, and follow your organization's rules for confidential or regulated information.
Further reading
- XLSX Cost 14% More Than the CSV and the Old XLS Cost Nearly Four TimesThe modern spreadsheet formats have a reputation for bloat that they no longer deserve, and the old one has a reputation for compactness it never had. A plain table in four formats puts numbers on both, and the ranking is not the one most people would guess.
- OCR Reads Nothing at 72 DPI and Everything at 150The standard advice for scanning documents you intend to run through OCR is 300 DPI. We measured where the accuracy actually changes, and it is not a gentle curve with 300 comfortably on the good end. It is a cliff between 96 and 150, and everything above 150 was identical.
- Why a Scanned PDF Has No Text to CopyA PDF can look full of words while containing no characters at all. If every page is a photograph of a document, copy and search cannot work until optical character recognition creates a new text layer, and that layer still needs review.