2 Simple Ways to Copy a Table from a PDF to Excel

Before You Start: Know What Kind of PDF You Have

1) “Selectable” PDF (best-case scenario)

If you can drag your cursor over text in the PDF and highlight it like a normal document,
you’ve got a selectable PDF. This usually means the table data is real text, not just an image.
Both methods in this guide work well here.

2) Scanned PDF (a.k.a. “It’s basically a photo”)

If highlighting doesn’t workor you can only select the entire page like a single pictureyour PDF is likely scanned.
Excel may not detect tables correctly without OCR (optical character recognition). Don’t panic:
you can still succeed, but you may need an OCR step (often built into PDF tools) before Excel can read it cleanly.

3) Complex tables (merged cells, multi-line headers, multi-page tables)

PDFs love visual formatting. Excel loves structure. When a table has merged cells, stacked headers,
footnotes inside cells, or breaks across pages, you’ll want the method that lets you preview and reshape data
before it lands in your sheet.

Method 1: Import the Table Using Excel’s “From PDF” (Power Query)

If your goal is accuracyand especially if the table is largethis is your best friend.
Excel can connect to a PDF, detect available tables, and load them into a worksheet or into Power Query
so you can tidy things up before importing.

Best for

• Multi-page tables or long tables
• Tables with consistent columns (invoices, statements, reports)
• Anyone who wants fewer “Why are my numbers all stuck together?” moments

Step-by-step (Windows Excel with Get & Transform / Power Query)

1. Open Excel and create (or open) the workbook where you want the table.
2. Go to the Data tab.
3. Select Get Data → From File → From PDF.
4. Choose your PDF file and click Open.
5. In the Navigator window, Excel will show detected tables and pages. Click each one to preview.
   (Yes, this is the “try before you buy” momentuse it.)
6. Pick the table you want, then choose one:
   • Load to send it directly into a worksheet, or
   • Transform Data to open Power Query and clean it first.
7. If you used Power Query, make any fixes (more on that below), then click Close & Load.

Example: Importing a bank statement table (the polite version of chaos)

Imagine a PDF statement with columns like Date, Description, Debit, Credit, Balance.
Excel’s PDF import often recognizes that as a single table. You can preview the table in Navigator,
select it, and load it into Excel with the columns already separated. That’s the dream.

Power Query quick fixes (the “save my sanity” toolkit)

• Column alignment issues: If one column shifts because some rows have missing values,
  you can fill blanks or split columns in Power Query to restore structure.
• Headers are weird: Use “Use First Row as Headers” or remove top rows that contain titles/notes.
• Numbers imported as text: Change the data type for the column (Decimal Number, Whole Number, Date).
• Extra junk rows: Filter out totals, footnotes, or page numbers before loading into Excel.

Common “Where is From PDF?” problem

If you don’t see From PDF under Get Data, your Excel version/build may not support the PDF connector
(or it may be platform-dependent). In that case, skip to Method 2 below, or use a PDF tool to export/OCR first.

Method 2: Copy & Paste + Text to Columns (Fast and Shockingly Effective)

This is the quick method when you have a smaller table, the PDF text is selectable,
and you’d rather not open Power Query just to copy three columns and a dream.
The trick is: paste first, then teach Excel where the columns are.

Best for

• Small to medium tables (think: 5–200 rows)
• One-off tasks (you’re not building a repeatable workflow)
• Select-and-copy PDFs where the table isn’t overly complex

Step-by-step

1. Open the PDF in a viewer (Adobe Reader, browser PDF viewer, etc.).
2. Select the table:
   • Try dragging to highlight only the table cells.
   • If selection is finicky, zoom in and select row-by-row (less glamorous, more reliable).
3. Copy the selection (Ctrl+C on Windows, Cmd+C on Mac).
4. In Excel, click the top-left destination cell (usually A1) and paste (Ctrl+V / Cmd+V).
5. Now fix structure using Data → Text to Columns:
   • Select the pasted column(s) (often everything lands in one column first).
   • Choose Delimited.
   • Pick the delimiter that matches what you see: Tab, Space, Comma, etc.
   • If spacing is messy, try “Treat consecutive delimiters as one” (when available) to avoid phantom columns.
   • Click Finish.
6. Final cleanup:
   • Adjust column widths.
   • Format numbers (Currency, Accounting, Date).
   • Remove stray line breaks in cells if needed.

Realistic mini-example: When everything pastes into one column

Say your PDF row looks like this when pasted: 01/15/2026   Widget Purchase   39.95   0.00   402.10
If those values are separated by consistent spaces or tabs, Text to Columns can split them cleanly.
If the Description field contains multiple spaces (because of wrapping), you may need to try tabs first (best),
or temporarily replace multiple spaces, or split in stages.

When copy/paste goes sideways (and how to un-sideways it)

• Columns drift because descriptions wrap: Try copying fewer columns at a time
  (e.g., copy Date + Amount first, then Description separately).
• Numbers become text: Use “Convert to Number,” or apply VALUE() in a helper column.
• Line breaks inside a cell: Use Find & Replace and replace line breaks with a space.
• Merged header rows: Manually rebuild the header row in Excelfaster than fighting it.

Which Method Should You Use? A 30-Second Decision

Troubleshooting Cheat Sheet (Because PDFs Don’t Believe in Your Deadlines)

Problem: Excel doesn’t detect any tables in Navigator

This often happens with scanned PDFs or visually complex layouts. Run OCR in a PDF tool first,
then try importing again. If the PDF is truly just an image, Excel can’t “read” it as structured data without OCR.

Problem: Your “Amount” column is stuck as text

If you see little green triangles or amounts that won’t sum, you’re dealing with text numbers.
Try converting the column to Number format, using “Convert to Number,” or applying VALUE().
Also watch for hidden characters like non-breaking spaces.

Problem: Dates turn into nonsense

PDFs sometimes store dates as text with inconsistent spacing. Standardize the date format before converting,
and confirm your locale settings. If needed, split the date into components and recombine with DATE().

Problem: Rows break in the middle because of wrapped cell text

If a long description wraps visually, copy/paste may insert line breaks that Excel interprets as new rows.
Power Query can help consolidate text, or you can replace line breaks after pasting.

Problem: You only need one table out of a giant PDF

With Method 1, you can select a specific detected table in Navigator and load only that.
With Method 2, copy only the table region you need (zoom in, copy section-by-section).

Conclusion

If you remember nothing else, remember this: PDFs are designed to look right, not to behave nicely in Excel.
When accuracy matters or the table is large, use Excel’s From PDF import so you can preview and clean data properly.
When speed matters and the table is simple, copy/paste + Text to Columns gets the job done with minimal fuss.

Either way, you’re no longer stuck retyping 200 rows like it’s 1998. Your wrists (and your future self) thank you.

Bonus: of Real-World Experience (a.k.a. “I’ve Been Hurt Before”)

The first time I copied a PDF table into Excel, I felt unstoppableright up until Excel politely informed me that
every number was “text,” every date was “maybe a date,” and my totals were “definitely not totaling.”
That’s the PDF-to-Excel rite of passage: you start confident, then you end up Googling “why is SUM not working”
at 1:00 a.m. while whispering motivational speeches to your spreadsheet.

Here’s what experience teaches you fast: the best approach depends less on Excel skill and more on how the PDF was made.
A digitally generated PDF (like an exported report) is usually cooperative. A scanned PDF (like a printed invoice
someone faxed in 2006 and then scanned again for good measure) is basically a prank. If you can’t highlight text in the PDF,
don’t waste time blaming yourselfrun OCR first. After OCR, suddenly Excel can “see” real characters instead of a
high-resolution picture of sadness.

Another lesson: copy/paste is a sprinter, not a marathon runner. For a 10-row table, Method 2 is gloriouspaste,
Text to Columns, done. For 500 rows, Method 2 becomes a slow-motion disaster as line breaks multiply, spacing changes,
and one random row decides to merge three columns into a single cell like it’s trying to start a new life.
That’s when Method 1 earns its keep. Power Query lets you preview tables, remove junk rows, rename headers,
and set data types before anything lands in your worksheet. It’s like washing vegetables before cooking instead of
after you’ve already served the salad.

The most common “gotcha” I see is wrapped text in description columnsespecially in bank statements, shipping logs,
and procurement reports. The PDF looks aligned because it’s visually aligned, but under the hood it may be placed
as separate text blocks. When you paste, Excel can interpret those blocks as new rows. My workaround is boring
but effective: copy fewer columns at once (Date + Amount first), then bring over Description separately, or use
Method 1 so you can reshape the data in a controlled environment.

Finally, treat the first import as a draft. Even a “perfect” conversion usually needs one minute of polish:
confirm numbers are numeric, dates are dates, and headers aren’t duplicated. If you build that quick QA habit,
PDF-to-Excel stops being a dreaded task and becomes a repeatable, reliable workflowone that doesn’t end with
you bargaining with your laptop like, “Please, just give me columns. That’s all I ask.”