The fastest way depends on what your PDF contains

Moving data from a PDF into Excel works differently depending on whether the PDF is a straightforward table, text with numbers, or a scanned image. If your PDF contains a clean table with rows and columns, you can often copy and paste directly into Excel. If the PDF is text or numbers scattered across the page, you may need to copy it into Excel and then organize it into columns yourself. If the PDF is a scanned image or photograph of a document, you will need to type the data in by hand or use optical character recognition (OCR) software — Excel cannot read images.

The method you choose also depends on how much data you have and whether you plan to do this once or many times. A single small table might be worth copying by hand. A hundred pages of data makes a different case. This guide walks through the main routes: direct copy-paste, using Excel's built-in text-to-columns feature, and using free OCR tools for scanned PDFs.

Key Takeaways

  • If your PDF contains a table with clear rows and columns, you can select and copy it directly into Excel in most cases.
  • Text or numbers that paste into Excel as a single column can be split into separate columns using the Text to Columns feature under the Data menu.
  • Scanned PDFs (images of documents) require OCR software to convert the image to readable text before you can move it to Excel.
  • Free online OCR tools like ILovePDF and Smallpdf can convert scanned PDFs to text or Excel format without installing software.
  • If copy-paste does not work cleanly, saving the PDF as a text file first often makes the data easier to organize in Excel.

Copying a table directly from PDF to Excel

Open your PDF in Adobe Reader, Preview (on Mac), or your web browser. Look for a table with clear rows and columns. Click and drag to select the entire table, or use Ctrl+A (Windows) or Command+A (Mac) to select all content if the PDF contains only that table.

Copy the selection using Ctrl+C (Windows) or Command+C (Mac). Open Excel and click on the cell where you want the data to start — usually cell A1. Paste using Ctrl+V (Windows) or Command+V (Mac). Excel will attempt to place each column in its own column and each row in its own row. If the table pastes cleanly, you are done. If columns are misaligned or data runs together, move to the next section.

Splitting pasted data into separate columns with Text to Columns

When you paste data from a PDF, it sometimes lands in Excel as a single column with all the information crammed together. You can separate it using Excel's Text to Columns feature. First, select the column containing the jumbled data by clicking the column header (the letter at the top).

Go to the Data menu at the top of Excel and click Text to Columns. A dialog box will open. Excel will ask you to choose a delimiter — the character that separates your data. Common delimiters are commas, tabs, spaces, or semicolons. If you are not sure which one your data uses, check the preview at the bottom of the dialog. Once you select the correct delimiter, click Finish. Excel will split the data across multiple columns.

If none of the standard delimiters work, your PDF data may have pasted in an unusual format. In that case, try saving the PDF as a plain text file first (see the next section) and then opening that text file in Excel, which often handles the conversion more cleanly.

Converting a scanned PDF using free OCR tools

If your PDF is a scanned image or photograph of a document, you cannot copy text from it directly. You need optical character recognition (OCR) software to read the image and convert it to text. Several free online tools do this without requiring you to install anything.

ILovePDF (ilovepdf.com) and Smallpdf (smallpdf.com) both have free OCR features. Upload your PDF, wait for the conversion to finish, and read the result as a text file or Excel file. These tools work best on clear, straight scans. If your image is blurry, rotated, or has poor lighting, the OCR may miss words or misread numbers.

After you read the converted file, open it in Excel and check the data carefully. OCR is not perfect — it may confuse the number 0 with the letter O, or misread handwriting. Scan through the first few rows to catch errors before you rely on the data for calculations or decisions.

Saving a PDF as a text file first

Some PDFs resist copy-paste because of how they were created. A workaround is to save the PDF as a plain text file, then open that text file in Excel. Open your PDF in Adobe Reader. Go to File and select Save As. In the file type dropdown, choose Text (Plain) or Text (Accessible). Save the file with a new name.

Open Excel and go to File > Open. Find your text file and open it. Excel will show an Import Wizard dialog that lets you preview how the data will be arranged and choose delimiters. This method often produces cleaner results than copying directly from the PDF, especially if the PDF has unusual formatting.

When copy-paste does not work: troubleshooting

If you copy from a PDF and nothing pastes into Excel, or if only part of the data pastes, the PDF may be protected or encrypted. Try opening the PDF in a different program — sometimes one program can read a PDF that another cannot. If the PDF is password-protected, you will need the password to proceed.

Another common issue is that the PDF was created from a scanned image and the creator did not run OCR on it. In that case, the PDF looks like a document but contains no actual text — only a picture. You will need to use an OCR tool (see the section above) to convert it.

If you have a very large PDF with many pages of data, copying and pasting page by page is slow and error-prone. Consider whether a free OCR tool or a text-file conversion might save time. For truly large jobs, specialized PDF-to-Excel conversion software exists, though most charge a fee.

Organizing and cleaning up your data in Excel

After you move data from a PDF into Excel, take a moment to check it. Look for extra spaces, missing values, or text where numbers should be. PDFs sometimes add line breaks or special characters that do not belong in a spreadsheet. Select any column that looks suspicious and use Find & Replace (Ctrl+H on Windows, Command+H on Mac) to remove unwanted characters.

If your data includes dates, numbers, or currency, make sure Excel recognizes them as the right type. Click a column header and go to Home > Format as Table or right-click and choose Format Cells to set the correct format. This step prevents Excel from treating numbers as text, which can cause problems if you plan to sort, filter, or calculate with the data later.

Frequently Asked Questions

Can I convert a PDF to Excel without copying and pasting?

Yes. You can save the PDF as a text file and open it in Excel, which often produces better results than copy-paste. You can also use free online OCR tools like ILovePDF or Smallpdf to convert the PDF directly to an Excel file, though the quality depends on how clear the original PDF is.

What if my PDF is a scanned image?

Scanned PDFs are images, not text, so copy-paste will not work. Use a free OCR tool like ILovePDF, Smallpdf, or Google Docs (upload the PDF and it will OCR it automatically). After conversion, check the data carefully because OCR sometimes misreads numbers or letters.

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

The PDF data did not paste with delimiters that Excel recognizes. Select the column and use Data > Text to Columns to split it. Choose the delimiter (comma, tab, space, or semicolon) that separates your data, and Excel will spread it across columns.

Is there a way to automate this if I do it regularly?

For one-time or occasional transfers, manual copy-paste or OCR tools are usually fastest. If you convert PDFs to Excel dozens of times, paid software like Tabula or Adobe Acrobat Pro can automate the process, but free methods work fine for most people.

Can Excel open a PDF file directly?

Excel cannot open PDF files as spreadsheets. You must convert the PDF first — either by copying data out of it, saving it as text, or using OCR — before you can work with it in Excel.