PDFVela — pdfvela.com

How to copy a table from a PDF into Excel

Every value in its own cell instead of one long line of text — and how to fix the numbers afterwards

By · Updated November 3, 2026

Why copy and paste gives you one long column

Select a table in a PDF reader, paste it into Excel and you usually get every row squeezed into column A — or worse, every value on its own line. That is not your mistake. A PDF has no idea it contains a table: it only stores where each word is drawn on the page. The ruled lines you see are separate drawing instructions, unrelated to the text.

To get the cells back, something has to look at where the words sit and work out which ones line up into columns. The PDF to Word converter does exactly that, and a Word table pastes into a spreadsheet cell by cell.

The shortest route: straight to an Excel file

If you would rather skip the middle step, the PDF to Excel tool does the same column detection and hands you an .xlsx file directly. Amounts arrive as numbers you can add up, while numbers with leading zeros and IBANs stay as text; each PDF page can go on its own sheet, or all of them on one. If you also want to edit the text around the table, the Word route below is more flexible.

Step by step: PDF table → Word → Excel

  1. If the table is on a few pages of a long document, take those pages out first with Extract PDF pages. Conversion is faster and you do not have to search for the table.
  2. Open PDF to Word and choose the PDF. Untick Include images — you only need the text.
  3. Convert and download the .docx file. Open it in Word, LibreOffice Writer or Google Docs.
  4. Click inside the table. In Word, the small square handle at its top-left corner selects the whole table; you can also drag across the rows you need.
  5. Copy, then click cell A1 in an empty Excel sheet and paste. Each value lands in its own cell.

Google Sheets works the same way: paste the copied Word table into a sheet and the columns are kept.

When the columns are not recognised

The converter decides that text is a table when at least two consecutive lines have values in the same columns, separated by clearly wider gaps than between words. Most invoices, price lists, bank statements and reports meet that test. It can fail when:

  • The columns are very close together. If the gap between two values is barely wider than a space, they are treated as one piece of text. That row arrives in one cell; split it in Excel with Data → Text to Columns.
  • The table is really two columns of prose. Long sentences side by side are read as text columns, one after the other, not as a table — which is usually what you want for an article.
  • The PDF is a scan. There is no text to position. Run OCR PDF first, then convert the searchable PDF to Word.

Cleaning up after pasting

A cell that wrapped onto two lines becomes two rows. In the PDF, a long description is two separate lines of text, so the second line arrives as an extra row with only that column filled in. Cut the text into the cell above and delete the empty row. With many such rows, sort by a column that is always filled (such as the amount) to gather the half-empty rows together. The PDF to Excel converter joins such lines back into one cell for you.

Tables that continue across pages arrive in pieces. Each page is converted separately, so a three-page statement gives three tables, often each with its own header row. Paste them one under another and delete the repeated headers.

Numbers turned into text or dates. Excel interprets what you paste using your computer's regional settings. A statement with 1,234.56 on a computer that uses a decimal comma — or 1.234,56 on one that uses a decimal point — comes out as text or as the wrong number, and 3.10 may become 3 October. Select the column, choose Data → Text to Columns → Delimited → Next → Next, click Advanced, set the decimal and thousands separators used in the PDF, and finish. The values become real numbers you can add up.

Currency signs and spaces. If amounts like € 1 250 stay as text, use Find & Replace to remove the currency sign and the spaces, then convert as above.

Leading zeros disappear. Customer numbers or postcodes such as 00421 lose their zeros when Excel reads them as numbers. Format that column as Text before pasting, or keep the original numbers next to the converted ones.

Excel's own "From PDF" import

Excel in Microsoft 365 for Windows can also read tables directly: Data → Get Data → From File → From PDF. It lists the tables it finds and loads the one you pick. If you have it, try it — but note that it opens the file through Power Query, is not available in every Excel edition or on every platform, and handles the same scanned and wrapped-cell cases no better. The Word route works on any computer and in any spreadsheet program.

Why convert in the browser?

The tables people copy into Excel are usually bank statements, payslips, invoices and price lists — exactly the documents you should not upload to an unknown server. PDFVela converts the PDF on your own device: the file is not sent anywhere and is cleared from memory when you close the tab. For statements specifically — locked PDFs, debit and credit columns, a year in one sheet — see how to convert a bank statement PDF to Excel.

Ready to try it? It is free and your file stays on your device.

Open PDF to Excel

Questions about PDF tables and Excel

Does PDFVela have a PDF to Excel converter?

Yes. The PDF to Excel tool splits aligned columns into cells and gives you an .xlsx file directly, with amounts as numbers. If you also want to edit the text around the table, PDF to Word rebuilds it as a real Word table, and a Word table pastes into Excel or Google Sheets cell by cell.

Why does the whole row land in one cell when I copy from the PDF?

A PDF does not store a table, only words placed at positions on the page. A PDF reader copies them as lines of text separated by spaces. The Word conversion works out the columns from the positions of the words.

Does this work with a scanned table?

Only after OCR. A scan is a picture with no text in it. Run OCR PDF first, then convert the result to Word. Check the numbers carefully afterwards, because OCR can misread a digit.

Why are some of my numbers dates or text in Excel?

Excel reads numbers using your computer's regional settings. A PDF written with a decimal point, opened on a computer that uses a decimal comma (or the reverse), is misread. Fix it with Data → Text to Columns → Advanced, as described below.