Copy a table from a PDF into Excel without retyping it

There is a table in a bank statement or salary PDF and you need to calculate with those figures. You select it, copy, paste into Excel, and every value lands in a single cell in column A. Here is why, and how to get real columns instead.

Ashton
How-to

The usual case: your bank statement PDF has three months of transactions and you need them in Excel for a loan file, a GST reconciliation or just a household budget. Or a salary statement or Form 16 style table needs adding up. You select the table, copy, paste into Excel, and every value lands in column A. Splitting it by hand is slow, and one slip puts a debit in the credit column.

Knowing why that happens usually saves you from the retyping.

Why everything pastes into one column

Because there is no table inside the PDF. The file holds instructions like print 1,204 at x 220, y 540, and nothing records that this value was the third row of the second column. That structure is discarded the moment a document is exported to PDF.

So the copy function simply strings characters together in the order it sees them. The gap between one cell and the next is not a tab or a comma, just a difference in coordinates, which gives the receiving application nothing to split on.

This one fact explains the rest. Rebuilding a table means reading where values sit rather than reading lines or tags, and reading position is always an inference.

When numbers arrive as text

Even when the cells split correctly, Excel often refuses to treat the values as numbers. A PDF does not record whether something is a number or a label, so it is carried across exactly as it appears. Most cases clear up with a couple of steps in Excel.

If it arrived like thisCause and fix
1,25,000 sitting left alignedThe commas make Excel read it as text. See the next section for Indian digit grouping
₹18,40,000 will not add upA currency symbol leads the value. Remove the ₹ sign and the commas, then set the cell format to currency or number
(1,204) or 1,204 Dr not treated as negativeAccounting style puts negatives in brackets, and statements often add Dr or Cr. Remove the brackets or the suffix and prefix a minus sign for debits
38% is not 0.38It is text with a percent sign attached. Remove the sign and set the cell format to percentage
A reference number turned into a dateThe opposite problem: Excel guessed too eagerly. Format the column as text before pasting
A cheque or reference number turned into a date or lost its leading zerosExcel guessed too eagerly. Format the column as text before pasting

When cells shift by one column

Empty cells cause this. An empty cell leaves no trace in a PDF at all: there are no characters, so there is no instruction to print any. That row therefore looks like it has one cell fewer, and everything after it slides across by one.

PDF to Excel result preview with the table split into cells
The PDF table lands in spreadsheet cells.

A converter reduces the problem by dropping each value into the column nearest to it, but tables with very narrow column gaps can still come out misaligned. Merged cells behave the same way. Your eye sees two cells joined; the file contains one piece of text sitting slightly further left than its neighbours.

Which PDFs work well

How the original was produced decides the outcome.

  • Works well. A table built in Excel or Word and exported to PDF. The columns stand square, so position alone is enough to split the cells.
  • Mixed results. Reports laid out in publishing software, where centred text and indents make the left edge of a column wander.
  • Does not work. A scanned PDF. Every page is a photograph and holds no text at all to extract. No tool can get around that.
  • Watch out for. Long tables spanning several pages. The header repeats on each page, so delete the duplicate header rows after converting.

Bank statement PDFs: password first, then the table

Statements sent by banks by email are very often password protected, usually with something built from your name, date of birth or customer ID as described in the bank's email. A converter that does not have the password cannot read the numbers. So open the file with the password you were given, remove it, and work on the unlocked copy. Our guide on removing a PDF password you know explains the steps, and Remove PDF password does it in the browser.

Then convert. PDF to Excel reads where each value sits on the page and splits the table into cells, one sheet per page, so a 6-page statement gives you 6 sheets. Lines that are not part of the table, like the account summary at the top, are kept one per row so you still know what the figures are. It all happens in your browser; the statement does not leave your device.

  • Delete the repeated header row on each sheet, then copy the sheets one below the other.
  • Check that debits and credits stayed in their own columns. Statements with an empty debit or credit cell are exactly where a one-column shift happens.
  • Check the closing balance (see the last section).

If your accounting software or a bookkeeper wants CSV rather than XLSX, save the cleaned sheet as CSV, or use Excel to CSV.

Amounts with commas like 1,25,000

Indian statements and salary tables group digits the Indian way: 1,25,000 rather than 125,000, and 12,34,567.50 for twelve lakh. When this arrives in Excel from a PDF it is usually stored as text, so SUM ignores it or returns 0.

  • Select the amount column, press Ctrl+H, find "," and replace with nothing. Do the same for "₹" and any spaces.
  • If the cells still sit on the left, use Data > Text to Columns > Finish on the column, or put =VALUE(A2) in a spare column and copy it back as values.
  • For "Dr" and "Cr" suffixes, split them into their own column first with Text to Columns, then turn the Dr rows negative.
  • Only then apply a number format. Excel can show Indian grouping again through a custom format, but the cell underneath must be a number.

Do the cleanup in this order. Applying a number format to a cell that is still text changes nothing, which is why many people think the format did not work.

Always check the numbers afterwards

Moving a table involves inference, which means it can fail quietly. A missing value or a one-column shift still looks perfectly tidy on screen.

If the statement has an opening and closing balance, that is your best check: opening balance plus credits minus debits should give the closing balance. For other tables, sum the same column in Excel and compare it against the printed total. With no totals at all, at least count the rows. That single check costs far less than a loan file or a tax return built on the wrong figures.

Common questions

Why does everything paste into one column?
A PDF has no table inside it, only text placed at positions on the page. Copy strings the characters together with no tab or comma between cells, so Excel has nothing to split on. A converter that reads positions, or Text to Columns on the pasted data, gets the columns back.
How do I convert a bank statement PDF to Excel?
Remove the password with the password you have, convert the unlocked copy with PDF to Excel (one sheet per page), delete the repeated header rows, clean the amount columns and check the closing balance.
Can I copy a table from a scanned PDF?
Not by extraction. A scan is a photograph of a page and holds no text, and our PDF to Excel does not read text from images. Download the statement again from net banking as a digital PDF or ask the issuer for the original file.
All my numbers arrived as text.
A PDF does not record whether a value is a number or a label, so it is stored as it appears. Selecting the column in Excel and running Text to Columns once from the Data tab usually converts the whole lot at a stroke.
What about a table spanning several pages?
Each page becomes its own sheet. To join them, copy one sheet below the other and delete the repeated header rows.

Last updated October 14, 2026 · Information as of October 2026.