How to convert a PDF to Excel

How to convert a PDF to Excel
(Image credit: Shutterstock)

PDFs are notoriously difficult to edit, so if you’re ever handed tables or lists in this format, it will be worth knowing how to convert a PDF to Excel. That’s exactly what this guide will show you how to do, and without the need to buy or install any additional software.

As with just about any file conversion process, the results won’t always perfectly replicate the formatting of the original document — but with a fully editable Excel file, it will be much easier to make any necessary amendments.

As in our guide on how to convert a PDF to Word, we’ll turn to ILovePDF to handle conversion duties. This web-based tool is free to use and produces relatively good results.

Manually converting a PDF to Excel is necessary because you can’t simply force Windows to open PDFs to open in the Excel app. Well, you can, but the resulting spreadsheet will be unrecognizable from the original document, with random-looking code all over the place. At least forcibly opening a PDF with Word produces something that vaguely resembles the original.

How to convert a PDF to Excel

1. Navigate to ILovePDF in your browser and click the “PDF to Excel” section.

How to convert a PDF to Excel step 1: Go to www.ilovepdf.com and select PDF to Excel

(Image credit: Future)

2. Click “Select PDF file” and select the PDF you want to convert, or drag and drop the file onto this page.

How to convert a PDF to Excel step 2: Upload the PDF file you want to convert

(Image credit: Future)

3. Leave the “No OCR” option selected (it should be by default) and click “Convert to Excel.”

How to convert a PDF to Excel step 3: Click Convert to Excel

(Image credit: Future)

4. After a few seconds, the conversion process should be complete. Click “Download Excel” to download your converted file.

How to convert a PDF to Excel step 4: Click Download Excel to download the converted Excel file

(Image credit: Future)

Now that you have the converted Excel file, you can open it and start editing; you may need to click “Enable Editing” when prompted, but only the first time you open the file. 

Be sure to check for any formatting irregularities, because while ILovePDF does a great job of converting text and data without mistakes, things like text wrapping and table borders might need to be tweaked to your liking.

For more easy help around using Microsoft Office software, you can read our guides on how to save a Word document as a PDF and how to sign a Word document.

James Archer

James is currently Hardware Editor at Rock Paper Shotgun, but before that was Audio Editor at Tom’s Guide, where he covered headphones, speakers, soundbars and anything else that intentionally makes noise. A PC enthusiast, he also wrote computing and gaming news for TG, usually relating to how hard it is to find graphics card stock.

  • w8JVNSw
    Importing from a pdf into Excel has been natively supported in Excel 365 for about a year now. p2304BjvrB8View: https://www.youtube.com/watch?v=p2304BjvrB8 is a good overview and the announcement from Microsoft can be read at https://techcommunity.microsoft.com/t5/excel-blog/announcing-data-import-from-pdf-documents/ba-p/1569202.
    Reply