Skip to content
TabShedKitsMy desk

Extracting a Table From a PDF Into Excel and Fixing Wrong Columns

Updated 5 min readBy

Convert PDF tables to .xlsx or CSV, correct the column splits with the preview strip, keep numbers as numbers and know when a scan needs OCR first.

PDF to ExcelTurn PDF tables into Excel or CSV
Open PDF to Excel
On this page
  1. How columns are found
  2. Step by step
  3. Reading the preview like a reviewer
  4. One sheet per page, or everything in one sheet
  5. Numbers: the part to double check
  6. Scanned PDFs
  7. CSV or XLSX
  8. Only the pages you need
  9. Common problems
  10. When this is not the right tool
  11. Privacy and limits
  12. FAQ

A bank statement, a price list, a lab report: the numbers you need are in a PDF, and copying them into a spreadsheet gives you one long column of text or cells that merged in odd places. The conversion is not hard to run, but it is easy to run badly. What makes it work is understanding how the PDF to Excel tool finds columns, and where to step in. This guide walks through that, with the checks that save you from silently wrong totals.

How columns are found

A PDF does not contain a table. It contains words placed at coordinates. This tool reads the text and its positions on your device and looks at the gaps between words to decide where the columns are. It does not look for drawn lines, so a table with borders and a table without borders are handled the same way. Plain tables with consistent spacing come out well. Trouble starts with merged cells, text that wraps over several lines inside one cell, and tables where the gap between two columns is no wider than the gap between two words.

Step by step

  1. Drop the PDF or choose it. The text and positions are read on your device.
  2. Look at the preview of the sheet. Above it is a strip with blue lines: these are the column splits.
  3. Click the strip to add a split where a column boundary is missing, and click a line to remove one that cuts a column in two.
  4. Choose one sheet per page or all pages in one sheet.
  5. Download Excel (.xlsx) or CSV.

Reading the preview like a reviewer

Before downloading, scroll the preview and check four things:

  • Header cells. Is every heading in its own column, and does it sit above its numbers?
  • Long text cells. A description that wraps onto a second line may be read as a new row. Look for rows where the first cells are empty.
  • Totals row. Check that totals line up with the column they belong to.
  • Last column. Right-aligned numbers at the end of a row are often joined to the previous column if the gap is small. Add a split.

One sheet per page, or everything in one sheet

ChoiceUse it for
One sheet per pageDocuments whose pages are different tables, such as a report with several exhibits
All pages in one sheetA long table that continues across pages, such as a statement; you can then sort and sum it as one list

If a long table repeats its header row on every page, the repeated headers will appear as rows in the middle of your data when you choose a single sheet. Filter them out in Excel by sorting or by filtering on the header text.

Numbers: the part to double check

By default the tool writes values such as 1,234.56, (45) and 12% as real numbers, so you can sum and sort them. Currency symbols are dropped, so a column of "$1,200" becomes numbers, and you should note the currency in the header. Codes with leading zeros, such as account or product codes like 00123, are kept as text so the zeros are not lost. You can switch the number conversion off to keep everything as text, which is the safer choice when a column mixes codes and amounts.

Two checks protect you from silent errors. First, add up one column in Excel and compare it with the total printed in the PDF. If the total matches, the column is almost certainly right. Second, look for dates: numbers that look like dates in your region's format may be interpreted differently by Excel on open, so confirm one or two.

Scanned PDFs

A scan is a picture, so there is no text to read and no positions. The tool will not work on it directly. Run the file through OCR PDF first to create a searchable PDF, then convert that. After OCR, review the numbers more carefully than usual, since a "5" read as an "S" will turn a number into text and make a sum quietly skip it.

CSV or XLSX

Choose XLSX if you want a spreadsheet to open directly in Excel, Google Sheets or Numbers with numbers recognised. Choose CSV if you will import the data into another system, a database or a script; CSV is plain text without formatting and opens anywhere, but different programs expect different delimiters and encodings, so check that accented characters appear correctly on import.

Only the pages you need

If the PDF is long and the table is on a few pages, extract those pages first with Split PDF. Fewer pages means a faster conversion and a simpler preview to check.

Common problems

  • Everything lands in one column. The gaps are too small for the tool to find. Click the strip to add splits manually.
  • A column is split in two. Click the blue line to remove it.
  • Numbers show as text. The number conversion is off, or the cell contains a symbol that blocks recognition. Switch the option on, or fix the column in Excel with Text to Columns or by multiplying by 1.
  • Cells that were merged in the PDF look empty. The tool splits by text position, so the value sits in one cell and the merged area is empty.
  • Rows broken over two lines. Join them by hand in Excel or work from the preview with different splits.

When this is not the right tool

For a PDF that is mostly prose with a table or two, converting to Word may be easier with PDF to Word. For images of tables, OCR first. For a table with complex merged headers, expect manual cleanup either way, and decide whether retyping is quicker.

Privacy and limits

Reading and building the file happen in your browser, so statements and price lists are not uploaded. The page keeps working offline once loaded. There is no watermark; very large PDFs are limited only by your device memory.

FAQ

Does it find table borders?

No. It uses the position of the text.

Are numbers real numbers in Excel?

Yes, unless you switch that off. Codes with leading zeros stay as text.

Can I convert a scanned PDF?

Not directly. Use OCR PDF first.

Can I get one sheet for the whole document?

Yes, choose all pages in one sheet.