In this article
You have a bank statement, an invoice list or a marks report as a PDF, and you want it in Excel so you can add, sort or filter it. Copying from the PDF and pasting usually gives one messy column. The PDF to Excel Converter does better, because it rebuilds the table from where each word sits on the page. It is not magic, though, and knowing how it thinks tells you why a column sometimes lands in the wrong place and how to fix it in one click.
Why a PDF table is not really a table
A Word or Excel table knows its own rows and columns. A PDF does not. It only stores instructions such as “draw the word “Salary” at this spot, and draw “52,000” at that spot”. The neat grid you see is just words and lines placed in the right positions. So any tool that reads a PDF has to guess the table by looking at where the words are.
That guess is a good one when the PDF was made by software from a real table, like most bank statements, GST reports and school mark sheets. It is a weak one when the layout is loose, centred or mixed with pictures.
- 1Read every word and its positionFor each piece of text, the tool notes how far across and how far down it sits on the page.
- 2Group words into rowsWords at almost the same height (within a few points) are treated as one line.
- 3Join nearby words into cellsWords closer together than the column-detection gap are glued into one cell, so “Opening Balance” stays together.
- 4Line the cells up into columnsCells that start at about the same distance from the left edge fall into the same column.
- 5Save as a sheetYou get an .xlsx file, or a .csv, named after your PDF.
Rows follow height and columns follow left edges. Most problems come from words that do not line up neatly on those two things.
How to convert, step by step
- Open the PDF to Excel Converter and choose your PDF.
- Pick Output: Excel (.xlsx) for a ready spreadsheet, or CSV for a plain text file that every program reads.
- Pick Pages: all pages on one sheet, or one sheet per page (Excel only).
- Leave Column detection on Normal for the first try.
- Leave Turn numbers into real numbers on unless your PDF has long identifiers (see below).
- Press Convert to Excel, then download. The note under the result tells you how many rows were found, and reminds you to check the sheet.
If your PDF is longer than 100 pages, split it first with the Split PDF guide or pull out only the pages with the table using Extract PDF Pages.
Which Column detection should you choose
This one setting decides how close two words must be to count as one cell. It is the first thing to change when the result looks wrong.
| Setting | Words closer than this stay together | Use it when | Typical problem it fixes |
|---|---|---|---|
| Tight (many small columns) | 6 points | A neat table with narrow gaps between columns | Two columns glued into one cell, like a date and a time |
| Normal | 12 points | Most statements and reports | Start here |
| Loose (fewer, wider columns) | 22 points | Text that is spaced out or split into many tiny cells | A name or address broken into three columns |
A point is 1/72 of an inch. The three numbers are small steps, so changing the level slightly changes where cells break. Try the neighbouring setting, not the extreme one.
What “Turn numbers into real numbers” does
Text in a PDF is just text. “52,000” is the characters 5, 2, comma, 0, 0, 0, so Excel would treat it as a word and refuse to add it up. With this option on, the converter changes cells that look like numbers into actual numbers, so SUM, sort and filter work straight away.
| In the PDF | In the sheet | Why |
|---|---|---|
| ₹1,24,500.50 | 124500.5 | Currency sign and commas are removed, Indian grouping included |
| $2,450 or £99.99 | 2450 or 99.99 | Dollar and pound signs are removed too |
| 12% | 0.12 | Percent becomes a fraction. Format the cell as Percentage in Excel to see 12% |
| -350 | -350 | A minus sign is kept |
| 1 200 | 1200 | A space inside a number is removed |
| 007 | 007 (text) | A leading zero means it is a code, so it is left as text |
| 2026-10-23 | text | Dates are left alone, so use Excel’s Text to Columns or date format |
| (1,200) | text | Brackets for negatives are not converted, so replace them yourself |
| 12:30 | text | Times are left alone |
The cell is changed only when the whole value is a plain number. Anything with letters, extra symbols or a leading zero stays exactly as it was.
Scanned PDF: why you get “No text was found”
There are two very different kinds of PDF. A text-based PDF, such as a statement downloaded from a bank’s website, contains real words. A scanned PDF is a photograph of paper, so as far as the computer is concerned it has no words at all, only a picture. The converter can only read words, so for a scan it stops with a message that the file looks scanned.
- You can select and copy a word with your cursor
- Downloaded from a bank, GST portal or office software
- Rows and columns are rebuilt from positions
- Selecting text selects nothing, or the whole page
- Made by a scanner or a phone camera
- Needs OCR first, and tables may still need typing
A simple test: open the PDF and try to highlight a single word. If you can, it is text-based.
For a scan, OCR turns the picture into text (see the OCR guide for how). OCR gives you text, not a table, so expect to arrange it in columns yourself. Document pages you photographed are better scanned with the Document Scanner first, so the text is straight and clear. If the PDF is locked with a password, unlock it first with the Unlock PDF guide.
Why the sheet looks wrong, and the fix
Every one of these is a result of rebuilding a grid from positions. They are normal, and each takes a minute to fix in Excel.
Excel or CSV, one sheet or many
| Choice | Pick it when | Good to know |
|---|---|---|
| Excel (.xlsx) | You will work with the numbers in Excel or Google Sheets | Sheet is named “PDF data”, or “Page 1”, “Page 2” and so on |
| CSV (.csv) | You will import it into another program, a database or a script | Always one block of rows. The file has a marker at the start so Excel reads ₹ and Hindi correctly |
| All pages on one sheet | You want to sort, filter or total the whole report | Header rows from each page come along |
| One sheet per page | Each page is a separate section, such as one class per page | Excel only. CSV is always a single list |
If you are going to feed the data to a program, CSV to JSON and JSON to CSV explain the format traps that matter. If what you really need is editable text and not a table, PDF to Word is the better route.
A 10-minute cleanup routine in Excel
- 1Compare the totalsAdd up one column in Excel and compare it with the total printed in the PDF. If they match, the numbers came through correctly.
- 2Fix the headerDelete the repeated heading rows and keep one header at the top.
- 3Merge broken rowsJoin any record that was split across two rows.
- 4Set the formatsMake dates real dates, percentages real percentages, and IDs text.
- 5Save a copyKeep the original PDF next to the sheet, in case you need to check a figure.
Step 1 is the most important. A matching total is the best proof that nothing was lost or misread.
Questions people ask
How do I convert a PDF to Excel for free?
Open the PDF to Excel Converter, choose your PDF, pick Excel (.xlsx) as the output and press Convert. It works on text-based PDFs of up to 100 pages and runs in your browser, so the file is not uploaded.
PDF se Excel kaise banaye?
PDF to Excel Converter kholiye, PDF chuniye, Output mein Excel (.xlsx) rakhiye aur Convert dabaiye. Text wali PDF ke table rows aur columns mein aa jate hain. Download ke baad totals ko original PDF se milakar dekhiye.
Why does it say no text was found?
Your PDF is probably scanned, meaning it is a picture of paper with no real words in it. The converter can only read text-based PDFs. Run OCR on the pages first, then arrange the text into columns.
Why are my columns in the wrong place?
PDFs store word positions, not tables, so columns are guessed from where words start. Centred or right-aligned text can drift. Change Column detection to Tight or Loose and convert again.
Why are some numbers still text in Excel?
Only plain numbers are converted. Values with brackets, letters, dates, times or a leading zero are left as text on purpose. Check that the option is on, and fix the rest with Find and Replace or Text to Columns.
Can it convert a bank statement PDF to Excel?
Yes, if the statement is text-based, which downloaded statements usually are. Remove repeated headers afterwards, merge any wrapped lines, and compare a column total with the printed total. Turn off number conversion if you want account numbers kept exactly.
What is the difference between Excel and CSV output?
Excel gives you a spreadsheet ready to open, with one sheet or one sheet per page. CSV is a plain text list that any program can import, and it is always a single block of rows.
Is my PDF uploaded anywhere?
No. The file is read in your browser and the result is created on your device. That is useful for statements and invoices, but you should still delete downloaded copies you no longer need.