The fastest way depends on what PDF reader you're using

The simplest method is to open the PDF in your web browser, select the table with your mouse, copy it, and paste it directly into Excel. This works when the table is clean and the PDF was created from a digital document rather than scanned as an image. If that doesn't work, or if the table comes out misaligned, you have several other routes: using built-in PDF tools, converting the PDF first, or manually recreating the table in Excel if it's small enough.

The method that works best depends on whether your PDF is text-based (searchable, created from a document) or image-based (scanned from paper). Text-based PDFs usually copy cleanly. Image-based PDFs require a different approach because the text isn't selectable.

Key Takeaways

  • Copying directly from a web browser or Adobe Reader works for most text-based PDFs, though the table may need formatting fixes in Excel afterward.
  • If direct copying leaves gaps or misaligned columns, use a PDF-to-Excel converter tool or convert the PDF to a different format first.
  • Scanned PDFs (image-based) cannot be copied as text and require either optical character recognition software or manual entry into Excel.
  • Excel's built-in "From Web" feature can pull tables from PDFs saved as web pages, though this works only in certain versions and situations.

Copying directly from your PDF reader

Open the PDF in Adobe Reader, your web browser, or another PDF viewer. Click and drag to select the entire table, including headers and all rows. Right-click and choose Copy, or press Ctrl+C (Windows) or Command+C (Mac).

Switch to Excel and click on the cell where you want the table to start. Right-click and select Paste, or press Ctrl+V (Windows) or Command+V (Mac). The table will appear in your spreadsheet. Check the alignment — sometimes columns will be too narrow, or data that should be in separate cells will land in one cell. Adjust column widths and use Excel's "Text to Columns" feature if needed to split data that didn't separate correctly.

This method works best when the PDF is text-based and the table has clear borders or spacing. If the table is complex with merged cells or unusual formatting, the paste may not preserve the structure perfectly.

Using a PDF-to-Excel converter

If direct copying produces a messy result, a dedicated converter tool often does better. Free online converters include Smallpdf, ILovePDF, and PDF2Go. Upload your PDF file, select the table area if the tool allows it, and download the converted Excel file.

These tools use optical character recognition to read the PDF and rebuild it as an Excel spreadsheet. The quality varies depending on the PDF's original quality and table complexity. Some converters charge for batch processing or for handling large files, though most allow at least one or two free conversions per day.

The advantage is that converters often handle alignment and column separation better than manual copying. The disadvantage is that you're uploading your file to a third-party server, which matters if the PDF contains sensitive information. Check the converter's privacy policy before uploading.

Converting the PDF to another format first

Another approach is to convert the PDF to a format Excel can read more easily, such as CSV or HTML. Use a free converter like CloudConvert or Zamzar to change the PDF to HTML, then open that HTML file in Excel. Excel will recognize the table structure and import it with better formatting than a direct copy sometimes produces.

Some PDF readers, including Adobe Reader, have a built-in export feature. Open the PDF in Adobe Reader, go to File > Export To, and choose a format like Microsoft Word or HTML. Then open that exported file in Excel or copy the table from it. This keeps your file on your computer rather than uploading it to a web service.

Handling scanned PDFs and image-based tables

If your PDF is a scanned image, the table is not selectable as text. Copying will not work. You have two options: use optical character recognition (OCR) software to convert the image to text, or enter the data manually into Excel.

Free OCR tools include Google Docs (upload the PDF and it will OCR it automatically), Tesseract, and some online converters. Upload the scanned PDF, let the tool process it, and then copy the recognized text into Excel. The accuracy depends on the image quality — a clear, straight scan will convert better than a blurry or tilted one.

For small tables, manual entry is sometimes faster than troubleshooting OCR. If the table has fewer than 20 rows and 5 columns, typing it directly into Excel may take less time than uploading, converting, and fixing errors.

Fixing alignment and formatting after pasting

After pasting a table into Excel, check that each piece of data is in the correct cell. If an entire row landed in one cell, select that cell and use the "Text to Columns" feature. Go to the Data menu, click Text to Columns, and choose Delimited. Select the delimiter (usually Space or Tab) that separates your data, and click Finish. Excel will split the data across multiple columns.

Adjust column widths by double-clicking the border between column headers to auto-fit, or drag the border manually. Check that numbers are formatted as numbers, not text — if they're left-aligned instead of right-aligned, they're stored as text and won't calculate correctly. Select the column, right-click, choose Format Cells, and set the format to Number.

Remove any extra blank rows or columns that came through during the paste. These often appear at the edges of the table and will interfere with sorting or filtering later.

When to use Excel's built-in web import feature

In Excel 2016 and later on Windows, you can use the "From Web" feature to import tables from web pages. If your PDF is saved as an HTML file or accessible as a web page, this method may work. Go to the Data tab, click From Web (or Get Data > From Web in newer versions), paste the URL or file path, and Excel will show you the tables on that page. Select the table you want and click Load.

This feature is less reliable for PDFs than for regular web pages, and it's not available in all versions of Excel or on Mac. It works best when the PDF has already been converted to HTML or when you're pulling from a website that displays the table as a web page.

Frequently Asked Questions

Why does my table paste into one column instead of multiple columns?

The PDF likely uses spaces or tabs to separate columns, but Excel interpreted the entire row as a single cell. After pasting, select the column with the data, go to Data > Text to Columns, choose Delimited, select Space or Tab as the separator, and click Finish. Excel will split the data across the correct columns.

Can I copy a table from a scanned PDF?

Not directly — scanned PDFs are images, so the text isn't selectable. Use an OCR tool like Google Docs, Tesseract, or an online converter to turn the image into readable text first. Then copy the recognized text into Excel. Accuracy depends on how clear the scan is.

What's the difference between a text-based and image-based PDF?

A text-based PDF was created from a digital document and allows you to select and copy text. An image-based PDF is a scanned photograph of a printed page and does not allow text selection. You can tell by trying to click and drag across the table — if you can select text, it's text-based.

Do I need special software to copy a PDF table to Excel?

No. For text-based PDFs, your web browser or the free Adobe Reader is enough. For scanned PDFs, free online OCR converters or Google Docs can help. Paid software like Adobe Acrobat Pro offers more control but is not necessary for basic copying.

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

Most reputable converters delete files after processing, but check their privacy policy first. If your PDF contains sensitive information, use a desktop tool instead — Adobe Reader's export feature, Google Docs OCR, or a downloadable converter like Tesseract keeps your file on your computer.