Excel cannot open a PDF as a spreadsheet, but you have several ways to get the data out

Excel does not treat a PDF like a spreadsheet file. If you double-click a PDF, it opens in your PDF reader, not in Excel. However, you can move data from a PDF into Excel using three main routes: copying and pasting text directly, using Excel's built-in import tool, or converting the PDF first. Which method works depends on how the PDF is structured and how much data you need to move.

The fastest route for small amounts of data is copy and paste. For tables embedded in a PDF, Excel's import feature (called "Get & Transform" or "Power Query") can sometimes pull the table automatically. For complex PDFs or when those methods fail, you will need to convert the PDF to another format first — usually CSV or Excel format — using a separate tool.

Key Takeaways

  • Copying text directly from a PDF and pasting it into Excel works for small tables but may require cleanup of formatting.
  • Excel's "Get & Transform" feature (Windows) or "Queries" (Mac) can import tables from PDFs automatically if the table structure is clear.
  • PDFs created from scanned images cannot be imported into Excel without first converting them using OCR software.
  • Online PDF-to-Excel converters exist but require uploading your file to a third-party server, which poses a privacy risk for sensitive documents.
  • Desktop conversion tools like Adobe Acrobat Pro or free alternatives like LibreOffice can convert PDFs to Excel format without uploading your data.

Copy and paste for simple tables

Open the PDF in your PDF reader (Adobe Reader, Preview on Mac, or your browser). Select the table or text you want to move by clicking and dragging to highlight it. Right-click and choose "Copy" or use Ctrl+C (Windows) or Command+C (Mac).

Switch to Excel and click the cell where you want the data to start. Right-click and choose "Paste" or use Ctrl+V (Windows) or Command+V (Mac). Excel will paste the content, though it may not land in separate columns the way you expect. You may need to use Excel's "Text to Columns" feature to split the data into columns: select the pasted data, go to the Data tab, click "Text to Columns," and follow the wizard to tell Excel where the column breaks are.

This method works best when the PDF table has clear structure — rows and columns that line up visually. If the PDF is a scanned image of a table rather than a digital document, copy and paste will not work because the text is not selectable.

Using Excel's Get & Transform feature to import tables

On Windows, Excel has a built-in tool called "Get & Transform" (or "Power Query" in older versions) that can sometimes pull tables directly from a PDF. Open Excel, go to the Data tab, and look for "Get Data" or "New Query." Click it and select "From File" then "From PDF."

Navigate to your PDF file and select it. Excel will show you a preview of any tables it found in the PDF. If the table you want appears in the preview, select it and click "Load." Excel will import it into a new sheet. You may still need to clean up formatting or remove extra rows, but the column structure is usually preserved.

On Mac, this feature is called "Queries" and works similarly: go to the Data tab, click "New Query," select "From File," then "From PDF." The process is the same, though the menu names differ slightly. This method only works if the PDF contains actual text (not a scanned image) and the table has a clear structure that Excel can recognize.

Converting a PDF to Excel format before opening

If the copy-and-paste method is too slow or the Get & Transform feature does not recognize your table, you can convert the PDF to an Excel-compatible format first. The most reliable desktop tool is Adobe Acrobat Pro, which costs money but converts PDFs to Excel format with high accuracy. Open the PDF in Acrobat Pro, go to "File" then "Export To," select "Spreadsheet," choose "Microsoft Excel Workbook," and save the file. You can then open the resulting Excel file normally.

LibreOffice is a free alternative. Download and install it, open the PDF in LibreOffice Calc (the spreadsheet application), and save it as an Excel file (.xlsx). The conversion quality varies depending on the PDF structure, but it handles most tables reasonably well.

For scanned PDFs (images of documents), you will need OCR software first. Adobe Acrobat Pro includes OCR and can convert a scanned PDF to searchable text, which you can then export to Excel. Free OCR tools like Tesseract (command-line only) or online OCR services exist, but they require more technical steps or uploading your document to the internet.

Why online PDF-to-Excel converters carry privacy risks

Many websites offer free PDF-to-Excel conversion. These services work by uploading your PDF to their server, converting it there, and sending you the result. The problem: your document is now stored on someone else's computer, and you have no way to verify what happens to it after the conversion is done.

If your PDF contains sensitive information — financial records, medical data, personal details — uploading it to an unknown service is a significant privacy risk. The service may delete the file after conversion, but you are trusting their word. Some services also use your uploads to train machine learning models or sell anonymized data.

If you must use an online converter, choose one run by a company with a clear privacy policy and a track record you can verify. Better still, use a desktop tool like LibreOffice or Adobe Acrobat Pro, which keeps your file on your own computer.

When the PDF is a scanned image

If you try to copy text from a PDF and nothing happens, or if the text comes out as gibberish, the PDF is likely a scanned image — a photograph of a document rather than a digital document with selectable text. Copy and paste will not work, and neither will Get & Transform.

You need OCR (Optical Character Recognition) software to convert the image into readable text first. Adobe Acrobat Pro includes OCR: open the scanned PDF, go to "Tools," select "Recognize Text," choose "In This File," and let it process. Once complete, the text becomes selectable and you can copy it to Excel.

If you do not have Acrobat Pro, Google Drive offers free OCR. Upload the PDF to Google Drive, right-click it, select "Open With," then "Google Docs." Google will convert the image to text. You can then copy the text and paste it into Excel, though you will likely need to clean up the formatting afterward.

Troubleshooting common problems

The data pastes into one column instead of multiple columns. After pasting, select the column, go to the Data tab, and click "Text to Columns." Choose "Delimited" and select the character that separates your columns (usually a space, comma, or tab). Click through the wizard and Excel will split the data into separate columns.

The PDF opens in your browser instead of Excel. This is normal — PDFs are not a spreadsheet format, so your computer defaults to opening them in a PDF reader. You must manually copy the data or use one of the import methods described above. You cannot simply "open" a PDF in Excel the way you open an .xlsx file.

Get & Transform does not show your table in the preview. This usually means the table structure in the PDF is not clear enough for Excel to recognize it automatically. Try copy and paste instead, or convert the PDF to another format first using LibreOffice or Adobe Acrobat Pro.

The converted file has extra rows, merged cells, or formatting errors. This is common when converting from PDF. Open the converted file in Excel and clean it up manually: delete empty rows, unmerge cells if needed, and reformat as necessary. Conversion is rarely perfect, especially for complex layouts.

Frequently Asked Questions

Can I save a PDF as an Excel file directly?

No. A PDF is a fixed-format document designed for viewing and printing, not for data entry or calculation. You cannot "save as" a PDF to Excel format. You must either copy the data out manually or use a conversion tool to extract the data and reformat it as a spreadsheet.

What is the difference between Get & Transform and copy-and-paste?

Copy and paste is manual and works for any visible text, but requires you to select and clean up the data yourself. Get & Transform is automatic and preserves column structure, but only works if Excel recognizes the table and the PDF contains selectable text, not images.

Is it safe to use free online PDF converters?

Free online converters work, but they require uploading your file to a third-party server. If your PDF contains sensitive information, this is a privacy risk. Desktop tools like LibreOffice keep your file on your own computer and are safer for confidential documents.

Why can't I select or copy text from my PDF?

The PDF is likely a scanned image — a photograph of a document rather than a digital file with text. You need OCR software to convert the image to readable text first. Adobe Acrobat Pro, Google Drive, or free OCR tools can do this, though the results vary depending on image quality.

Does Excel have a native PDF import feature?

Excel's Get & Transform (Windows) and Queries (Mac) can import tables from PDFs, but only if the PDF contains selectable text and the table structure is clear. For complex PDFs or scanned images, conversion tools or manual copy-and-paste are more reliable.