The three ways to move PDF data into Excel

You can move data from a PDF into Excel in three ways: copy and paste if the PDF is straightforward, use Excel's built-in import tool for structured tables, or convert the PDF to a format Excel reads natively. Which method works depends on how the PDF is organized — whether it contains a clean table, scattered text, or scanned images.

The fastest route for a single table is copy-paste. If you have many PDFs or complex layouts, Excel's "Get & Transform" feature (called Power Query in some versions) handles the work more reliably. Conversion tools exist but add a step and sometimes introduce errors, so try the native methods first.

Key Takeaways

  • Copy and paste works when ready for PDFs with straightforward tables, but reformatting in Excel afterward is often necessary.
  • Excel's Get & Transform feature (in the Data tab) can import structured PDF tables directly without manual copying.
  • Scanned PDFs or image-based documents cannot be imported — you need optical character recognition (OCR) software first, which is a separate step.
  • Once data lands in Excel, check that numbers imported as text and dates imported in the correct format before you rely on calculations.

Copy and paste from a PDF directly into Excel

Open the PDF in your PDF reader (Adobe Reader, Preview on Mac, or your browser) and select the table or text you need. Use Ctrl+C (Windows) or Command+C (Mac) to copy. Then click into an Excel cell where you want the data to start and use Ctrl+V (Windows) or Command+V (Mac) to paste.

This method works well when the PDF contains a clean, single table with clear rows and columns. The data usually lands in the right cells, though spacing and formatting often need adjustment. If the PDF has multiple tables, headers, or mixed text and numbers, the paste may scatter across cells unpredictably — you will need to clean it up manually afterward.

After pasting, check two things: whether numbers appear as text (they will be left-aligned instead of right-aligned), and whether dates imported in a format Excel recognizes. If numbers are text, select the column, go to Data > Text to Columns, and click Finish to convert them. If dates are wrong, you may need to reformat the column or re-enter them.

Use Excel's Get & Transform feature for structured PDFs

If your PDF contains a table with consistent rows and columns, Excel can read it directly without copying. Open Excel, go to the Data tab, and look for "Get Data" or "Get & Transform" (the name varies by Excel version). Click it, select "From File," then "From PDF."

Navigate to your PDF file and open it. Excel will show you a preview of any tables it finds. Select the table you want and click Load. Excel imports it into a new sheet, and the data lands in cells automatically. This method is more reliable than copy-paste because Excel recognizes the table structure itself rather than relying on what you select.

After import, the data appears in a table format that you can sort, filter, and refresh if the PDF updates. If the PDF contains multiple tables, Excel shows you all of them and you can choose which ones to load. This approach saves time if you need to import the same PDF repeatedly or work with several similar PDFs.

What to do if the PDF is a scanned image

If the PDF is a scanned document or photograph of a page, neither copy-paste nor Get & Transform will work — Excel cannot read text from images. You need optical character recognition (OCR) software first, which converts the image into readable text.

Free options include Google Docs (upload the PDF, and Google will OCR it automatically, then you can copy the text) or Microsoft OneNote (insert the image, right-click it, and select "Copy Text from Picture"). Paid tools like Adobe Acrobat Pro include OCR built in. After OCR converts the image to text, you can then copy that text into Excel or use Get & Transform.

OCR is not perfect — it makes mistakes on blurry scans, handwriting, or unusual fonts. Always check the converted text against the original before you rely on it for calculations or decisions.

Cleaning up data after import

Data from PDFs often arrives in Excel with extra spaces, merged cells, or formatting that does not match what you need. After importing, select all the data and use Find & Replace (Ctrl+H on Windows, Command+H on Mac) to remove extra spaces. Search for two spaces and replace with one space, then repeat until no more replacements occur.

Check for merged cells by selecting the data range and going to Home > Merge & Center > Unmerge Cells. Merged cells cause problems when sorting or filtering. If columns are too narrow to display the data, double-click the border between column headers to auto-fit the width.

Numbers that imported as text will not calculate correctly. Select the column, go to Data > Text to Columns, choose Delimited, click Next twice, and then Finish — this converts text to numbers. For dates, select the column and use Home > Format Cells to set the date format you need.

When to use conversion tools instead

Online PDF-to-Excel converters exist, but they add an extra step and sometimes introduce errors or privacy concerns. They work by uploading your file to a server, converting it, and sending back an Excel file. If your PDF contains sensitive information, this route exposes it to a third party.

Use a converter only if your PDF is complex (multiple tables, unusual layouts) and the native methods fail. Even then, check the output carefully — converters often misalign columns or misread numbers. For one-time imports, copy-paste or Get & Transform is usually faster than learning a new tool.

Frequently Asked Questions

Why do my numbers show as text after I paste them into Excel?

PDFs store numbers as text characters, not as numeric values. Excel does not automatically convert them. Select the column, go to Data > Text to Columns, click Next twice, and click Finish. This tells Excel to treat them as numbers so you can use them in formulas.

Can I import a PDF with multiple tables at once?

Get & Transform can show you all tables in a PDF and let you choose which ones to load. If you use copy-paste, you will need to copy each table separately. For many tables, Get & Transform saves time because you can load them all in one session.

What if the PDF table has columns that are too narrow and text got cut off?

The PDF itself does not contain the cut-off text — it was never there. You cannot recover it from the PDF. If you have the original document the PDF came from, use that instead. Otherwise, you may need to contact whoever created the PDF and ask for a version with full column widths.

Does Get & Transform work on Mac?

Yes, but the feature is called "Get & Transform" on Windows and "Get Data" on Mac. The steps are the same: go to Data, click Get Data, select From File, then From PDF. Older versions of Excel for Mac may not have this feature — if you do not see it, copy-paste is your option.

Can I automate importing PDFs into Excel?

Yes, but it requires Excel macros or a tool like Power Automate (Microsoft's automation platform). For occasional imports, manual copy-paste or Get & Transform is simpler. If you import the same PDF weekly or monthly, a macro can save time — search for "Excel VBA PDF import" to find examples that match your setup.