How to Copy a Table From a PDF Into Excel

The fastest way depends on what the PDF looks like

If the table in your PDF is straightforward and clearly formatted, you can often select and copy it directly into Excel. Open the PDF in Adobe Reader or your browser, click and drag to select the table, press Ctrl+C (or Cmd+C on Mac), then click into an Excel cell and press Ctrl+V. The table will paste as text or a rough grid, though formatting may not transfer perfectly.

If that doesn't work cleanly — if the table breaks into the wrong columns, or if the PDF is scanned as an image rather than text — you have three other routes: use a free online converter, copy the data manually, or use Excel's built-in PDF import tool. Which one makes sense depends on how many tables you need to move and how much the formatting matters.

Key Takeaways

straightforward copy-and-paste from PDF to Excel works for most clearly formatted tables, though you may need to clean up spacing and alignment afterward.
If the PDF is a scanned image or the table has complex formatting, direct copy-paste will fail, and you will need a converter or manual entry.
Excel can import PDF files directly through the Data menu, which sometimes preserves table structure better than copy-paste.
Free online converters like Smallpdf or ILovePDF can extract tables as Excel files, but they work best on clean, straightforward tables.
For a single small table, manual copying cell-by-cell takes five minutes and guarantees accuracy.

Try direct copy-and-paste first

Open the PDF file in Adobe Reader, Google Chrome, or Microsoft Edge. Click at the top-left corner of the table you want to copy, then drag to the bottom-right corner to select the entire table. The selection should appear highlighted in blue. Press Ctrl+C on Windows or Cmd+C on Mac to copy.

Switch to Excel and click on the cell where you want the table to start. Press Ctrl+V or Cmd+V to paste. Excel will place the data into cells, though the columns may not align the way they did in the PDF. You will likely need to adjust column widths and clean up extra spaces. If the paste creates a mess of data in one column instead of spreading across multiple columns, the PDF table was not formatted in a way that copy-paste can read cleanly — move to one of the other methods below.

Use Excel's built-in PDF import if copy-paste fails

Excel has a feature to import data directly from a PDF file, which sometimes works better than manual copy-paste. Open Excel, go to the Data tab at the top, and look for "Get Data" or "From File" (the exact name varies by Excel version). Select "From PDF" if you see it, or choose "From File" and then select your PDF.

Excel will show you a preview of the PDF and let you select which table or area you want to import. Click the table you want, then click Load or Import. Excel will create a new sheet with the data. This method works well for PDFs where the table has clear borders or consistent spacing, but it may still require cleanup if the PDF is poorly formatted or scanned as an image.

Convert the PDF to Excel using a free online tool

If you have multiple tables or a complex PDF, an online converter can sometimes extract the entire table structure at once. Go to Smallpdf.com, ILovePDF.com, or CloudConvert.com, upload your PDF, select "PDF to Excel" or "Extract Table", and read the result as an Excel file. These tools work best on clean, straightforward tables with clear rows and columns.

The converted file will open directly in Excel. You may still need to fix spacing, remove extra rows, or adjust column widths, but the data will already be in the right cells rather than all in one column. If the converter produces a messy result, it usually means the PDF table itself is too complex or poorly formatted for automated extraction — in that case, manual entry is often faster than trying to fix the conversion.

Copy the data manually if the table is small

For a table with fewer than 20 rows and 5 columns, manual copying is often the fastest and most accurate method. Open the PDF and Excel side by side on your screen. Read the values from the PDF table and type them directly into Excel cells. This takes about five minutes for a small table and guarantees that the data lands in the right place.

This method also lets you catch errors as you go — if a number in the PDF looks wrong or unclear, you can stop and verify it before entering it. For larger tables, this becomes tedious, but for a quick one-time job, it beats troubleshooting a failed conversion.

Fix formatting and spacing after you paste

Regardless of which method you use, the pasted data will usually need cleanup. Check for extra blank rows or columns that the paste created. Look for text that should be in separate cells but ended up in one cell, or numbers that pasted as text instead of numbers (Excel will show these left-aligned instead of right-aligned). Select the data and use Excel's "Text to Columns" feature under the Data tab to split text that landed in the wrong cells.

Adjust column widths by double-clicking the border between column headers to auto-fit, or drag the border to set a custom width. If numbers pasted as text, select them, go to Data, and choose "Text to Columns" again — this usually converts them back to actual numbers that Excel can calculate with. Once the data is clean, save the file and you are done.

When the PDF is a scanned image

If the PDF is a photograph or scan of a printed page rather than a digital document, copy-paste will not work at all — you will just get blank cells or gibberish. The PDF does not contain actual text, only an image of text. Your only options are manual entry or a tool that uses optical character recognition (OCR) to read the image and extract the text.

Some online converters like Smallpdf include OCR, so you can upload a scanned PDF and they will attempt to read the table and convert it to Excel. The accuracy depends on how clear the scan is. If the scan is blurry or the table has handwriting, OCR will make mistakes. For a scanned table, manual entry is often more reliable than OCR, especially if accuracy matters.

Frequently Asked Questions

Why does my pasted table have everything in one column?

The PDF table does not have clear column breaks that Excel can recognize. Use the "Text to Columns" feature under the Data tab to split the text. You may need to specify a delimiter (a character that separates columns, like a comma or space) or let Excel auto-detect it. If that does not work, try a PDF-to-Excel converter instead.

Can I copy a table from a password-protected PDF?

If the PDF is locked against copying, you will not be able to select or copy text from it. You will need the password to unlock it first. If you have the password, open the PDF, enter it when prompted, and then you can copy normally. If you do not have the password, you cannot extract the data without the owner's permission.

What if the online converter produces a blank Excel file?

The converter could not read the PDF table, usually because it is a scanned image or has very complex formatting. Try a different converter, or use Excel's built-in PDF import feature instead. If both fail, manual entry is your most reliable option.

Do I need to buy software to convert a PDF table to Excel?

No. Excel's built-in import feature is free, and online converters like Smallpdf, ILovePDF, and CloudConvert offer free versions that work for most tables. You only need to buy software if you convert dozens of PDFs per month and want to automate the process.

Will the formatting (colors, borders, fonts) copy over to Excel?

Usually not. Copy-paste and converters typically move only the text and numbers, not the visual formatting. You can reformat the table in Excel afterward if you need colors or borders, but expect to do that work yourself.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.