PDFJadoo › Blog › PDF Table to Excel

PDF table lands in one Excel cell? Convert it properly

You copied the table out of the PDF, pasted it into Excel — and the whole row arrived as one long line inside a single cell. The spreadsheet is not broken, and neither are you. A PDF simply does not store rows and columns the way Excel does. Here is why paste fails, and the routes that actually work.

Free, in your browserFiles never uploadedThree routes, one honest check
PDFJadoo logoBy the PDFJadoo Team6 min read
Diagram: a table copied from a PDF landing as one long line inside a single Excel cell, then the same table converted properly into separate rows and columns that can be sorted and summed
A PDF stores words at positions on a page. It never promised anyone a grid — the grid has to be rebuilt.

Why the paste breaks: a PDF has no rows

Open a spreadsheet and every value lives in a cell, in a row, in a column. That structure is the whole point of the file. A PDF works the other way round: it stores text placed at exact positions — this word at this height, that number at that distance from the left edge. It is a picture of a finished page, drawn with real text.

So when you copy a table out of a PDF, you are not copying a table. You are copying a stream of words in reading order. Excel receives the stream, has nowhere to hang the columns, and parks the whole line in the first cell it can. The numbers were fine. The structure simply never existed in the file you copied from.

That one fact decides everything below: a converter's real job is to rebuild the grid — to read the positions, work out which words share a row and which share a column, and only then write a spreadsheet.

First, the two-second test: is your PDF born-digital or a scan?

Open the PDF and try to select one number in the table with the mouse. If you can highlight it, the text is real — the file was made by a program (a bank's system, accounting software, a report tool) and a converter can read its positions. If dragging selects nothing, or selects the whole page as one block, you are looking at a scan — a photograph of a table. Photographs have no positions to read, and they need one extra step first: OCR, covered in route three.

Route one: convert the PDF directly

Step 1 — open PDF to Excel. PDF to Excel reads every text item's position in your PDF, clusters the items into rows by their height on the page and into columns by consistent left-edge alignment, then writes a genuine Excel workbook — one worksheet per page of the PDF.

Step 2 — download and open the .xlsx. It opens in Excel, LibreOffice or Google Sheets like any spreadsheet. The numbers arrive text-exact — written exactly as they appear in the PDF — so format them as values before you start summing.

Step 3 — tidy what needs tidying. Neat, aligned tables convert beautifully. Tangled ones — a cell whose text wraps over two lines, a header that spans three columns — may drop a value in the wrong column or merge two lines together. A quick pass down the columns catches it: sort by one column and watch for the value that lands out of place.

Route two: the bank-statement case

Bank statements are the classic version of this job — months of transactions, needed in a spreadsheet for bookkeeping or a loan file. Two things help. First, ask the bank's app or website for the statement as a born-digital PDF rather than scanning a printed one: the system-made file converts cleanly where the scan fights you. Second, if the statement PDF asks for a password, that is a separate lock with its own fix — your bank set that password, and here is how to open your own statement. Unlock your copy first, then convert.

Route three: a scanned table needs OCR first

If the two-second test says “scan”, no converter can read the table yet — there is no text in the file at all, only a photograph of text. Run the scan through OCR PDF first: it reads the page and lays a real, searchable text layer over it. The OCR guide walks through it step by step — can't copy text from a scanned PDF? Then convert the OCR'd file with route one. Expect a little more tidying afterwards: a misread digit in a photograph is a converter working from a guess, and the check below matters double.

Going back: Excel to PDF

Finished the sums and need a clean copy to send? Excel to PDF turns the workbook back into a tidy PDF — the version you email to the client or attach to the application, while the spreadsheet stays your working copy.

The honest check nobody should skip

Whichever route you took, spot-check the totals. Add one column in Excel and compare it against the total printed in the PDF. Check one row in the middle against the original, digit by digit. A conversion that is 99% right is still wrong in one cell, and in a statement or an invoice table that one cell is usually a number somebody is relying on. Two minutes of checking is the difference between a converted table and a trustworthy one.

Rebuild the grid, properly

PDF to Excel reads the positions in your PDF and writes a real spreadsheet — one worksheet per page, in your browser, never uploaded.

Open PDF to Excel

A worked example: one statement page, checked both ways

Say the job is one page of a bank statement — a month of transactions that a loan file wants as numbers. The two-second test comes first: drag across one figure and it highlights, so the statement is born-digital and route one applies. The page goes through PDF to Excel and comes back as a workbook with that page as its own worksheet, rows and columns rebuilt from the positions in the PDF.

Then the check this page refuses to let you skip. The figures arrived text-exact, so they are formatted as values before anything is summed. The transactions column is added in Excel, and the total is compared against the total printed on the statement page: they match. One row in the middle is read against the PDF, digit by digit: it matches too. Only now is the spreadsheet a working copy instead of a hopeful one. Had the statement arrived as a scan, the route would have started one step earlier — OCR first, as the scanned PDF OCR guide walks through — with this same check doubled at the end.

Before you upload: the 60-second check

Fair questions

Why did my whole table paste into one cell?

Because a PDF does not contain a table — it contains words placed at positions on a page. Copying lifts the words in reading order, with no rows or columns attached, so Excel parks the stream in a single cell. A converter rebuilds the grid from the words' positions, which is the step paste cannot do.

Can I convert a scanned statement or invoice table?

Not directly — a scan is a photograph, and there is no text or positions inside it to read. Run it through OCR first to add a real text layer, then convert. Check the figures carefully afterwards: OCR works from shapes, and a hard-to-read digit can be misread.

Will the numbers add up in Excel?

The converter writes numbers text-exact — exactly as they appear in the PDF — so they may arrive formatted as text. Select them and format as values or currency, then they sum normally. Always compare one total against the PDF's printed total before you trust the sheet.

My table has cells with two lines of text. Will it survive?

Mostly, with a tidy-up. Multi-line cells and headers spanning several columns are the cases where a value can land in the wrong column. The fix is quick: sort each column once and move anything that landed out of place. Simple, well-aligned tables convert cleanly.

Is my statement uploaded to your server?

No. PDF to Excel runs entirely in your browser — bank statements and invoices are read and rebuilt on your own device, and never leave it.

My PDF has several tables on a single page. What happens to them?

They land together. The converter writes one worksheet per page of the PDF, so tables that share a page share a worksheet, in their positions on that page. The tidy-up is quick: check where each table starts and ends, move a block that landed against the wrong header, and run the totals check per table rather than once for the whole sheet.

How PDF stores text — and why converters rebuild rows and columns from text positions — is general document technology. Tool behaviour is from PDFJadoo's own PDF to Excel page, including its honest note that scanned PDFs have no text layer. Checked 10 November 2026.

Keep reading