How to Convert a PDF Table to Excel (Step by Step)

PDF tables lock your data into a fixed layout. Knowing how to convert a PDF table to Excel correctly—without mangled columns or merged cells—saves hours of manual cleanup. The right method depends on one key question: is your PDF text-based or scanned?

Key takeaways

• Text-based PDFs convert cleanly in a browser tool with no extra steps.
• Scanned PDFs require OCR before any data can be extracted.
• A single-table, short file is a good candidate for a browser tool; large or complex files may need a desktop app.
• Always check the output for merged cells, shifted columns, and missing decimal points before using the data.
• If column structure is badly broken, converting to CSV first can give a cleaner base to work from.

Step 1 — Identify your PDF type

Before you pick a tool, open the PDF and try to select text by clicking and dragging. If you can highlight individual words, the file is text-based (sometimes called "native" or "digital" PDF). If nothing highlights, the file is a scanned image and needs OCR.

This distinction matters because text-based files convert directly, while scanned files need an extra recognition step or the output will be blank cells.

Step 2 — Convert a text-based PDF table to Excel

For a standard digital PDF, a browser-based tool is usually all you need.

1. Open PDF to Excel in your browser.
2. Click Choose file and upload your PDF. Guest users can upload files up to 25 MB; free accounts allow up to 50 MB; premium accounts support files up to 500 MB.
3. Click Convert. The tool parses the PDF's internal text layer and maps rows and columns into an .xlsx file.
4. Download the file and open it in Excel or Google Sheets.
5. Scan each column header and the first few data rows to confirm the alignment is correct.

For most invoices, financial statements, and reports exported from accounting software, this five-step process is all you need.

Step 3 — Handle scanned PDFs with OCR

If your PDF is a scan—a photographed receipt, a faxed form, or an old printed report—the converter needs to read the image before it can produce structured data.

1. Open OCR PDF first.
2. Upload your scanned PDF. Free accounts can OCR up to 10 pages per job; premium accounts support up to 200 pages.
3. Select your document language for the best recognition accuracy.
4. Download the resulting searchable PDF.
5. Now take that searchable PDF back to PDF to Excel and run the standard conversion from Step 2.

OCR quality depends heavily on scan resolution. A clean, straight scan at 150 DPI or higher produces far better results than a skewed phone photo.

Step 4 — Deal with multi-page tables

Many reports repeat a table header on every page. When converted, each page may produce a separate block of rows with a duplicate header row between them.

1. After conversion, open the Excel file.
2. Use Ctrl + Home to go to cell A1, then Ctrl + End to find the last used cell and understand the full extent of the data.
3. Use Excel's Find & Replace (Ctrl + H) to locate and delete repeated header rows—type the exact header text in the "Find" field and leave "Replace" blank.
4. Alternatively, if you want to work with only a specific page range, use Extract Pages before converting to pull just the pages you need, then run the PDF-to-Excel conversion on that smaller file.

Step 5 — When to use CSV instead of Excel

If the table structure keeps breaking—columns merging, data appearing in the wrong cells—try converting to CSV as an intermediate format.

1. Open PDF to CSV.
2. Upload the same PDF.
3. Open the resulting .csv file in a text editor to verify the delimiter (comma, semicolon, or tab).
4. Import it into Excel using Data → From Text/CSV and specify the correct delimiter manually.

This approach gives you more control over how columns are separated and often handles simple, consistent tables better than a direct .xlsx conversion.

Step 6 — Fix common conversion problems

Merged or missing columns

Some PDFs use whitespace rather than table borders to define columns. The converter may misread column boundaries.

• In Excel, select the affected column and use Data → Text to Columns to split content by a delimiter or by fixed width.
• If a column contains numbers formatted as text (they appear left-aligned), select the cells, click the warning triangle, and choose Convert to Number.

Currency and date formatting

Currency symbols and date formats sometimes attach to the number during extraction. Use Excel's Find & Replace to strip unwanted characters (for example, replacing "$" with nothing across the column), then reformat the cells as Currency or Date.

Tables that span across a footnote or image

If the PDF contains images, footnotes, or charts between table rows, the converter may insert extra blank rows or garbled text at those positions. Delete those rows manually after conversion.

Browser tool versus desktop software

A browser tool like PDF to Excel is the right choice when:

• Your file is under 50 MB (free) or 500 MB (premium).
• The table is straightforward—one or two columns of consistent data.
• You need a quick one-off conversion without installing anything.
• You're working on a shared or locked-down computer.

Desktop software (such as Adobe Acrobat Pro or a dedicated data-extraction app) makes more sense when:

• You process hundreds of PDFs on a schedule or need automation via scripts.
• Your tables use complex merged cells, nested headers, or unusual encodings that require manual zone drawing.
• You must keep files entirely offline due to strict data-governance policies.

For the vast majority of one-off business tasks, a browser tool handles the job without the cost or complexity of desktop software.

Step 7 — Verify and clean the output

Never use converted data directly in a report or calculation without a quick audit.

1. Compare the row count in Excel to the visible rows in the original PDF.
2. Spot-check five to ten cells against the source to confirm values match.
3. Check numeric columns with a SUM formula and compare the total to any subtotal visible in the original PDF.
4. Look for cells containing only a hyphen or period—these often represent zero or a missing value in the original and may need correction.

Next steps

Once your table is clean in Excel, consider whether you need to share it back as a PDF—if so, Excel to PDF converts the finished spreadsheet in one step. If your original file was password-protected and you couldn't open it, Unlock PDF removes the restriction before you start the conversion workflow.