PDF to Excel
Turn the tables in a PDF into an Excel spreadsheet.
Your file is uploaded securely, converted, then deleted right away.
How it works
- Choose your files.
- Adjust the settings if you like.
- Download the result, or send it to another device with BroAllDone.
PDF to Excel: get the table out without retyping it
Six months of bank statements, 40 transactions a page, and your accountant wants them "in a spreadsheet, please". Copy and paste from the PDF gives you one long column of jumbled text. Retyping takes an evening, and you'll swap two digits somewhere in March.
A PDF to Excel converter does the boring part. You give it the PDF, it finds the tables and writes each value into its own cell of an XLSX file, with amounts as real numbers that a SUM formula understands. What follows is how it reads your tables, where it guesses, and how to tidy the few things it gets wrong.
How does PDF to Excel conversion find tables?
A PDF doesn't know it contains a table. It stores "this word, at this spot, in this font", nothing more, so the table has to be rebuilt from two kinds of clues.
Drawn lines. If the table has borders or shaded rows, those lines mark the cells exactly. These are the most reliable: merged cells stay merged in Excel, shaded cells keep their fill colour, and the borders come across too.
Text lined up in columns. Many bank statements have no lines at all, just columns of text that line up. Here the converter treats each column of aligned text as a spreadsheet column and each line as a row. When a description wraps onto a second line (a long merchant name, say), that line joins the row above instead of becoming a row of its own.
Everything around the tables, like the bank's name, your address or a note at the bottom, goes into its own rows above or below the table, so nothing on the page quietly vanishes. Logos and pictures are left out.
Will numbers, currency and dates work in Excel?
This is the part that decides whether the spreadsheet is actually useful. Each cell is checked, and anything that reads as a number, amount, percentage or date is stored as a real value with a matching Excel format:
| In the PDF | In the Excel cell |
|---|---|
| 1,250.50 | The number 1250.5, shown with a thousands separator |
| $853.34, £853.34, Rp 1.500.000 or 12,800円 | A real number, formatted as money with the symbol (also € ¥ ₩ ₽ ₺ ৳ 元 원 R$, and codes like Rs, TL, Tk, USD, EUR) |
| ₹1,20,000 | 120000, shown with Indian lakh grouping |
| (450.00) | -450, shown in brackets, the accounting way |
| 12.5% | 0.125, formatted as a percentage |
| 31/03/2026, 2026-03-31, 2026年3月31日, 5 de marzo de 2026, 12 Mar 2026 | A real date you can sort and filter |
| 00123 (an ID or code) | Kept as text, so the leading zeros survive |
| A 16-digit card or account number | Kept as text, so Excel doesn't round it |
European numbers like 1.234,56 are recognised too. The converter looks at how the whole document writes its numbers and picks the decimal mark from that, and whole amounts with dots as thousands separators, like 250.000, come through as 250000 even when nothing else on the page has decimals. Month names in English, French, German, Spanish, Portuguese, Indonesian, Turkish and Russian work in dates. A short dotted date like 26.03.31 is read day-month-year on this page.
Dates like 03/04/2026 are the tricky ones. Each column is read day-first unless that column contains a date that only makes sense month-first, like 04/23/2026. A US statement where every date in a column happens to fall on the 12th or earlier will be read the European way, so give dates a quick look.
How to convert a bank statement PDF to Excel
Most statements run over several pages, and you want one long list, not one block per page. When a table carries on from one page to the next with the same columns, the converter adds it to the same sheet, and if the next page repeats the column titles, that repeated header row is dropped. Sheets are named after the pages they cover, such as "Page 1" or "Pages 2-5".
That join only happens when the table starts the new page. If your bank prints a summary box or a "continued" banner above the table on page 2, that page gets its own sheet, and you'll copy its rows under the first table yourself.
To run it:
- Tap Choose a PDF, or drop the file on the box. Files up to 50 MB and 300 pages work.
- Tap Convert to Excel. A percentage counts up while the file uploads, then the page switches to "Converting…".
- Tap Download. statement-march.pdf comes back as statement-march.xlsx. On phones that support it, Share sends it straight to Excel, Google Sheets or email.
Can you convert a scanned PDF to Excel?
Yes, within reason. If a page is only a picture (a scanned statement, a photographed invoice), it's run through OCR, text recognition, before the tables are found. Table lines are looked for in the scan itself, so a ruled table on paper can still become real cells. Crooked or sideways scans are straightened first. If your scanner already added a hidden text layer, that text is used.
The catch: OCR is weakest on digits, the very thing you need. A smudged 8 becomes a 3 and Excel won't complain, so check totals against the paper. Up to 100 scanned pages are read per file; for a bigger scan, split it with Split PDF first. This English page reads scans as English. Statement in Hindi, Spanish or Arabic? Pick that language in the footer menu before converting; each language version of the site reads its own script plus English.
How to clean up a PDF table in Excel
Even a good conversion usually needs five minutes of tidying. These fixes cover most of it.
Two values stuck in one cell. Sometimes a date and a description, or an amount and "Cr", land together. Select the column, then Data → Text to Columns, choose Delimited, tick Space (or whatever separates them), and Excel splits them into neighbouring columns. Insert an empty column to the right first so nothing gets overwritten.
Amounts that won't add up. If SUM gives 0, those cells are text. Common causes: a trailing minus (450.00-), "Cr" or "Dr" glued to the number, or a currency word the converter doesn't know. A word standing alone in a cell, like "TL", also stays text. Use Find and Replace (Ctrl+H) to remove " Cr" and the like, then Text to Columns → Finish on the column, which makes Excel re-read the cells as numbers. For trailing minus signs, Text to Columns has an Advanced button with "Trailing minus for negative numbers".
Dates the wrong way round or stuck as text. Dates printed without a year ("31 Mar") or with a two-digit year after a month name ("31-Mar-26") stay as text. Text to Columns again, and on step 3 pick Date with the right order (DMY or MDY).
Header rows repeated in the middle. If a page's titles weren't recognised as a repeat, they show up as an extra row partway down. Turn on Data → Filter, filter the first column for the header word (like "Date"), delete those visible rows, and clear the filter.
Number formats. Select a column, press Ctrl+1 and pick Number, Currency or Accounting. The values underneath stay the same.
PDF to Excel limitations worth knowing
- Tables with no lines and uneven spacing are the hardest case. Columns can end up split or merged, especially when one column's text runs close to the next.
- Charts come across as nothing. The numbers behind a chart in a PDF aren't stored as data, only as a drawing.
- Running headers and footers that repeat on every page, like a bank's address line or "Page 3 of 6", are usually left out of the spreadsheet.
- A password-protected PDF gives "We couldn't convert this file. It may be damaged or protected with a password." Remove the password with Unlock PDF first. A damaged file may open again after Repair PDF.
- "No tables or text found" means there was nothing readable on any page, often a scan that couldn't be read.
- Long scans can hit "This file took too long to convert." Smaller pieces fix it.
One safeguard runs on every file: the converter checks that the PDF's words reached the spreadsheet. If too many went missing, it tries a simpler table reader and keeps whichever result lost less.
Is it safe to convert a bank statement PDF online?
You should know exactly where a statement goes. This converter runs on our server, not in your browser, so your PDF is uploaded over an encrypted connection. It sits in a temporary folder while it's converted. That folder, with your PDF and the spreadsheet, is deleted as soon as the result has been sent back. The conversion service has no route to the internet, there's no account, and nothing is kept or looked at.
If a document must not leave your device at all, don't upload it here or anywhere. PDF to Text runs entirely in your browser and gets you the raw text, which you can paste into a sheet and split with Text to Columns.
Other ways to get data out of a PDF
- The PDF is mostly paragraphs with the odd table: PDF to Word keeps the text flowing and the tables editable.
- You only need the words, fast and private: PDF to Text.
- You've fixed the spreadsheet and need a PDF to send back: Excel to PDF turns XLSX, XLS or CSV into a print-ready PDF.
Frequently asked questions
How do I convert a PDF to Excel for free?
Choose your PDF, tap Convert to Excel, then Download. The tables become an XLSX file with the same name as your PDF, with no sign-up and no watermark.
Can I convert a bank statement PDF to Excel?
Yes. Statements with or without table lines work, and a table that continues across pages with the same columns is joined on one sheet, with the repeated column titles dropped. Check dates and totals before you rely on them.
Will the numbers work in Excel formulas?
Yes. Amounts like 1,250.50, $853.34 or ₹1,20,000, percentages and dates like 31/03/2026 are stored as real values with matching formats, so SUM, sorting and filtering work straight away.
Why are some amounts stored as text?
Values with a trailing minus (450.00-), "Cr" or "Dr" attached, or an unfamiliar currency word aren't read as numbers. Codes with leading zeros and numbers longer than 15 digits are kept as text on purpose so nothing gets rounded or cut.
Can I convert a scanned PDF to Excel?
Yes. Scanned pages are read with OCR (text recognition) first, and ruled tables are found in the scan itself. Up to 100 scanned pages are read per file, and digits are worth double-checking.
Does it convert tables without lines?
Yes. Text that lines up in columns is rebuilt into rows and columns, and wrapped descriptions join the row they belong to. Tables with uneven spacing are the hardest case and may need some fixing.
Why are my dates the wrong way round?
Numeric dates are read day-first unless a column contains a date that only works month-first. If every date in a US-style column is the 12th or earlier, fix the column with Text to Columns and choose MDY.
Is it safe to upload a bank statement?
Your PDF is uploaded over an encrypted connection, converted, and deleted together with the spreadsheet as soon as the result is sent back. If a file must never leave your device, use PDF to Text, which runs in your browser.
What are the file size and page limits?
Files up to 50 MB and 300 pages. For bigger files, split them with Split PDF or shrink them with Compress PDF and convert in parts.
Why won't my PDF convert to Excel?
Password-protected PDFs can't be converted, so remove the password with Unlock PDF first. "No tables or text found" means nothing readable was on the pages, which usually points to a scan that couldn't be read.
More free PDF tools
- Merge PDF Join PDF files into one document, in any order you like.
- Split PDF Take out the pages you need, or save every page as a separate PDF.
- Organize PDF Pages Put your pages in the right order and keep only the ones you need.
- Compress PDF Shrink big PDFs so they're easier to email and upload.
- OCR PDF Turn scans into PDFs you can search, select and copy.
- Edit PDF Change the text and pictures in any PDF, or add new ones.
- Sign PDF Put your signature on a PDF in seconds.
- Redact PDF Hide private information in a PDF so it can't be recovered.
- PDF to Word Turn a PDF into a Word document you can edit.
- Word to PDF Turn a Word document into a PDF that looks the same everywhere.
- Excel to PDF Turn a spreadsheet into a PDF.
- PDF to PowerPoint Turn a PDF into PowerPoint slides.
- PowerPoint to PDF Turn a presentation into a PDF.
- PDF to JPG or PNG Save the pages of a PDF as images.
- PDF to Text Get the text out of a PDF, ready to copy or save.
- Extract Images from PDF Pull the photos and pictures out of a PDF.
- HTML to PDF Turn a saved web page or HTML file into a PDF.
- Text to PDF Make a tidy PDF from plain text, in any language.
- Compare PDFs Find every difference between two versions of a document.
- Repair PDF Recover everything that can still be read from a broken PDF.
- PDF Page Rotator Turn sideways or upside-down pages the right way up.
- Crop PDF Trim pages down to just the part you need.
- PDF N-up & Booklet Save paper with several pages per sheet, or make a folded booklet.
- Delete PDF Pages Remove the pages you don't need from a PDF.
- Remove Blank Pages from PDF Find the empty pages in a PDF and take them out.
- Watermark PDF Add a text or logo watermark to every page.
- PDF Page Numbering Number the pages of any PDF, exactly where you want them.
- PDF Header & Footer Put a title, date or page numbers at the top and bottom of every page.
- PDF Bates Numbering Number every page of a document set for legal and audit work.
- Protect PDF with a Password Lock a PDF with a password.
- Unlock PDF Remove a PDF's password and restrictions.
- PDF Metadata Editor Change or remove the hidden details stored in a PDF.
- Images to PDF Put your photos or screenshots into a single PDF, in the order you want.
- Scan to PDF Photograph each page with your phone, and get one tidy PDF.