The fastest way depends on what's in your PDF

If your PDF contains a table or structured data, you have three main routes: use built-in Excel import tools, convert the PDF first with free software, or copy the data manually. Which one works best depends on how the PDF is formatted and how much data you're moving.

A PDF that's actually a scanned image of a document won't work with any of these methods — you'll need optical character recognition (OCR) software first, which can be slow and error-prone. But if the PDF contains selectable text (you can click and highlight it), you can get the data into Excel in minutes.

Key Takeaways

  • Excel can import PDF tables directly on Windows using Data > From PDF, or on Mac using File > Open, but this only works if the PDF contains an actual table, not a scanned image.
  • If the PDF is a scanned image, you'll need free OCR software like Tesseract or an online converter before Excel can read it.
  • Copying and pasting from PDF to Excel works for small amounts of data but often scrambles formatting and column alignment.
  • Free conversion tools like Smallpdf or ILovePDF can turn a PDF into an Excel file in seconds, though the results may need cleanup.
  • The data you end up with in Excel will usually need formatting fixes — column widths, number formats, and merged cells rarely transfer perfectly.

Using Excel's built-in PDF import on Windows

On Windows, Excel 365 and Excel 2019 or later can import PDF tables directly. Open Excel, go to the Data tab at the top, and click From PDF. Select your PDF file, and Excel will show you a preview of any tables it finds. Click the table you want, then click Load to bring it into your spreadsheet.

This method works cleanly when the PDF contains a proper table with clear rows and columns. If the PDF is a scanned image or has text scattered across the page without table structure, Excel won't find anything to import. You'll get an error or an empty preview window.

After the data lands in Excel, check the formatting. Numbers might come in as text, dates might be unrecognized, and column widths may be too narrow. These are quick fixes — select the column, right-click, and choose Format Cells to set the correct data type.

Opening a PDF directly in Excel on Mac

On Mac, Excel doesn't have a dedicated PDF import button. Instead, go to File > Open, navigate to your PDF, and select it. Excel will attempt to convert the PDF and open it as a spreadsheet. This works for PDFs with clear table structure but often produces messy results with extra blank rows or misaligned columns.

If the direct open doesn't work or produces unusable output, you'll need to use one of the conversion methods below instead. Mac users often find that copying and pasting from a PDF viewer (like Preview) into Excel gives more control than the automatic import.

Copy and paste from PDF to Excel

For small tables or specific sections, you can open the PDF in any PDF reader (Adobe Reader, Preview on Mac, or your browser), select the data you need, copy it, and paste it into Excel. This works quickly for a few rows or columns.

The catch: formatting usually breaks. Text that was in separate columns in the PDF often lands in a single Excel column. Numbers might paste as text. Merged cells in the original PDF become a mess. You'll spend time cleaning up the result, which defeats the purpose if you have a large table.

To improve results, paste into a single column first, then use Excel's Text to Columns feature to split the data. Go to the Data tab, click Text to Columns, and tell Excel what character separates your data (usually a space or comma). This often recovers the original structure.

Converting a PDF to Excel with free online tools

Websites like Smallpdf, ILovePDF, and CloudConvert let you upload a PDF and download it as an Excel file. Upload your PDF, wait a few seconds, and download the result. Most of these tools are free for a few conversions per day.

The quality varies. Simple tables usually convert cleanly. PDFs with complex formatting, multiple tables, or unusual layouts often produce Excel files with scrambled columns or extra blank rows. You'll need to open the result and check it before using the data.

Be aware that uploading to an online tool means your PDF goes to someone else's server. If the PDF contains sensitive information, use a desktop tool instead. Free desktop converters like Zamzar (which you can download and run locally) or Calibre (designed for ebooks but handles PDFs) give you more privacy.

Handling scanned PDFs with OCR software

If your PDF is a scanned image — you can see it's a photo of a document, not selectable text — you need OCR (optical character recognition) software first. OCR reads the image and converts it to text that Excel can use.

Free options include Tesseract (command-line tool, steeper learning curve) and online OCR sites like Free-OCR.com or Onlineocr.net. Upload your scanned PDF, let the software read it, and download the result as a text or PDF file. Then use one of the methods above to get it into Excel.

OCR is never perfect. Handwriting, poor image quality, or unusual fonts cause errors. Always check the converted text against the original before relying on it. For a document with a few pages, manual entry might be faster than fixing OCR mistakes.

Cleaning up your data after import

No matter which method you use, your Excel file will need work. Numbers might be formatted as text (they'll be left-aligned instead of right-aligned). Dates might not be recognized. Column widths might be too narrow to read. Blank rows might appear between data rows.

Start by selecting all your data and using Format > AutoFit Column Width to make everything readable. Then select each column that should contain numbers or dates, right-click, choose Format Cells, and set the correct format. Use Find & Replace (Ctrl+H on Windows, Cmd+H on Mac) to remove extra spaces or line breaks that often come from PDF conversion.

If blank rows are scattered through your data, select your entire data range, go to Data > Sort, and sort by any column. This pushes all blank rows to the bottom, where you can delete them in one go.

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 needs manual combining. Online converters and Excel's import tool handle this differently — test with your specific PDF first. If the result is messy, you may need to convert each table separately and paste them together in Excel yourself.

What if the PDF has columns but they're not aligned properly?

This is common with PDFs created from scanned documents or poorly formatted originals. After importing, use Excel's Text to Columns feature to split the data by spaces or delimiters. If that doesn't work, you may need to manually reorganize the columns or use a more advanced PDF converter.

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

Most reputable converters delete files after a few hours, but your PDF does travel to their server. If the file contains confidential information, use a desktop tool instead, or check the converter's privacy policy. For non-sensitive documents, online tools are usually fine and require no software installation.

Why does my data paste as one column instead of multiple columns?

The PDF probably doesn't have clear column separators that Excel recognizes. After pasting, select the column, go to Data > Text to Columns, and choose the delimiter (space, comma, or tab) that separates your data. Excel will split it into the correct columns.

Can I automate this if I do it regularly?

If you convert the same PDF repeatedly, save it as a template after the first conversion. For different PDFs, you can use Excel macros or Python scripts with libraries like pdfplumber or tabula-py, but these require some coding knowledge. For occasional conversions, the manual methods above are usually faster.