Excel cannot open PDF files directly, but you can convert the PDF content into a spreadsheet format that Excel can read

When you try to open a PDF file in Excel, nothing happens — or Excel opens and shows you an error. This is not a flaw. Excel reads spreadsheet formats like .xlsx and .csv. A PDF is a different kind of file designed to look the same on any device, not to be edited in a spreadsheet. The content inside a PDF might be a table or data, but the PDF wrapper itself is not something Excel recognizes.

The real question is whether the data you need is actually in that PDF, and if so, how to get it into a format Excel can work with. The answer depends on what kind of PDF you have and how much data is inside it.

Key Takeaways

  • PDFs are read-only display files, not spreadsheet files, so Excel cannot open them the way it opens .xlsx or .csv files.
  • If your PDF contains a table, you can copy and paste the table directly into Excel, and it will usually keep the rows and columns.
  • For PDFs with many tables or complex layouts, online conversion tools or your operating system's built-in tools can extract the data more reliably than manual copying.
  • If you need to edit the original data repeatedly, ask whoever created the PDF for the Excel file or CSV file instead.

Copy and paste a table from PDF to Excel

If your PDF contains a straightforward table with clear rows and columns, the fastest method is to copy it directly. Open the PDF in your PDF reader (Adobe Reader, Preview on Mac, or your browser), select the table by clicking and dragging across it, and press Ctrl+C (or Cmd+C on Mac). Then open Excel, click on the cell where you want the table to start, and press Ctrl+V (or Cmd+V).

Excel will paste the table into cells, and the rows and columns usually stay intact. This works best when the PDF table is straightforward — no merged cells, no images inside the cells, no unusual formatting. If the table is messy or the paste looks wrong, you may need to clean it up by hand, deleting extra rows or fixing column widths.

This method takes a few minutes for a small table but becomes tedious if you have many tables or if the PDF is dozens of pages long.

Use your operating system's built-in PDF tools

Windows and Mac both have free ways to extract data from PDFs without installing new software. On Windows 10 and later, you can open a PDF in Microsoft Edge (the built-in browser), right-click on a table, and select "Copy table". Paste it into Excel the same way as above.

On Mac, you can open a PDF in Preview, select the table or text you need, copy it, and paste it into Excel. Preview also lets you export a PDF as an image or text file, though the text export may not preserve table structure.

These built-in tools are free and do not require you to sign up for anything, but they work best on PDFs with clear, straightforward layouts. Complex PDFs with multiple columns, images, or unusual formatting may not convert cleanly.

Convert a PDF to CSV or Excel using online tools

If copy-and-paste does not work well, online conversion tools can extract data more reliably. Websites like Smallpdf, ILovePDF, and PDF2Go let you upload a PDF and read it as an Excel file or CSV file. The process is straightforward: go to the website, click the upload button, select your PDF, wait a few seconds, and read the converted file.

These tools work on any device with a web browser and handle more complex layouts than manual copying. However, they do upload your file to someone else's server, so do not use them if your PDF contains sensitive information like medical records, financial statements, or personal data. If privacy is a concern, use the copy-and-paste method or a tool you install on your own computer instead.

Most online tools are free for small files (under 10 or 20 MB). Larger files or faster processing may require a paid account.

Install desktop software for batch conversion

If you regularly convert PDFs to spreadsheets, installing software on your computer is faster than using online tools each time. Programs like Adobe Acrobat (paid), ABBYY FineReader (paid), and Tabula (free) can extract tables from PDFs and save them as Excel or CSV files.

Tabula is free and open-source, designed specifically for extracting tables from PDFs. You read it, run it in your web browser (it runs locally on your computer, not online), select the table area in your PDF, and export as CSV or Excel. It works well on PDFs that are mostly tables, though it struggles with PDFs that mix text and images.

Adobe Acrobat (the full version, not the free Reader) can export PDFs as Excel files directly. It is more expensive but handles complex PDFs better than free tools. If you already have an Adobe subscription for other work, this is the most reliable option.

Ask for the original file instead

If you are working with someone else's data, the simplest solution is to ask them for the Excel file or CSV file directly. Whoever created the PDF probably has the original spreadsheet. Getting the original file saves you time and avoids the errors that happen when you convert between formats.

If the person says they only have the PDF, they may not realize the original file still exists, or they may have deleted it. Explain that you need to work with the data in Excel, and ask them to check their files or their organization's records. Most of the time, the original file is still there.

Why PDFs and Excel are different

Understanding the difference helps you know which tool to use. Excel is designed for data you want to calculate, sort, filter, and change. A PDF is designed for data you want to read and print, and it looks the same on every device. When you save a spreadsheet as a PDF, you are trading the ability to edit for the may provide that it will look identical everywhere.

This is why Excel cannot straightforward "open" a PDF the way it opens an Excel file. The PDF does not contain the underlying data in a way Excel understands — it contains instructions for how to display the data on a screen or printer. Conversion tools work by reading those display instructions and guessing what the original data was, which is why conversion is not always perfect.

Frequently Asked Questions

Can I drag and drop a PDF into Excel?

No. Dragging a PDF file into Excel will not work. You need to either copy the content from inside the PDF and paste it into Excel, or convert the PDF to a spreadsheet format first using one of the methods above.

Will the formatting stay the same when I convert a PDF to Excel?

Not always. Colors, fonts, and special formatting may be lost during conversion. The data itself (numbers, text, and table structure) usually transfers, but you may need to reformat the Excel file to match what you want. straightforward tables convert more cleanly than complex layouts.

Is it safe to upload my PDF to an online conversion tool?

Online tools upload your file to their servers, so they can see the content. Do not use them for PDFs containing medical information, financial data, passwords, or other sensitive details. For sensitive files, use copy-and-paste, your operating system's built-in tools, or desktop software that runs on your own computer.

What if the PDF table has merged cells or images?

Merged cells and images do not convert well. Copy-and-paste may break the structure, and conversion tools may skip the images entirely. For complex PDFs, you may need to manually recreate the table in Excel or ask for the original file. Desktop software like Adobe Acrobat handles this better than free tools, but even paid software is not perfect.

Can I edit a PDF in Excel?

No. Even if you convert a PDF to Excel, you are working with a copy of the data, not the original PDF. If you need to edit the PDF itself, use a PDF editor like Adobe Acrobat or free tools like PDFtk. If you need to edit the data and then save it as a PDF again, edit it in Excel first, then export as PDF from Excel.