Import a PDF into Excel in three steps
- Upload the PDF in the box above and click Extract Tables.
- Click Export to Excel. An .xlsx file downloads to your computer.
- Open the file in Excel. Each table is on its own sheet.
Ordinary tables convert at no cost and with no account. Uploaded files are deleted automatically after 24 hours.
Which way to choose
| Way | Works for | Limits |
|---|---|---|
| Upload here, open the .xlsx | Any Excel version, scanned PDFs, several tables | Files up to 8MB |
| Excel: Get Data from PDF | PDFs created on a computer | Microsoft 365 on Windows only, no scans |
| Copy and paste | A few rows in a simple PDF | Columns often break, no scans |
Import with Excel itself
In Excel for Microsoft 365 on Windows, go to Data > Get Data > From File > From PDF, pick the file, select a table in the list and click Load. It does not read scans, and it is not available in Excel for Mac or older versions.
Copy a table from PDF to Excel
Copying by hand works when the table is short and you can select the text in the PDF.
- Select the table rows in the PDF and press Ctrl+C (Cmd+C on a Mac).
- Click a cell in Excel and press Ctrl+V. Usually each row lands in one cell.
- Keep the cells selected, go to Data > Text to Columns, choose Delimited and tick Space.
A value with a space inside, like a name or the date Oct 3, gets split into two columns, and you fix those rows by hand. The full walkthrough is in how to copy a table from PDF to Excel.
Other formats
Using Google Sheets? See convert PDF to Google Sheets. For imports into apps and databases, use PDF to CSV.
Questions and answers
How do I import a PDF into Excel?+
Upload the PDF on this page, click Extract Tables and then Export to Excel. Open the downloaded .xlsx file in Excel. In Excel for Microsoft 365 on Windows you can also use Data > Get Data > From File > From PDF.
Why is there no From PDF option in my Excel?+
It is available in Excel for Microsoft 365 on Windows. Excel for Mac and older Excel versions do not have it. An .xlsx file from this page opens in any version.
Why does a copied PDF table land in one column?+
A PDF stores text at positions on the page, not in cells, so Excel gets each row as one line. Text to Columns can split it, but values with spaces break apart. Extracting the table avoids that.
Can I import a scanned PDF into Excel?+
Yes, on this page. When the PDF is a scan, the converter runs text recognition (OCR) first. Excel's own PDF import does not read scans.
Does the whole PDF get imported?+
No. Only tables are exported. Headings and paragraphs around them are left out. Each table gets its own sheet.
How long do you keep my PDF?+
Uploaded files and results are deleted automatically after 24 hours.