The three ways to move PDF data into Excel

Converting a PDF to Excel depends on what kind of PDF you have. If the PDF contains a table or structured data, you have three main routes: copy and paste the data directly, use Excel's built-in import feature, or use an online converter. The fastest method for a straightforward table is usually copy-paste. For PDFs with multiple tables or complex layouts, an online converter or specialized software often works better because it preserves the structure automatically.

The method you choose also depends on how much data you have and whether the PDF is a scanned image or a text-based file. A scanned PDF (a photograph of a document) cannot be converted the same way as a PDF with selectable text. If you cannot click and highlight text in the PDF, you will need a different approach.

Key Takeaways

  • Copy and paste works fastest for small tables in text-based PDFs, but requires manual formatting in Excel afterward.
  • Excel's built-in import feature (Data > From File > From PDF) works on Windows and newer Mac versions, though results vary by PDF layout.
  • Online converters like Zamzar, CloudConvert, or ILovePDF handle multiple tables and complex layouts but require uploading your file to a third-party website.
  • Scanned PDFs (image-based) cannot be converted directly and require optical character recognition (OCR) software first.
  • After conversion, you will almost always need to clean up formatting, remove extra rows, and adjust column widths in Excel.

Copy and paste for small, straightforward tables

If your PDF contains one or two small tables with clear rows and columns, copying and pasting is the quickest method. Open the PDF in any PDF reader (Adobe Reader, Preview on Mac, or your browser). Click and drag to select the table data, then press Ctrl+C (Windows) or Command+C (Mac) to copy.

Switch to Excel and click the cell where you want the data to start. Press Ctrl+V (Windows) or Command+V (Mac) to paste. Excel will attempt to place each column in its own cell, though the results depend on how the PDF formatted the original table. You will likely need to adjust column widths, delete blank rows, and reformat headers. This method works best when the PDF table has clear borders or spacing between columns.

Using Excel's built-in PDF import on Windows and Mac

Excel 2021 and newer (Windows) and Excel 2016 and newer (Mac) include a native PDF import tool. Open Excel and go to the Data tab at the top. Click "From File" and then "From PDF." Navigate to your PDF file and select it. Excel will show you a preview of the tables it found in the PDF.

Select the table or tables you want to import by clicking the checkbox next to each one. Click Load to bring the data into Excel. This method preserves table structure better than copy-paste and works well for PDFs with clearly formatted tables. However, it struggles with PDFs that have mixed layouts, overlapping text, or tables that span multiple pages. If the preview shows garbled or incomplete data, switch to an online converter instead.

Online converters for complex PDFs

Services like Zamzar, CloudConvert, and ILovePDF handle PDFs with multiple tables, unusual layouts, or data spread across many pages. Go to the converter website, upload your PDF file, select Excel as the output format, and start the conversion. The service processes the file and gives you a read link. Most free versions work for files under 100 MB and allow a few conversions per day.

The advantage of online converters is that they handle complex layouts better than copy-paste or Excel's built-in tool. The disadvantage is that you are uploading your file to someone else's server. If your PDF contains sensitive information, check the converter's privacy policy first, or use a desktop tool instead. Conversion usually takes a few seconds to a few minutes depending on file size and server load.

What to do with scanned PDFs and images

If your PDF is a scanned document or photograph of a page, the text is stored as an image, not as selectable text. You cannot copy from it or use standard converters. You need optical character recognition (OCR) software to read the image and extract the text first.

Adobe Acrobat (paid) includes OCR and can convert scanned PDFs to Excel. Free alternatives include Google Docs (upload the PDF, right-click and select "Open with" > "Google Docs," then copy the recognized text) or online OCR tools like Free OCR or ILovePDF's OCR feature. After OCR converts the image to text, you can then use copy-paste or an online converter to move the data into Excel. This adds an extra step but is necessary for scanned documents.

Cleaning up and formatting after conversion

No matter which method you use, the converted data will need cleanup. Open the Excel file and look for extra blank rows, misaligned columns, and headers that landed in the wrong cells. Delete blank rows by right-clicking the row number and selecting Delete. Adjust column widths by double-clicking the border between column letters at the top — Excel will auto-fit the width to the content.

Check that numbers are formatted as numbers, not text. If a column of numbers is left-aligned instead of right-aligned, Excel is treating them as text. Select the column, go to Data > Text to Columns, and click Finish. This converts them to actual numbers so you can use them in formulas. Remove any extra spaces or line breaks within cells by using Find & Replace (Ctrl+H or Command+H) to search for line breaks and replace them with nothing.

Choosing the right method for your situation

Start with copy-paste if the PDF has one or two small, clearly formatted tables. Use Excel's built-in import if you have Excel 2021 or newer and the PDF has standard table layouts. Choose an online converter if the PDF has multiple tables, complex layouts, or spans many pages. For scanned PDFs, run OCR first, then use one of the other methods.

Test your method on a small section of the PDF before converting the entire file. This saves time if the conversion does not work the way you expected. If one method produces messy results, try another — different PDFs convert differently depending on how they were created.

Frequently Asked Questions

Why does my converted data have extra spaces and blank rows?

PDFs often include invisible formatting characters and spacing that do not translate cleanly to Excel. Use Find & Replace to remove extra spaces: press Ctrl+H (Windows) or Command+H (Mac), search for multiple spaces or line breaks, and replace them with single spaces or nothing. Select the data and use Data > Text to Columns to clean up alignment issues.

Can I convert a password-protected PDF?

Most converters and Excel's import tool cannot read password-protected PDFs. You must open the PDF in Adobe Reader or your PDF viewer, remove the password protection (if you know it), and save an unprotected copy. Then convert the unprotected version. If you do not know the password, you cannot convert the file.

What if the online converter is not recognizing my tables?

Try a different converter — some handle certain PDF layouts better than others. CloudConvert and ILovePDF often work when Zamzar does not, or vice versa. If multiple converters fail, the PDF may have been created in a way that makes table extraction difficult. In that case, copy-paste or manual data entry may be your only option.

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

Most reputable converters delete files after a few hours, but check their privacy policy first. If your PDF contains confidential information, use Excel's built-in import tool or desktop software instead. For sensitive documents, avoid uploading to third-party websites.

Why is my converted data showing as text instead of numbers?

Excel sometimes imports numbers as text, especially if the PDF used unusual formatting. Select the column, go to Data > Text to Columns, and click Finish without changing any settings. This converts the text to actual numbers. If that does not work, select the column and use Find & Replace to remove any leading spaces or special characters.