The fastest free way to convert a PDF to Excel

The simplest free route is to use Google Sheets. Open Google Drive, click "New," select "File upload," and upload your PDF. Google Sheets will attempt to convert it automatically and open it as a spreadsheet. If the PDF is a simple table with clear rows and columns, this works well. If the PDF is scanned text or has complex formatting, the conversion will be messier — you may need to clean it up by hand.

If Google Sheets does not work well for your file, try LibreOffice Calc, which is free desktop software. Download it, open it, go to File > Open, select your PDF, and LibreOffice will import it as a spreadsheet. This method often handles PDFs with multiple tables or unusual layouts better than Google Sheets, though the results still depend on how the PDF was created.

Both methods work because they are reading the PDF's underlying data structure. If your PDF is a photograph or a scanned image of a document, neither method will work — you would need optical character recognition (OCR) software, which is a different process.

Key Takeaways

  • Google Sheets and LibreOffice Calc are both free and can convert PDFs to Excel-compatible spreadsheets without downloading additional software or paying for a service.
  • Google Sheets works best for simple, clean PDFs with clear table structure; LibreOffice Calc often handles complex layouts better.
  • If your PDF is a scanned image or photograph rather than text-based data, standard conversion tools will not work — you would need OCR software instead.
  • After conversion, you will likely need to spend time cleaning up formatting, fixing merged cells, and checking that numbers converted correctly.
  • You can save the converted file as an Excel file (.xlsx) from either Google Sheets or LibreOffice Calc for use in Microsoft Excel or other spreadsheet programs.

Using Google Sheets for a quick conversion

Go to drive.google.com, sign in with your Google account (or create one free), and click the "New" button on the left. Select "File upload" and choose your PDF from your computer. Google Drive will upload it, then ask what you want to do with it. Select "Open with Google Sheets."

Google Sheets will read the PDF and create a new spreadsheet. If your PDF contains a single clean table, the data will land in the right cells with minimal fuss. If the PDF has multiple tables, headers, or unusual spacing, Google Sheets may put everything in column A or split data across columns in ways you did not expect.

Once the conversion is done, you can download the file as an Excel file. Click "File," then "Download," then "Microsoft Excel (.xlsx)." This creates a file you can open in Excel, LibreOffice Calc, or any other spreadsheet program. The file stays in your Google Drive as well, so you can edit it there or download it again later.

Using LibreOffice Calc for more control

Download LibreOffice free from libreoffice.org. The installer is about 300 MB and takes a few minutes. Once installed, open LibreOffice Calc (the spreadsheet part of the suite).

Go to File > Open and navigate to your PDF file. LibreOffice will show you an import dialog with options. You can choose which pages to import, set the range of cells, and preview how the data will land. This gives you more control than Google Sheets, especially if your PDF has multiple pages or tables you want to import separately.

After import, save the file as an Excel file by going to File > Save As, choosing "Microsoft Excel 2007-365 (.xlsx)" from the format dropdown, and clicking Save. LibreOffice will convert it to a format Excel can read.

Why the conversion is rarely perfect

PDFs store data differently than spreadsheets do. A PDF might show a table that looks organized to human eyes, but the underlying code may not have clear row and column markers. When a conversion tool reads the PDF, it has to guess where the rows and columns are based on spacing and alignment. If the PDF was created from a spreadsheet, this usually works. If the PDF was created from a word processor or designed by hand, it often does not.

Common problems after conversion include: numbers that became text (so they will not add up), merged cells that split into separate cells, currency symbols or percentages that disappeared, and text that wrapped across multiple cells instead of staying in one. You will almost always need to spend time fixing these by hand.

Before you start a large conversion project, test the process on a small sample of your PDF. Convert one page or one table, check the results, and decide whether the cleanup work is worth it or whether a different approach makes more sense.

When to use an online converter instead

Several websites offer free PDF-to-Excel conversion without downloading software. Sites like Zamzar, CloudConvert, and Smallpdf let you upload a PDF and download the converted file. These work similarly to Google Sheets — they read the PDF and create a spreadsheet — but they run on someone else's server.

The trade-off is privacy. When you upload a file to an online converter, that file goes to a company's server. Most reputable converters delete files after a few hours, but you are trusting their privacy policy. If your PDF contains sensitive information, using Google Sheets (which is encrypted and tied to your account) or LibreOffice Calc (which runs entirely on your computer) is safer.

Online converters can be faster if you only need to convert one or two files and do not want to download software. If you convert PDFs regularly, downloading LibreOffice once saves time in the long run.

Handling scanned PDFs and images

If your PDF is a photograph or a scanned image of a document, none of the methods above will work. The conversion tools are looking for text data inside the PDF file. A scanned image has no text data — it is just pixels. You would need OCR (optical character recognition) software to read the text from the image first.

Free OCR tools include Tesseract (command-line software, steeper learning curve) and Google Lens (built into Google Photos and Google's mobile apps, easier to use). After OCR converts the image to text, you can then convert that text to a spreadsheet. This is a two-step process and usually requires more cleanup than converting a text-based PDF.

Saving and organizing your converted file

After conversion, save your file with a clear name that includes the date or version number, like "Sales_Data_2024_Jan.xlsx". This helps you track which version is current if you convert the same PDF multiple times.

If you used Google Sheets, the file is automatically saved in your Google Drive. You can share it with others, edit it collaboratively, or download it as needed. If you used LibreOffice Calc, the file is saved on your computer. Consider backing it up to cloud storage (Google Drive, OneDrive, Dropbox) so you do not lose it if your computer fails.

Keep the original PDF as well, in case you need to re-convert it or check the original formatting later. Conversion is not always reversible — once you have cleaned up and changed the spreadsheet, you cannot easily turn it back into a PDF that looks identical to the original.

Frequently Asked Questions

Can I convert a PDF with multiple tables on one page?

Yes, but the conversion tool may not separate them correctly. Google Sheets and LibreOffice Calc will try to read all the data, but if the tables are side by side or overlapping, they may end up jumbled. LibreOffice's import dialog lets you preview the result before confirming, so you can see whether it worked before you commit to the conversion.

What if the numbers in my Excel file show as text after conversion?

This happens when the PDF stored numbers as text rather than numeric values. In Excel, select the column, go to Data > Text to Columns, click Next twice, and click Finish. This converts the text to actual numbers. In LibreOffice Calc, the process is similar: select the column, go to Data > Text to Columns, and follow the wizard.

Can I convert a password-protected PDF?

If the PDF is password-protected to prevent opening, you cannot convert it without the password. If it is protected only against editing or printing, most conversion tools can still read the data and convert it. Try uploading it to Google Sheets or LibreOffice — if the tool can open it, it can usually convert it.

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

Reputable converters like Smallpdf and CloudConvert use encryption and delete files after a set time. However, if your PDF contains confidential information, using software on your own computer (LibreOffice Calc) or a service tied to your personal account (Google Sheets) is safer because the file never leaves your control.

How do I convert a PDF to Excel on a Mac?

The process is the same. Google Sheets works on any computer with a web browser. LibreOffice Calc runs on Mac, Windows, and Linux — download it from libreoffice.org and follow the same steps. Online converters also work on Mac without any difference.