PDF to Excel

ConvertersNewPremium

Extract PDF table data into Excel-ready CSV.

Nothing Is UploadedRuns In This Browser TabNo Account Needed

How It Works

1

Upload / Input

Select your files or paste your content to get started.

2

Process

The work happens in this browser tab. Your file never leaves your device, so nothing is queued, stored or transmitted.

3

Download / Result

Get your results instantly. Download files or copy output in one click.

Features

Rows from text baselines, columns from x-positions
Reports which pages a table structure was actually found on
Falls back to one line per row instead of guessing
RFC 4180 CSV with a UTF-8 BOM, so Excel opens it correctly
Runs entirely in your browser

How to use PDF to Excel

  1. Add the PDF

    Drop in a document containing the tables you need.

  2. Convert

    Rows are read from the text baselines and columns from the horizontal bands the words occupy. The tool reports which pages it actually found a table on, and exports one line per row on the pages where it did not.

  3. Check the column boundaries

    This is where extraction goes wrong. Verify a few rows against the original before you build anything on the data.

  4. Clean up

    Fix merged cells, split columns and number formatting before relying on the data.

When to use PDF to Excel

  • Getting figures out of a PDF financial statement for analysis
  • Extracting a price list into a spreadsheet
  • Turning a PDF report table into data you can sort and filter
  • Recovering tabular data when the source spreadsheet is lost

FAQ

No, and running OCR first does not open a side door. A scan contains images rather than selectable text, and the tool tells you so instead of exporting an empty file. OCR PDF reads a scan, but it returns plain text rather than a PDF with a text layer, so there is no converted file to bring back here — and plain text has already lost the column positions this tool works from. Paste the recognised text into a spreadsheet and split the columns there, bearing in mind that OCR digit errors are especially costly in numeric tables.
Because no column structure could be found. PDFs record positioned text, not tables; when the columns are separated by whitespace alone and the runs overlap horizontally, there is no boundary to detect. Rather than split the text at a guessed position, each line is exported as a single cell.
Yes. The file is RFC 4180 CSV with a UTF-8 byte-order mark, so Excel, Google Sheets, Numbers and LibreOffice Calc all open it directly with accented characters intact.
The PDF separated them with whitespace rather than drawn lines, so there is no explicit column boundary for the converter to find. Tables with visible rules extract far more reliably.
They have been imported as text rather than numbers. Select the column and convert it to a numeric format. Watch for currency symbols and thousands separators, which also force text.
Sum a column in the spreadsheet and compare with the total printed in the PDF. A match is strong evidence the extraction worked; a mismatch tells you to investigate before using the data.
Not here, and OCR is not a way round it: it gives back plain text rather than a PDF, and plain text no longer carries the column positions this tool works from. Recognise the pages, paste the text into a spreadsheet and split the columns there — watching for OCR digit confusions such as 0 for O or 5 for S, which are particularly damaging in numeric tables.

Related Tools

New

PDF to Word

Extract a PDF’s text into an editable Word document.

converters
New

OCR PDF

Read the text out of a scanned PDF, page by page.

pdf-tools
Popular

Merge PDF

Combine PDF files into a single document in seconds. Merging several PDFs is Premium.

pdf-tools

Audio to WAV Converter

Convert MP3, M4A, OGG, FLAC or AAC audio to uncompressed 16-bit WAV.

converters

About PDF to Excel

Extracting tables from PDFs is genuinely difficult, and it is worth understanding why before trusting the output. A PDF usually does not record that something is a table. It records text at coordinates and, sometimes, lines drawn on the page. The converter has to infer from spacing and alignment where the columns are — which works well for cleanly ruled tables and poorly for anything else.

The failure modes are specific. Columns separated by whitespace rather than lines may be merged. Cells containing wrapped text may split across rows. Numbers may arrive as text, so they will not sum. Negative figures in parentheses, a common accounting convention, are frequently misread.

Always validate before using extracted data for anything that matters. Sum a column and compare it against the total printed in the PDF. If they match, the extraction is probably sound. If they do not, find out why before building anything on top of it.

Tips and limits

  • Sum a column and check it against the total in the PDF. That one test catches most extraction errors.
  • Numbers often arrive as text and will not calculate. Convert the cell format.
  • Parenthesised negatives, e.g. (1,234), are commonly misread.
  • Tables with ruled lines extract far better than those aligned with whitespace.
  • A scanned PDF cannot be extracted here at all: OCR hands back plain text, which has already lost the column positions this tool reads.