How to Import Data from PDF to Excel (2026)

Getting a table out of a PDF and into Excel used to mean tedious copy-paste-and-clean. Modern Excel has a built-in PDF importer that reads tables directly, and for tricky cases there are five other methods worth knowing. This guide walks through all six, with when-to-use guidance and how to clean whatever gets imported.

The six methods — quick comparison

For anything but the simplest cases, Method 1 (built-in importer) is the right starting point in modern Excel. The others exist for edge cases.

Method 1: Excel's built-in PDF importer

Excel 365 and 2021 have Power Query integrated with a PDF connector. This is the cleanest way to get PDF data into Excel — Excel detects tables, preserves structure, and gives you full transformation power before the data lands in a sheet.

The basic workflow

1. Browse to your PDF and click Import
2. The Navigator opens showing every table Excel detected, plus a full-page option per page
3. Click a table to preview it on the right
4. Select the table(s) you want (check multiple to import several)
5. Click Load to import as-is, or Transform Data to clean it first (recommended)

What Power Query gives you

If you click Transform Data, Power Query opens with your imported table. From here you can:

• Promote the first row to headers
• Remove unwanted columns
• Split combined columns (e.g., "Region - City" → Region + City)
• Filter out rows you don't want (repeated headers, subtotals, blank rows)
• Change column data types (Excel often imports numbers as text)
• Trim, clean, and normalize text values

Click Close & Load in Power Query to bring the cleaned data into a worksheet as an Excel Table.

What if Excel doesn't detect tables?

PDFs without clear table borders or with unusual layouts sometimes confuse the detector. In the Navigator:

• Look for "Page 1", "Page 2" entries — these import the full text of each page
• Full-page imports need more cleaning but at least get the data into Excel
• Use Power Query's Split Column By Position or By Delimiter to reconstruct columns

Method 2: Copy-paste

The oldest approach. Sometimes the fastest when you need just a small block.

How to

1. Open the PDF in a viewer (Adobe Reader, Chrome, Preview)
2. Select the table with the mouse — click and drag over the cells
3. Ctrl+C to copy
4. Switch to Excel, click the target cell
5. Ctrl+V to paste

Why it usually gets messy

PDF text has absolute positions on the page, not table structure. Copy-paste often produces:

• All values crammed into a single column (spaces where columns should be)
• Column breaks in wrong places
• Numbers pasted as text
• Merged multi-line cells becoming multiple rows

Cleaning after paste

If the data lands in one column with delimiters between values:

1. Select the pasted column
2. Data → Text to Columns
3. Choose Delimited → Next
4. Check Space (or whatever your delimiter is)
5. Preview the split → Next → Finish

Method 3: Adobe Acrobat export

If you have Adobe Acrobat Pro (not the free Reader), it has native Excel export that often handles complex layouts better than Excel's own importer.

How to

1. Open the PDF in Acrobat Pro
2. File → Export To → Spreadsheet → Microsoft Excel Workbook
3. Choose a filename and location
4. Acrobat converts the PDF to XLSX
5. Open the result in Excel and clean as needed

When it beats Excel's importer

• PDFs with complex nested tables
• Invoices with header/line-item/footer structure
• PDFs where Excel's importer misses tables entirely
• Bank statements with unusual column layouts

Downsides

• Requires paid Acrobat Pro subscription (~$15-20/month)
• Result is a static XLSX — no auto-refresh when the PDF updates
• Very complex PDFs still need manual cleanup

Method 4: Word as intermediate

Surprisingly effective when Excel's PDF importer isn't available (older Excel versions) or produces bad results.

How to

1. Open Word
2. File → Open → select your PDF
3. Word offers to convert the PDF to an editable document — click OK
4. Word reconstructs the PDF as a Word document, often with tables intact
5. Select the table in Word
6. Ctrl+C to copy
7. Switch to Excel and Ctrl+V — the table structure usually pastes cleanly

Why it works

Word's PDF converter is different from Excel's. It reconstructs the document's flow, including table borders and cell boundaries — and Word tables paste into Excel cleanly with column and row structure preserved. For some PDFs, this is the smoothest path.

Method 5: Online converters

Sites like Smallpdf, ILovePDF, PDFtoExcel.com convert PDFs to Excel in the browser. Fast for one-off jobs when you don't have Acrobat Pro or the built-in importer.

Popular options

• Smallpdf — clean UI, 2 free conversions per day
• ILovePDF — similar model, free tier available
• PDFtoExcel.com — free, no signup, ads on the page
• Adobe's online converter — free with Adobe account, less generous than desktop Acrobat

Method 6: OCR for scanned PDFs

A scanned PDF is an image of a document, not searchable text. Excel's importer sees nothing. Copy-paste selects only image data. Solution: OCR (optical character recognition) turns the image back into text first.

How to tell if a PDF is scanned

Open the PDF and try to select text with the cursor. If you can highlight individual words, it's text-based. If your selection just makes a rectangle over the "image" of the text, it's scanned.

OCR options

Adobe Acrobat Pro (best quality)

1. Open the PDF in Acrobat Pro
2. Tools → Scan & OCR → Recognize Text → In This File
3. Acrobat OCRs the pages in place
4. Save the file
5. Now use any import method — the PDF has real text

Microsoft OneNote (free)

1. Print the PDF to OneNote (using OneNote as a printer destination), or insert as printout
2. Right-click the image → Copy Text from Picture
3. Paste the extracted text into Excel

Google Drive (free)

1. Upload the PDF to Google Drive
2. Right-click → Open with → Google Docs
3. Docs OCRs the PDF and opens it as an editable document
4. Copy the table content from Docs
5. Paste into Excel

Multi-page and multi-table PDFs

Bank statements and reports with the same table on every page

The typical PDF report has repeated headers on every page. Excel's importer detects each page's table separately.

Combining them

1. Data → Get Data → From File → From PDF
2. In the Navigator, select all the table entries you want to combine (Ctrl+click)
3. Click Transform Data
4. Power Query opens with each table as a separate query in the left panel
5. Right-click one query → Reference (to keep original intact)
6. Home → Append Queries → Append Queries as New → select the others
7. The new query has all rows combined
8. Filter out duplicated header rows, clean as needed
9. Close & Load

PDFs with different tables per page

Contracts, prospectuses, financial reports often have different tables on different pages. Import them separately in the Navigator, then decide which you actually need. There's no benefit to combining unrelated tables.

Very long PDFs

PDFs with hundreds of pages can take Excel a while to parse. If it hangs, split the PDF into smaller chunks first (Acrobat Pro or online splitters) and import each chunk. Then combine in Power Query.

Cleaning imported data

PDF-imported data almost always needs cleanup. Power Query is designed for exactly this.

Remove repeated headers

If the source PDF repeated its header on every page, you'll see multiple copies. Filter them out:

1. Click the header dropdown of the first column
2. Uncheck the value that matches the header text
3. OK

Split combined columns

PDF tables sometimes have columns that got glued together. Right-click column → Split Column → By Delimiter → choose the delimiter (space, tab, comma) → OK. Or Split By Position for fixed-width formats.

Fix data types

Numbers and dates often arrive as text. Click the column header's type icon (small ABC, 123, or date symbol) → pick the correct type. Power Query converts and flags any values it can't convert.

Clean whitespace and special characters

Transform → Format → Trim (removes leading/trailing spaces)
Transform → Format → Clean (removes non-printable characters)
Transform → Replace Values (custom find and replace)

Currency and percentages

"$1,234.56" imports as text because of the $ and comma. Steps to convert:

1. Right-click column → Replace Values → find "$" → replace with "" (nothing)
2. Right-click column → Replace Values → find "," → replace with ""
3. Right-click column → Change Type → Decimal Number

Merged multi-line cells

Long addresses or descriptions in the PDF sometimes wrap to multiple rows, causing extra rows in Excel. In Power Query: Group By the ID column with an aggregation of "All Rows", then extract Text.Combine to merge the fragments back.

Automating with refresh

Once your import + cleanup is saved as a Power Query script, refreshing is one click.

Manual refresh

Data → Refresh All. Power Query re-reads the PDF file (from the same path) and re-runs all your cleanup steps.

Auto-refresh on open

1. Data → Queries & Connections
2. Right-click your query → Properties
3. Check "Refresh data when opening the file"
4. OK

Every time you open the workbook, Excel re-imports the PDF and re-applies all transformations. Perfect for monthly reports where the file path stays consistent (just replace the PDF at the same location).

Timed refresh

In the same Properties dialog, "Refresh every X minutes" for continuous re-import. Useful for PDFs that update automatically (server-generated reports).

Common pitfalls

Google Sheets equivalent

Google Sheets doesn't have a native PDF importer. Workarounds:

• Open the PDF with Google Docs (auto-OCRs it), then copy from Docs to Sheets
• Use an add-on like DocParser or PDFTables that connects to Google Sheets
• Convert externally (Adobe, online tool) to XLSX, then upload to Sheets

For repeated automated imports of the same PDF format, Google Sheets works best when paired with Apps Script and the DriveApp API to OCR PDFs and extract text programmatically.

Frequently asked questions