Why does my pasted table land in one column?

Because the PDF has no column structure to paste. The text arrives in reading order and the spreadsheet puts it in one column until you tell it where the boundaries are.

Will the formatting come across?

No. You get the data, not the fonts, colours or borders. That is usually what you wanted from a table anyway.

Does this work on a bank statement with many pages?

Yes, though tables split across pages are the most common source of errors — check the rows on either side of each page boundary.

Text to Columns in your spreadsheet costs nothing and handles simple tables. The paid path is for layouts that need interpreting.

Abzar

Getting a table out of a PDF and into Excel

You need the numbers from a PDF invoice, bank statement or report in a spreadsheet. You select the table, copy it, paste — and get a single column of values with the structure gone.

That is not a bug in Excel. A PDF table has no rows and columns; it is text placed at coordinates, with lines drawn around it to look like a grid. Every method of getting it into a spreadsheet is a way of guessing the structure back.

Try the cheapest method first

For a simple, well-ruled table, paste into a spreadsheet and use Text to Columns with the delimiter set to space or tab. It is free, instant and works more often than people expect.

It fails predictably: cells containing spaces get split, cells spanning two lines break apart, and merged headers land in the wrong place. When you see that, move on rather than fixing hundreds of cells by hand.

When the structure needs interpreting

Messy layouts — multi-line cells, tables continuing across pages, values in columns without ruling lines — need something that judges where the table begins and ends. That is what the AI extraction in Abzar's PDF to Excel does: the page content goes to a model, which returns rows and columns as a spreadsheet.

The trade-off is explicit. It runs in the cloud rather than in your browser and costs credits, because there is a real per-task cost behind it. For a sensitive document, weigh that before uploading.

If the PDF is a scan, nothing will read it directly

A scanned statement is a picture. Run text recognition first to turn the page into text, then structure the text. Accuracy compounds: an OCR error in a number becomes a wrong number in your spreadsheet, so check figures against the source rather than assuming.

Always verify before you rely on it

Whatever method you used, spend two minutes on these checks — they catch almost every serious extraction error:

Count the rows. A missing or duplicated row is the most common failure and the easiest to spot.
Sum a numeric column and compare it with the total printed in the document.
Look at the first and last row of every page break; that is where splits go wrong.
Check one cell that contained a line break, and one that contained a currency symbol or thousands separator.

FAQ

Why does my pasted table land in one column?: Because the PDF has no column structure to paste. The text arrives in reading order and the spreadsheet puts it in one column until you tell it where the boundaries are.
Will the formatting come across?: No. You get the data, not the fonts, colours or borders. That is usually what you wanted from a table anyway.
Does this work on a bank statement with many pages?: Yes, though tables split across pages are the most common source of errors — check the rows on either side of each page boundary.
Is there a free way?: Text to Columns in your spreadsheet costs nothing and handles simple tables. The paid path is for layouts that need interpreting.

PDF to Excel

Getting a table out of a PDF and into Excel

Try the cheapest method first

When the structure needs interpreting

If the PDF is a scan, nothing will read it directly

Always verify before you rely on it

FAQ

More guides