Blog
How to Convert PDF to Excel: 4 Methods and Fixes
The fastest way to convert PDF to Excel depends on what kind of PDF you have. If you can select the text with your mouse, it's a text PDF, and Excel for Microsoft 365 can pull its tables in directly with Data > Get Data > From File > From PDF. If the PDF is a scan of paper, it's an image, and you need text recognition (OCR) first, which means more checking afterwards.
The reason conversions break is that a PDF doesn't store rows and columns. It stores characters at positions on a page, and every converter has to guess which characters belong in the same row and column. When the guess is off, columns shift, amounts arrive as text, and the total no longer matches. If someone on your team retypes vendor statements or customer purchase orders every month, one of the four methods below will remove most of that work.
First, identify the kind of PDF
- Text PDF: produced directly by accounting software, an ERP or a "Save as PDF" command. You can drag-select text and Ctrl+F finds words. Excel and Word recover table structure from these fairly well.
- Scanned PDF: a photo or scan of paper. Nothing is selectable and search finds nothing. It needs OCR, and scan quality decides the result.
Some files mix both: a system-generated statement with a scanned, signed confirmation page at the end. What matters is the pages that hold the table.
The four methods at a glance
| Method | Best for | Requirement | Table structure |
|---|---|---|---|
| Excel Get Data From PDF | Text PDFs | Excel for Microsoft 365 on Windows | Detects tables; joins tables that continue across pages |
| Open in Word, copy | Text PDFs | Word 2013 or later | Simple tables survive well |
| Google Drive OCR | Scanned PDFs | Google account | Tables may not be preserved |
| Data From Picture | Photos and screenshots of tables | Excel for Microsoft 365 | Builds a table; limited languages |
Method 1: Get Data From PDF (Power Query)
For text PDFs, start here. The table comes straight into Excel, and the cleanup steps are saved so next month's file goes through the same steps automatically.
- On the Data tab, select Get Data > From File > From PDF.
- Pick the PDF and select Import.
- The Navigator lists what Excel found: tables named Table001, Table002 and pages named Page001 and so on. Click each to preview it on the right.
- Select Load if it's ready, or Transform Data to clean it in the Power Query Editor.
- Remove extra header rows, set the amount columns to a number type, then Close & Load.

According to Microsoft's PDF connector documentation, similar tables on consecutive pages are combined into one table by default, and you can limit the import to a page range with the StartPage and EndPage options in the Advanced Editor. For rows that span several lines, the same page suggests cleaning up with Fill Down or grouping.
Check your version before you look for the menu. Microsoft's Power Query data sources by Excel version table shows PDF as a source for Microsoft 365 subscriptions and not for Office 2016 or Office 2019 perpetual licenses, and Excel for Mac's Get Data list doesn't include PDF. If From PDF is missing, that's why.
To collect PDFs from several vendors in one pass, put them in one folder and use Get Data > From File > From Folder. Files with the same layout combine into one table, and next month you drop the new files in and select Refresh All.
Method 2: Open the PDF in Word
Word 2013 and later convert a PDF into an editable document. Choose File > Open, pick the PDF, accept the conversion message, then copy the table and paste it into Excel. Microsoft's support article notes the result won't always match the original layout and that conversion works best on PDFs that are mostly text. It's quick for a one-page table; on a long statement with a repeated header on every page, you'll be deleting those header rows by hand after pasting.
Method 3: Google Drive OCR for scans
- Upload the PDF to Google Drive.
- Right-click it and choose Open with > Google Docs.
- Copy the recognized text into Excel and split it into columns.

Google's help page sets the limits: files up to 2 MB, text at least 10 pixels tall, and while bold, font size and line breaks may carry over, lists, tables and columns may not. Expect a block of text rather than a table, followed by Data > Text to Columns in Excel.
Method 4: Data From Picture
Excel for Microsoft 365 can turn an image of a table into cells. On the Data tab, choose From Picture, then Picture From File or Picture From Clipboard; Excel analyzes the image, shows a preview where you can correct cells, and Insert Data places the result. A screenshot of a PDF page works fine.
Microsoft's Insert data from picture article lists supported languages (English and most Western and Central European languages) and, on Windows, requires Windows 11 or Windows 10 version 1903 or later with the WebView2 runtime. Crop the image to just the table and shoot it straight on, not at an angle.
Worked example: a vendor statement, start to finish
The purchasing coordinator at Ridgeline Manufacturing reconciles Northgate Supply's monthly statement against receiving records. The statement is a three-page text PDF with item number, description, quantity, unit price and extended amount, and a total at the bottom of page three.
- Identify the type. Dragging across a description selects it, so it's a text PDF. Method 1.
- Import. From PDF shows a single Table001 that already joins all three pages. Transform Data.
- Fix the headers. Promote the first row to headers and filter out the header rows repeated at the top of pages 2 and 3.
- Make numbers numbers. The amount column came in as text because of thousands separators. Changing its type to decimal fails on two rows; both have a trailing space. Trim, then change the type again.
- Check the total. The imported sum is $310 below the statement total. One long description wrapped onto two lines in the PDF and was split into two rows, pushing its amount into the wrong column. Merge the two rows to match the original.
- Match to receiving. Look up received quantity by item number and add a difference column. Two items differ: one was a partial shipment that arrives next month, the other was never received. Only those two go to Northgate Supply.
- Prepare for next month. Save next month's statement with the same name in the same folder and select Refresh All; steps 3 and 4 run again by themselves.
Most of the time went into step 5, not the conversion. Whatever tool you use, keep the total check.
👉 How to Use VLOOKUP in Excel: Exact Match and Other Sheets
Fixing broken tables after conversion
Columns shifted by one
PDFs often don't store empty cells, so a row with a blank notes field pulls the next value left. Filter the last column for non-blanks to find rows with the wrong column count, then fix those rows against the original, or re-split them by position in Power Query.
Numbers stored as text
A green triangle in the corner and left-aligned numbers mean text. Select the column, choose Data > Text to Columns and select Finish right away; Excel converts the values. If some stay as text, there's an invisible character: TRIM removes ordinary spaces, CLEAN removes control characters, and the non-breaking space common in PDFs and web pages (CHAR(160)) needs SUBSTITUTE.
Dates stored as text
Dates written as 09.15.2026 aren't recognized. Use Find & Replace to change the periods to slashes and Excel reads them as dates.
Merged cells
Merged cells block sorting and filtering. Unmerge everything, then fill the blanks from above: Find & Select > Go To Special > Blanks, type an equals sign, press the up arrow, then Ctrl+Enter.
FAQ
Q. I don't see From PDF under Get Data.
The PDF source is part of Excel for Microsoft 365 on Windows. On Office 2016 or 2019 perpetual versions, or on a Mac, use Word or Data From Picture instead.
Q. Which method is most accurate for scans?
Scan quality matters more than the tool: bright, straight-on, large text. With any method, compare totals with the original and recheck only the rows that don't add up.
Q. The same vendor sends the same PDF layout every month.
Set it up once with Get Data From PDF. Next month, replace the file and refresh. If the file name changes each month, edit the path in the query's Source step.
Q. Can I import a password-protected PDF?
Remove the open password first by saving an unprotected copy, or ask the vendor for an unprotected PDF or the original spreadsheet.
How inline AI handles PDF statements
Every conversion method leaves the same cleanup: fixing columns, converting amounts, checking totals. inline AI opens a vendor's PDF statement, builds the Excel table and shows the lines where totals or received quantities don't match first, and with ARP's purchasing module the statement amounts and receiving records sit side by side without a spreadsheet in between.
Hand your documents and your company’s work to inline AI.
Keep a file open, say what you need, and AI edits it or drafts a new one. Add the company AI OS and AI runs the rest of the work, ERP included.
Book a demo




