The simplest way to convert a PDF to Excel

If your PDF contains a table or structured data, the fastest free route is to copy the table directly into Excel. Open the PDF in your web browser or PDF reader, select the table with your mouse, copy it, then paste it into a blank Excel spreadsheet. This works best when the PDF table has clear rows and columns — messy layouts or scanned images will not paste cleanly.

When direct copying does not work, use a free online converter like Smallpdf, ILovePDF, or CloudConvert. Upload your PDF file, select the Excel format, convert, and read the result. These tools handle most PDFs in seconds and require no account. The trade-off is that you are uploading your file to someone else's server, so avoid this method if the PDF contains sensitive information like tax returns or medical records.

For PDFs that are scanned images of documents rather than digital text, neither method will work well — the converter cannot read text from a picture. In that case, you will need to type the data manually or use optical character recognition (OCR) software, which is a separate process covered below.

Key Takeaways

  • Copying and pasting a table directly from PDF to Excel is the fastest method when the PDF contains a clearly formatted table.
  • Free online converters like Smallpdf and ILovePDF work for most digital PDFs but require uploading your file to their servers.
  • Scanned image PDFs cannot be converted automatically and require either manual data entry or OCR software to extract text.
  • Desktop software like LibreOffice Calc can open some PDFs directly, though the formatting may need cleanup afterward.
  • Check the converted file carefully — automated conversion often misaligns columns or drops data from complex layouts.

Using an online converter for most PDFs

Open your web browser and go to Smallpdf.com, ILovePDF.com, or CloudConvert.com. Each site works the same way: click the upload button, select your PDF file from your computer, and wait for the conversion to finish. The site will then offer a read button for your Excel file. No account is required, and no payment is asked.

The converted file downloads as an .xlsx file, which opens in Excel, Google Sheets, or any other spreadsheet program. Open it when ready and check the data — online converters handle straightforward tables well but often struggle with merged cells, multiple columns of headers, or text that wraps across lines. If columns are misaligned or data is missing, you may need to clean up the file by hand or try a different converter.

These services keep uploaded files for a limited time (usually 24 hours) before deleting them, but if your PDF contains confidential information, consider the desktop methods below instead. Also note that free versions of these sites sometimes limit file size — most allow PDFs up to 25 MB, which covers most documents.

Converting directly in LibreOffice Calc if you have it installed

If you already have LibreOffice Calc on your computer (a free alternative to Excel), you can open some PDFs directly without uploading them anywhere. Open LibreOffice Calc, go to File > Open, change the file type filter to "All files," and select your PDF. The program will ask how you want to import the PDF — choose "Spreadsheet" if that option appears.

This method keeps your file on your own computer and avoids uploading to a third-party server. However, LibreOffice's PDF import is less reliable than online converters, especially with complex layouts. The result often needs significant cleanup — columns may be too narrow, text may overflow, or tables may not align properly. Use this method only if you are comfortable editing the spreadsheet afterward or if the PDF is straightforward and well-structured.

If LibreOffice Calc is not installed on your computer, you can read it free from LibreOffice.org. The read and installation take about 10 minutes on most computers.

Handling scanned PDFs with OCR software

A scanned PDF is a photograph of a printed document, not a digital file with selectable text. If you try to copy text from a scanned PDF, nothing happens — the PDF reader sees only an image. Converting a scanned PDF to Excel requires optical character recognition (OCR), which is software that reads text from images.

Free OCR tools include Google Docs (upload the PDF, and Google Docs will extract the text), Tesseract (a command-line tool for advanced users), and some online OCR sites like Free-OCR.com. Google Docs is the easiest: upload your scanned PDF to Google Drive, right-click it, select "Open with > Google Docs," wait for the conversion, then copy the recognized text and paste it into Excel. The accuracy depends on how clear the original scan is — blurry or low-contrast scans will have errors.

After OCR extracts the text, you will still need to format it into columns and rows in Excel by hand. This is slower than converting a digital PDF, but it is the only way to extract data from a scanned document without retyping it.

Cleaning up the converted file in Excel

After conversion, open the Excel file and check every section. Look for columns that are too narrow (text may be hidden), rows that did not align properly, or data that landed in the wrong cells. Automated conversion often splits a single cell across multiple columns or merges separate columns into one.

To fix column width, double-click the line between two column headers at the top — Excel will auto-fit the column to its content. To move data to the correct column, select the cells, cut them (Ctrl+X on Windows, Cmd+X on Mac), click the correct cell, and paste (Ctrl+V or Cmd+V). If numbers were converted to text, select the column, go to Data > Text to Columns, and click Finish — Excel will convert them back to numbers.

Save the cleaned file with a new name so you keep the original converted file as a backup. If you need to convert the same PDF again later, you will have a record of what changes you made.

When to convert versus when to retype

Conversion works well for tables with consistent structure — invoices, price lists, data tables, or financial reports where every row follows the same format. For these documents, conversion saves time even if some cleanup is needed.

Conversion is not worth the effort for very small tables (fewer than 10 rows), documents with irregular layouts, or PDFs where the data is scattered across the page. In these cases, opening the PDF and Excel side by side and typing the data by hand is faster than troubleshooting a conversion. A 5-row table takes 2 minutes to type but 10 minutes to convert and fix.

If you convert the same type of document repeatedly (like monthly reports from a vendor), invest time in cleaning up the first one carefully. Save it as a template, and future conversions will be faster because you will know exactly what to fix.

Frequently Asked Questions

Can I convert a PDF with multiple tables into one Excel file?

Yes, but each table may land on a different sheet or in different areas of the same sheet depending on the converter. After conversion, you may need to move tables around or delete empty rows between them. Online converters usually handle this better than desktop software.

What if the PDF is password-protected?

Most online converters will ask for the password before converting. If you do not know the password, you cannot convert the file. Some older PDFs have weak password protection that can be removed with free tools, but this depends on how the PDF was locked.

Does converting a PDF to Excel change the original file?

No. Conversion creates a new Excel file and leaves the PDF unchanged. The original PDF stays on your computer or in your email exactly as it was.

Why does my converted Excel file look different from the PDF?

Converters extract data but do not always preserve formatting like colors, fonts, or borders. If the visual appearance matters, you may need to reformat the Excel file by hand or accept that it will look different from the original PDF.

Is it safe to upload my PDF to an online converter?

Most reputable converters (Smallpdf, ILovePDF, CloudConvert) delete files after 24 hours and use encryption during upload. However, if your PDF contains sensitive information like social security numbers or medical details, use a desktop method instead to keep the file on your own computer.