First, open the PDF and try selecting a few words in the table. To convert a PDF into Excel, selectable text is a good candidate for Excel’s PDF import; a page that is only an image needs optical character recognition (OCR) or manual entry first. Either route calls for a review before you calculate with the results.
Converting a PDF to Excel with Get Data
How do I convert a PDF to Excel when the document contains selectable tables? Try the PDF connector in Excel for Windows. Microsoft describes these steps in its Power Query import instructions:
- Open a blank workbook and choose Data > Get Data > From File > From PDF.
- Select the PDF and choose Open. In Navigator, select a detected table to preview it.
- Choose Load to put it in a worksheet, or Transform Data to inspect and clean it in Power Query before loading.
- Save the workbook with a new name and keep the original document for comparison.
Navigator may offer several tables or pages. Preview each candidate: the table you want may be split across pages, and a decorative line may be mistaken for a boundary. If the preview is incomplete, try another detected item or import the pieces separately. Transferring PDF tables to Excel is easier to check when you keep the source open beside the workbook.
The available commands depend on your Excel version and platform. If the PDF option is missing, check whether another supported installation is available or ask your organization’s IT team. Microsoft notes that the PDF connector may also require an additional .NET component. For a small selectable table, copying and pasting into a worksheet can be a workable fallback; inspect the resulting columns carefully.
Work with a scan
If you cannot select the words, zoom in: an image-only scan often looks like a photograph of a page. Selectability is a useful clue, though a PDF can contain both image and text pages. For a scan, use an OCR tool approved for your document to recognize the characters, then review and transfer the output into a worksheet. Poor contrast, skewed pages, handwriting, and tiny numbers can make recognition difficult.
Where available, Excel’s Data from Picture can read a cropped image of a table. Capture a clear, straight-on image or screenshot of just the table, then choose Data > From Picture > Picture From File or Picture From Clipboard. Review the proposed values and correct flagged cells before selecting Insert Data. Check unflagged cells too; a confident-looking result can still contain a wrong digit.
Before uploading a file or image to any service, check whether it contains financial, medical, customer, or other confidential information. Use tools and storage your organization permits, and check the provider’s handling and retention terms. If an online service is not approved, use an approved alternative or enter a small table by hand. A screenshot can contain just as much sensitive information as the original.
Repair and verify the result
How do I convert a PDF to Excel while keeping the imported values usable? Check that each heading sits above the correct column and that rows have not merged or disappeared at page breaks. If a value has landed in the wrong cell, move it; if several fields landed together, split them into separate columns and compare the result against the source. For a short, badly detected table, retyping a few rows may be faster than repairing a complicated import.
When moving a PDF table into Excel, pay special attention to dates and numbers. A date interpreted in the wrong order can change its meaning, and an amount stored as text may be skipped by a sum. Check decimal points, minus signs, leading zeros in identifiers, and totals. Set identifiers to text where leading zeros matter; correct the data type for amounts and dates before calculating.
After converting a PDF to Excel, compare the first and last rows and a few rows around a page break with the original. Confirm their headings, dates, and amounts, then test a small total by hand before relying on formulas across the workbook.