How to Copy a Table From PDF to Excel: Keep the Columns (2026)

Copy-pasting a PDF table into Excel usually dumps everything into one column, a mess. The trick is to import the table so its rows and columns stay intact. Here are the reliable ways to get a PDF table into Excel cleanly, including Excel's own built-in importer.

Method 1: Excel's "Get Data From PDF" (Best for Clean Tables)

Modern versions of Excel (Microsoft 365 and Excel 2021+) can import PDF tables directly with Power Query.

1. Open a blank workbook and go to the Data tab.
2. Click Get Data > From File > From PDF.
3. Select your PDF and click Import.
4. In the Navigator window, Excel lists the tables and pages it found. Click a Table to preview it on the right.
5. Click Transform Data (not Load) to clean it up in the Power Query Editor.
6. If your headers landed in the first row, click Use First Row as Headers. Filter out any stray null rows or page numbers.
7. Click Close & Load to drop the table into your worksheet.

Tip: If a table imports messily, choose the Page object instead of the Table object in the Navigator, sometimes the whole-page view captures the data more accurately.

Method 2: Extract the Text First (Free, No Excel Add-ins)

If you don't have the PDF connector, or the table is simple, pull the text out and paste it in.

1. Open PDF Zone's Extract Text tool.
2. Upload the PDF: it's processed locally, never uploaded.
3. Copy the extracted text.
4. Paste it into Excel, then select the column and use Data > Text to Columns to split it on spaces, commas, or tabs into proper columns.

This works everywhere and keeps your file private.

Method 3: Copy From a Scanned Table

If the PDF is a scan, there's no text to copy at all, it's an image. Run it through PDF Zone's OCR PDF tool first to turn the picture into real text, then use Method 1 or 2.

Fixing Common Problems

• Everything in one column: you pasted raw text: use Data > Text to Columns to split it, or use the Get Data method.
• Numbers stored as text: select the column and use Convert to Number, or multiply by 1.
• Merged headers: clean them in Power Query with Use First Row as Headers and remove blank rows.
• Rows split awkwardly: try importing the Page object instead of the Table object.

Frequently Asked Questions

How do I copy a table from a PDF to Excel?

The cleanest way is Excel's Data > Get Data > From File > From PDF, which imports the table with columns intact. Alternatively, extract the text with PDF Zone's Extract Text tool and split it using Text to Columns.

Why does my PDF table paste into one Excel column?

A plain copy-paste loses the table structure, so everything lands in one column. Use Get Data > From PDF, or after pasting text use Data > Text to Columns to separate it back into columns.

Does Excel have a built-in PDF importer?

Yes. Microsoft 365 and Excel 2021+ include Get Data > From File > From PDF, which uses Power Query to detect and import tables from a PDF.

How do I copy a table from a scanned PDF?

A scan is an image with no selectable text. Run it through the OCR PDF tool first to create real text, then import it into Excel.

Can I get a PDF table into Excel for free?

Yes. Extract the text with PDF Zone's free Extract Text tool and paste it into Excel, then split it with Text to Columns, no add-ins or subscriptions required.

My imported numbers are treated as text: how do I fix it?

Select the column and choose Convert to Number, or multiply the values by 1 in a helper column. This forces Excel to treat them as numeric.

What if the table imports messily with Get Data?

In the Navigator, try selecting the Page object instead of the Table object, then clean the result in Power Query using Use First Row as Headers and by filtering out blank rows.

Is it safe to extract a PDF table online?

With PDF Zone, yes, the Extract Text tool and OCR PDF tool run locally in your browser and never upload your file, keeping financial data private.

---

Sources: Microsoft. Power Query PDF connector. Related: Extract Text · OCR PDF.