The simplest way depends on what's inside your PDF
If your PDF contains a table with clear rows and columns, you have several routes. The fastest is to copy the table directly from the PDF into Excel — open the PDF, select the table, paste it into a blank Excel sheet, and clean up the formatting. This works well when the PDF was created from a document (like a Word file or spreadsheet) rather than scanned from paper.
If the PDF is a scan or the table is complex, copying won't work cleanly. In that case, you'll need either a conversion tool or to re-enter the data by hand. The choice depends on how much data you have, how accurate it needs to be, and whether you want to spend money.
Key Takeaways
- Copying and pasting from a PDF into Excel works best for tables that were originally digital, not scanned from paper.
- Free online converters like Smallpdf, ILovePDF, and CloudConvert can turn PDFs into Excel files, but the result often needs manual cleanup.
- Scanned PDFs (images of paper documents) cannot be converted to spreadsheets without optical character recognition (OCR) software, which adds cost and time.
- For small tables, re-entering the data by hand is often faster and more accurate than fighting with conversion tools.
- Excel's built-in import tools can sometimes read PDF data if you save the PDF as a text file first.
When copy-and-paste actually works
Open your PDF in Adobe Reader, Preview (on Mac), or your browser. Look at the table — if you can click and drag to select the text and it highlights cleanly, the PDF is digital and copy-paste will work. Click and drag to select the entire table, then press Ctrl+C (or Cmd+C on Mac) to copy.
Open Excel and click on the cell where you want the table to start. Press Ctrl+V (or Cmd+V) to paste. The data will land in the spreadsheet, but the formatting may be messy — columns might be too narrow, numbers might be text instead of numbers, or spacing might be off. Spend a few minutes cleaning this up: widen columns by double-clicking the column border, check that numbers are formatted as numbers (not text), and delete extra blank rows.
This method fails if the PDF is a scanned image. You'll see the table, but you won't be able to select the text — it's a picture, not actual data. In that case, move to the conversion tool section below.
Free online conversion tools and their limits
Smallpdf, ILovePDF, and CloudConvert are the most reliable free options. Upload your PDF, choose "PDF to Excel" or "PDF to CSV", and read the result. The process takes less than a minute for most files.
The catch: these tools work best on clean, straightforward tables. If your PDF has merged cells, multiple tables on one page, or unusual formatting, the output will be messy. You'll often spend 15 to 30 minutes fixing the spreadsheet by hand — moving data to the right columns, deleting extra rows, or re-entering cells the tool misread.
For scanned PDFs, these tools usually fail entirely. They can't read text from an image without OCR, and most free converters don't include OCR. Some paid plans (like Smallpdf's premium version) do include OCR, but you're paying for a feature you might use once.
Handling scanned PDFs and when OCR is worth the cost
A scanned PDF is a photograph of a paper document. The text isn't actually text — it's pixels arranged to look like letters. To convert it to a spreadsheet, you need optical character recognition (OCR), software that looks at the pixels and guesses what letters they represent.
Free OCR tools exist (Google Docs can do basic OCR, and so can some free online converters), but they're slow and error-prone, especially with tables. If you have one or two scans, it might be worth trying Google Docs: upload the PDF to Google Drive, right-click it, choose "Open with" and select "Google Docs". Google will convert it to a document with OCR. Then copy the table and paste it into Excel. Expect to spend time fixing mistakes.
If you have many scanned documents or the table is complex, paid OCR software like Adobe Acrobat Pro (which costs about $180 per year or $15 per month) or ABBYY FineReader (similar pricing) will be faster and more accurate. These programs are built for this task and make fewer mistakes. But for a one-time conversion, the time you save probably isn't worth the cost.
Using Excel's built-in import features
Excel can import data from text files. If your PDF can be saved as a plain text file (.txt), Excel's Text Import Wizard can sometimes read it. This is a workaround, not a direct solution, but it works when other methods fail.
Save your PDF as a text file (most PDF readers have a "Save As" option). Open Excel, go to File > Open, and select the text file. Excel will launch the Text Import Wizard, which lets you tell it where the columns break and how to handle the data. This works best if the PDF's table had clear spacing between columns.
When to just re-enter the data by hand
If your table has fewer than 50 rows and 10 columns, typing it into Excel by hand is often faster than fighting with conversion tools. You'll be done in 20 to 30 minutes, the data will be clean and correct, and you won't have to troubleshoot formatting problems.
Hand entry also makes sense if the PDF table has a lot of merged cells, notes in the margins, or irregular structure — things that confuse conversion tools. You understand the data as you type it, so you catch mistakes when ready.
For large tables (hundreds of rows), conversion tools are worth the time investment even if they need cleanup, because typing would take hours.
Comparing your options side by side
| Method | Best for | Time needed | Cost |
|---|---|---|---|
| Copy and paste | Digital PDFs with straightforward tables | 5–15 minutes | Free |
| Free online converter (Smallpdf, ILovePDF, CloudConvert) | Digital PDFs with moderate complexity | 15–45 minutes (including cleanup) | Free |
| Google Docs OCR | Scanned PDFs with straightforward tables | 30–60 minutes (including cleanup) | Free |
| Paid OCR software (Adobe Acrobat Pro, ABBYY) | Many scanned PDFs or complex tables | 10–20 minutes per document | $15–20/month or $150–200/year |
| Hand entry | Small tables (under 50 rows) | 20–30 minutes | Free |
Frequently Asked Questions
Why does my converted spreadsheet have text instead of numbers?
Conversion tools sometimes read numbers as text, especially if they have leading zeros or special formatting. Click the column header to select the entire column, then go to Data > Text to Columns. Click Next twice, then choose "General" or "Number" format and click Finish. Excel will convert the text to actual numbers.
Can I convert a PDF with multiple tables on one page?
Most converters will try to put all tables into one spreadsheet, which creates a mess. Copy each table separately instead: select the first table, paste it into Excel, then go back to the PDF and copy the next table into a new sheet. This takes longer but gives you clean, separate data.
What if the PDF is password-protected?
You'll need to remove the password before you can convert it. Some free online tools (like Smallpdf's password remover) can do this, but they only work if the PDF isn't encrypted for security. If it is, you'll need the password or permission from whoever created the file.
Is there a way to automate this if I have dozens of PDFs?
If all your PDFs have the same structure, paid OCR software and some spreadsheet tools can batch-process them. But setup takes time, and you'll still need to check the results. For one-off conversions, automation isn't worth the effort.
Why does my table look different after I paste it into Excel?
PDFs and Excel handle spacing and formatting differently. Columns might be too narrow, text might wrap unexpectedly, or colors might disappear. Widen columns by double-clicking the border between column headers, and manually adjust row height if needed. This is normal and takes just a few minutes.