The simplest way depends on what's in your PDF

If your PDF contains a table or structured data, you have three realistic paths: use free online conversion tools, use Excel's built-in import feature, or manually copy the data. Which one works best depends on how messy the PDF is and whether you need the conversion to happen only once or regularly.

The fastest route for a clean table is often an online converter like Smallpdf or ILovePDF — you upload the PDF, read the Excel file, and you're done in under a minute. If your PDF is a scanned image rather than text, none of these methods will work well; you'd need optical character recognition (OCR) software, which is a different problem. If the PDF has multiple tables or complex formatting, you may spend less time manually copying the data into Excel than you would fixing a botched conversion.

Key Takeaways

  • Online converters like Smallpdf, ILovePDF, and Zamzar work fastest for single-use conversions and require no software installation.
  • Excel's built-in "Get & Transform" feature (Windows) or "Queries" (Mac) lets you import PDF data directly into a spreadsheet without leaving the program.
  • Scanned PDFs (images of documents) cannot be converted to Excel without OCR software, which adds an extra step and often produces errors.
  • Manual copying works best for small tables or when the conversion tool produces results you have to fix anyway.
  • Check the converted file carefully before deleting the original PDF, because formatting, merged cells, and special characters often break during conversion.

Using a free online converter

Online converters are the no-setup option. You visit the website, upload your PDF, and read an Excel file. The most reliable free ones are Smallpdf, ILovePDF, and Zamzar. All three handle PDFs with tables reasonably well and don't require you to create an account (though accounts let you convert multiple files in a row without waiting).

The process is the same across all three: go to the converter's website, click the upload button, select your PDF file, wait for the conversion to finish (usually 10 to 30 seconds), and read the .xlsx file. Open it in Excel to check the results. If columns are misaligned, numbers became text, or merged cells didn't convert, you'll need to fix those by hand.

The main limitation is that these tools work best on PDFs that are already text-based (created from a document, not scanned). If your PDF is a photograph or scan of a printed page, the converter will see it as an image and won't be able to extract the data. You'd need OCR software first, which adds complexity.

Importing directly into Excel (Windows and Mac)

If you have Excel installed, you can import a PDF without using a separate tool. On Windows, this feature is called Get & Transform. On Mac, it's called Queries. Both let you pull data from a PDF directly into a spreadsheet.

On Windows: Open Excel, go to the Data tab, click Get Data (or New Query in older versions), select From File, then From PDF. Navigate to your PDF file and open it. Excel will show you a preview of the tables it found. Select the table you want, click Load, and the data appears in your spreadsheet. You can then clean up formatting or fix any columns that didn't import correctly.

On Mac: Open Excel, go to the Data tab, click New Query, select From File, then From PDF. The process is nearly identical — select the table, click Load, and the data imports into your sheet.

This method is useful if you convert PDFs regularly, because you can save the query and re-run it if the PDF updates. It's also more reliable than online converters for PDFs with consistent formatting. The downside is that it only works if you own Excel; the free online tools work in any browser on any device.

Copying data manually when conversion fails

If the PDF table is small (under 20 rows) or the conversion produces a mess you'd have to fix anyway, copying by hand is often faster. Open the PDF in your PDF reader, select the table data, copy it, and paste it into Excel. Excel will usually place each row in a separate cell, so you'll need to use the Text to Columns feature to split it properly.

To use Text to Columns: Select the column of pasted data, go to the Data tab, click Text to Columns, choose Delimited, select the delimiter (usually space or tab, depending on how the data was separated in the PDF), and click Finish. Excel will split the data into separate columns.

This method gives you the most control over how the data is organized, but it's only practical for small amounts of data. For a 100-row table, you'd spend an hour fixing what a converter could do in seconds.

What to do if your PDF is a scanned image

Scanned PDFs are photographs or images of printed documents. Converters and Excel's import feature can't read them because they see only pixels, not text. To convert a scanned PDF to Excel, you need optical character recognition (OCR) software first.

Free OCR tools include Google Docs (upload the PDF, and Google will convert it to text), Adobe Acrobat Reader (limited OCR in the free version), and open-source tools like Tesseract. The process is: run the scanned PDF through OCR to create a text-based PDF, then use a converter or Excel's import feature on the result. The OCR step usually introduces errors — especially with handwriting, unusual fonts, or poor image quality — so you'll need to proofread the final Excel file.

If you have many scanned PDFs to convert, paid OCR software like Adobe Acrobat Pro or ABBYY FineReader produces better results than free tools, but it's only worth the cost if this is a regular task.

Checking your converted file before you delete the original

After conversion, open the Excel file and compare it to the original PDF. Look for: columns that shifted or merged, numbers that became text (they'll be left-aligned instead of right-aligned), dates that broke into separate columns, and special characters that disappeared or turned into symbols.

If the conversion is close enough, fix the problems in Excel and save. If it's a disaster, delete the Excel file and try a different method — either a different converter, Excel's import feature, or manual copying. Keep the original PDF until you've verified the Excel version is usable, because you may need to go back to it.

Frequently Asked Questions

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

Yes, but each table usually ends up on a separate sheet or in separate sections of the same sheet, depending on the converter. You'll need to reorganize them by hand if you want them in a specific layout. Online converters handle this better than manual copying, but you should still check the result.

Why did my numbers turn into text after conversion?

Excel sometimes interprets numbers as text if they have leading zeros, special formatting, or unusual characters. Right-click the column, select Format Cells, choose Number, and click OK. If that doesn't work, you may need to delete and re-enter the data, or use a formula to convert the text to numbers.

What if the PDF has a password?

Most converters and Excel's import feature will ask you to enter the password before processing the file. If the PDF is restricted from copying (a different kind of protection), you may not be able to extract the data at all — you'd need to contact whoever created the PDF and ask for an unrestricted version.

Is it safe to use online PDF converters?

Reputable converters like Smallpdf, ILovePDF, and Zamzar delete your files from their servers after a few hours. If your PDF contains sensitive information, check the converter's privacy policy first, or use Excel's built-in import feature instead, which keeps everything on your computer.

Can I convert a PDF to Excel on my phone?

Online converters work on phones through a web browser, but the process is slower and harder to manage on a small screen. If you need to do this regularly, a desktop computer or laptop is more practical. Some phone apps claim to convert PDFs, but most are unreliable or require payment.