Netmend · Compare · CSV vs Excel for bank statements
CSV is a plain text table. Excel is a workbook. For bank statements and invoice line items, the plain file is usually the one you should hand to another program — if you can stop Excel from “helping” the dates first.
Defaults are a starting point. Change the number format to match the PDF. The file never leaves your computer.
No file at hand? (fictional data)
Check the totals against the original PDF before you use the file. If a column is in the wrong place, try “Every text row”, or send it to us.
How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.
A CSV (comma-separated values, or semicolon-separated in much of Europe) is a text file. One row per line, one column per field, nothing else — no colours, no formulas, no hidden sheets, no number formats. QuickBooks Online’s official bank upload, Xero’s official CSV bank import, and most “upload a spreadsheet” screens are built around this. Our converter downloads a CSV, not an .xlsx, for that reason.
An Excel workbook (.xlsx) can hold several tabs, formulas, filters and formatting. It is the better file for a human review: a second tab that proves opening + movements = closing, a SUMIF per invoice, a colour on a row that failed the check. It is a worse interchange format, because the next program may not read the formulas, and because Excel itself may have already rewritten “03-09-2026” or “01/02” the last time someone double-clicked the file. Some banks’ “Excel” downloads are actually CSVs with an .xls name (Revolut is a documented example). Always look at the real file type.
The practical habit is: convert or download to CSV, immediately save a working copy as .xlsx, and never do the cleaning in the only copy of the CSV. When the proof tab is clean, File → Export or Save As CSV from the import tab, and upload that. If you open a CSV in Excel to “just tidy the dates”, you are in the danger zone that official import guides keep warning about: a US Excel will turn a UK 05/03/2026 into 3 May, and it will do it silently.
Google Sheets sits in the middle. It imports CSV well if you set the separator and the locale yourself — see PDF invoices to Google Sheets — but it has the same date-locale trap. The converter below gives you the CSV; what you do with it next is the choice this page is about.
Sources (checked 13/11/2026). Official product help is linked in the text. Menus and templates change: treat the current screen in QuickBooks, Xero or your bank as the authority.
The free tool is for a clean, text-based PDF. For scans, password files, a packed year of documents or a layout that has to match QuickBooks or Xero, we convert them and check the totals against each document.
75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.
Need it done for you? From $20Your file is processed only for the order and deleted after delivery. This page itself never uploads the file.
Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.
A CSV in the official 3-column or 4-column layout, or a QBO/QFX/OFX file from the bank. Not a formatted Excel workbook with a proof tab still in it.
A CSV you can map on the official import screen (or, when it is offered, Xero’s own PDF statement import). An .xlsx full of formulas is not the starting point.
It is probably semicolon-separated and Excel expected commas, or the other way around. Use Data → From Text/CSV and pick the delimiter, instead of double-clicking the file.
Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services