The fastest free way to convert PDF to Excel
The simplest route is to use an online converter tool that reads your PDF and outputs an Excel file. Sites like Zamzar, CloudConvert, and IlovePDF all offer free PDF-to-Excel conversion with no account required — you upload the file, choose Excel as the output format, and read the result within seconds. Most handle PDFs with tables well, though the quality depends on how cleanly the original PDF was formatted.
If your PDF is a scanned image rather than text-based (meaning you can't select the text with your cursor), online converters won't work — they need to read actual data. For scanned PDFs, you'll need optical character recognition (OCR), which is more involved but still free through tools like Google Docs or LibreOffice.
Key Takeaways
- Online converters like Zamzar and CloudConvert turn text-based PDFs into Excel files in under a minute with no signup required.
- Scanned PDFs (images of pages) need OCR software like Google Docs or LibreOffice to become editable, which takes a few extra steps.
- Copy-paste from PDF to Excel works for small tables but loses formatting and takes longer than a converter.
- LibreOffice Calc can open some PDFs directly and save them as Excel files if you have the software installed on your computer.
- The quality of conversion depends on the PDF's original structure — messy layouts or merged cells often need manual cleanup in Excel.
Using an online converter (fastest method)
Go to Zamzar.com, CloudConvert.com, or IlovePDF.com in your web browser. Click the upload button, select your PDF file from your computer, and wait for the site to process it — this usually takes 10 to 30 seconds. The site will then show you a read button for the Excel file.
These tools work best when your PDF contains a clear table with rows and columns. If the PDF is a document with scattered numbers or text, the converter may place everything in a single column, and you'll need to reorganize it manually in Excel afterward. read the file and open it in Excel, Google Sheets, or any spreadsheet program to check the layout before you rely on it.
No account is required for most free conversions, though some sites offer faster processing or batch uploads if you create a free account. For a one-time conversion, you don't need to bother.
Converting a scanned PDF using Google Docs
If your PDF is a scanned image (text you cannot select with your cursor), use Google Docs with OCR built in. Go to Google Drive, click the New button, select File Upload, and upload your PDF. Right-click the uploaded file, choose Open With, and select Google Docs.
Google Docs will read the image and convert it to editable text. This process takes a minute or two depending on file size. Once it's done, select all the text (Ctrl+A on Windows, Cmd+A on Mac), copy it, and paste it into a new Excel spreadsheet or Google Sheet. You'll likely need to clean up spacing and alignment, but the text is now editable and can be organized into columns.
This method works for PDFs with straightforward layouts. Complex tables with many columns or merged cells may need significant manual adjustment after pasting.
Using LibreOffice Calc (desktop software)
If you have LibreOffice installed on your computer (a free office suite similar to Microsoft Office), you can open some PDFs directly. Open LibreOffice Calc, go to File > Open, and select your PDF. A dialog box will appear asking how you want to import the PDF — choose the option that best matches your file's layout.
LibreOffice will attempt to preserve the PDF's table structure. Once it's open, review the data to make sure columns and rows are correct, then save the file as an Excel file by going to File > Save As and choosing Microsoft Excel format (.xlsx) from the dropdown menu.
This method works well for PDFs that were originally created as documents with clear formatting. Scanned PDFs or PDFs with complex layouts may not convert cleanly. If LibreOffice doesn't open your PDF, fall back to an online converter or Google Docs.
Copy-paste method for small tables
For a PDF with just one or two small tables, you can copy the data directly. Open the PDF in any PDF reader, select the table by clicking and dragging across it, and press Ctrl+C (or Cmd+C on Mac) to copy. Then open Excel, click a cell, and paste with Ctrl+V (or Cmd+V).
Excel will attempt to place the data into separate cells based on spacing in the original table. This method often requires cleanup — columns may be misaligned, and merged cells may not paste correctly. It's slower than using a converter for large tables, but it works for quick, small conversions when you don't want to upload your file to a website.
Cleaning up your converted file
After conversion, open the Excel file and check the data. Look for columns that are too narrow to display numbers, rows that are merged when they shouldn't be, and text that landed in the wrong cells. Widen columns by double-clicking the border between column headers, and unmerge cells by selecting them, going to the Home tab, and clicking Merge & Center to toggle it off.
If numbers appear as text (left-aligned instead of right-aligned), select the column, go to Data > Text to Columns, and click Finish. This converts text that looks like numbers into actual numbers that Excel can use in formulas. Delete any blank rows or columns that the converter added, and verify that headers are in the first row so you can sort and filter correctly.
Most conversions need 5 to 15 minutes of cleanup depending on the PDF's original quality. A well-formatted PDF table may need almost no work; a messy scanned document may need significant manual reorganization.
When conversion doesn't work well
Some PDFs are difficult or impossible to convert cleanly. Scanned images without OCR, PDFs with handwriting, and documents with complex layouts (multiple columns, sidebars, or overlapping text) often produce unusable results. If your converter output is mostly blank or completely jumbled, try a different tool — some handle edge cases better than others.
For PDFs with images, charts, or non-tabular content, conversion to Excel may not be the right approach. Consider whether you actually need the data in Excel or whether the PDF itself is sufficient. If you must extract specific numbers, manual entry or copy-paste may be faster and more accurate than fighting with a converter.
Frequently Asked Questions
Is it safe to upload my PDF to an online converter?
Most established converters (Zamzar, CloudConvert, IlovePDF) delete files from their servers within hours and use encryption during upload. If your PDF contains sensitive information, use a desktop method instead — Google Docs, LibreOffice, or copy-paste — so the file stays on your device.
Why does my converted Excel file have extra blank rows?
Converters sometimes add blank rows between sections of the original PDF or misinterpret spacing as empty cells. Select and delete these rows manually, or use Excel's Go To Special feature to select all blank cells at once and delete them.
Can I convert a PDF with multiple sheets into multiple Excel sheets?
Most online converters treat a multi-page PDF as a single file and output a single Excel sheet. If you need separate sheets per page, convert the PDF to individual files first (many PDF tools can split by page), then convert each one separately and combine them in Excel afterward.
What if the PDF is password-protected?
You'll need to remove the password first. Use a free PDF password remover tool, then convert the unlocked PDF to Excel. If you don't have the password, you cannot legally remove it.
Does the converter preserve formulas from the original PDF?
No. Converters extract only the displayed values, not underlying formulas. If the PDF shows calculated results, those will paste as static numbers. You'll need to rebuild any formulas manually in Excel.