To get a bank statement to CSV, first check whether your bank offers a CSV download for the account. If it does, use that. If you only have a PDF, convert it so each transaction becomes one line with a date, description, amount and balance, then save it as plain text with commas between fields.
Does your bank already offer a statement CSV download?
Many banks do, so look before you convert anything. Online banking often has an Export or Download option on the transactions screen with CSV among the formats. If it covers the dates you need, it is the fastest route, because it skips conversion entirely.
Where to look
Open the account's transaction list and look for a button labelled Export, Download or a small arrow icon. Pick CSV, choose the date range, and save the file. Some banks put it under the same menu as the PDF statements. Others offer it only for the recent past.
Why the bank's CSV is sometimes not enough
A bank CSV is useful but has limits worth checking before you rely on it:
- Short history. The export may reach back only a few months, while the PDF statements go back years.
- No balance column. Many exports list date, description and amount, and leave out the running balance, so you lose the best way to check the data.
- Different from the statement. The export is a view of the transaction screen, so pending items may be included or posting dates may differ from the official statement.
- Odd layouts. Header lines above the table, extra summary rows, or one column per sign are all common.
If the CSV has the range, the columns and the balance you need, use it and move on. If not, the PDF statement is the official record, and converting it gives you the same four fields from a source that matches the paper. If you would rather work in a spreadsheet than a CSV, a PDF bank statement as an Excel transaction list covers that route.
Converting when you only have a PDF
When there is no CSV option, a converter reads the PDF and writes the transactions out. FastBankConvert takes a statement PDF and returns Excel, CSV or JSON, so you pick CSV at the download step. It is getting ready to open, and you can get started to be told when trial conversions are available. For converters in general, what a bank statement converter does with your PDF explains the steps.
CSV columns for bank statement transactions
A bank statement CSV should have one header row and four columns: Date, Description, Amount and Balance. Name the columns in plain words, keep one transaction per line, and use one signed amount column. That layout loads into most spreadsheets and budgeting tools without mapping.
The header row
Use a single header row at the top, with no title lines above it. Short names without punctuation are safest:
Date,Description,Amount,Balance
Some import tools ask you to map your columns to theirs, and they match more reliably when names are plain. Do not put a blank line between the header and the data.
What goes in each column
- Date. One format throughout, discussed in the next section.
- Description. The payee text from the statement, without edits.
- Amount. A number with a dot for decimals, no currency symbol and no thousands separator. Use a minus sign for money out.
- Balance. The running balance after the transaction, in the same number style.
Debit and credit columns
Some tools want separate Debit and Credit columns instead of one signed amount. If yours does, check its import page for the exact header names. Otherwise, one signed column carries the same information with less room for error. The reasoning is laid out in whether debits and credits should share one amount column.
A sample file
This is an example with made-up transactions. It shows ISO dates, a signed amount and a quoted payee that contains a comma:
Date,Description,Amount,Balance
2026-09-02,PAYROLL DEPOSIT,1200.00,4200.00
2026-09-06,"HARBOR HARDWARE, INC",-64.30,4135.70
2026-09-11,CITY WATER BILL,-48.15,4087.55
2026-09-15,RENT TRANSFER,-910.00,3177.55
Read it line by line. The second transaction's name holds a comma, so it is wrapped in double quotes. Every other field is plain. The balance column follows from the opening balance of 3,000.00 plus each amount in turn.
Date formats in a bank statement CSV
Use YYYY-MM-DD, such as 2026-09-02, unless the tool that imports the file demands another format. This ISO format has one reading everywhere, sorts correctly as text, and cannot be mixed up between month and day.
Why MM/DD/YYYY causes trouble
A date like 03/04/2026 means March 4 in the United States and April 3 in much of the world. A program that guesses the wrong order will either swap the day and month or, for dates such as 03/25/2026, fail on the impossible month. The failure is quiet in the first case: the file loads, and the dates are wrong.
Statement dates without a year
Many statements print only the month and day. A converter fills in the year from the statement period, and a statement that spans New Year needs the January lines to take the later year. Check the first and last dates in the CSV against the period on the PDF.
Match what the importer wants
Some accounting and budgeting imports require a specific style. If your tool lists one, follow it, and do the change in the CSV once instead of fixing each line later. If the tool accepts several, ISO is the safest. Write all dates in the file in the same format and never mix two.
Commas in payee names and other CSV quoting traps
A comma inside a payee name shifts every later column unless the field is wrapped in double quotes. CSV uses commas to separate fields, so a name like HARBOR HARDWARE, INC reads as two fields. Quote any field that contains a comma, a quote mark or a line break.
The quoting rules
Three rules cover almost every case:
- Wrap a field in double quotes when it contains a comma, a double quote or a line break.
- Inside a quoted field, write a double quote as two double quotes. The description
5" PIPEbecomes"5"" PIPE". - Never put spaces between a comma and an opening quote.
Quoting a field that does not need it is allowed, so a tool that quotes every text field is safe.
Symptoms of a quoting problem
You can spot a quoting failure from the output. Columns shift to the right on some rows only. The amount column holds text on lines with commas in the payee. A row ends up with five fields instead of four. If you see any of these, find the first affected row and compare it with the PDF.
Other traps
- Line breaks in descriptions. A wrapped description should be joined into one line, or quoted.
- Thousands separators. 1,200.00 with a comma inside an unquoted amount creates an extra field. Write 1200.00.
- Semicolon-separated files. Some regions use semicolons as the separator because the comma is the decimal mark. If a file seems to be a single column, check which separator it used.
- Encoding. Names with accents need UTF-8. A tool that misreads the encoding turns them into odd symbols.
When a CSV looks wrong, a text editor shows the real contents, with no spreadsheet reformatting on top.
How do you open a statement CSV without Excel changing it?
Import the file instead of double-clicking it. In Excel, use Data, then From Text/CSV, and set the columns that need protecting to Text. Double-clicking applies automatic conversions that can change dates and strip leading zeros from long numbers, and a saved file keeps the change.
What Excel changes by default
When Excel opens a CSV directly, it guesses each column's type. It turns 2026-09-02 into a date that it displays in your regional style. It turns long digit strings, like an account or reference number, into scientific notation or cuts leading zeros. It may read a description that looks like a date, such as 3-4, as a date. If you then save the file, those changes are written back.
Open it safely
- Open a blank workbook, not the CSV itself.
- Choose Data, then From Text/CSV, and pick the file.
- In the preview, check the delimiter and the encoding.
- Choose Transform Data, or set the column type for any reference column to Text.
- Load the result.
Google Sheets and other tools have similar import dialogs. Look for a way to set a column to plain text before the data is loaded.
Keep the original untouched
Treat the CSV as the source file and do your editing in a copy saved as XLSX. That way, if a conversion went wrong, the original is still exact. To decide when to keep a spreadsheet format instead, see the difference between XLS, XLSX and CSV.
Before you import elsewhere
Open the file in a text editor and check the first five lines against the PDF. Then try the import with a small slice. If the sample loads with the right dates and amounts, load the whole file. If the statement came from a credit card, the sign convention is different, and exporting a credit card statement to Excel explains it. For how software finds the rows in the first place, see how a bank statement parser reads a layout.