How to Export a CSV from Your Bank and Import It into a Budget Tool
Almost every bank lets you download your transaction history as a CSV file. CSV stands for “comma-separated values”: a plain-text table you can open in a spreadsheet or load into a budgeting tool. Using it saves hours of typing, and it is more accurate than entering purchases by hand.
Where to find the download option
Log in to your online banking on a computer (the full website is usually easier than the phone app). Open the account, look for the transaction history, and find a button labelled something like “Download”, “Export”, or “Download transactions”. Choose CSV (sometimes called “Spreadsheet” or “Excel-compatible”) and pick a date range. Many banks limit how far back you can go, often 90 days to 18 months, so download regularly rather than waiting.
What the file contains
Each row is one transaction. Typical columns are the account type or number, the transaction date, one or two description fields (the merchant name and extra details), and an amount. Some banks use separate columns for money in and money out, some use a single column with negative numbers for spending, and some include separate columns for each currency. Open the file once in a spreadsheet to see which style yours uses before you import it.
Check your date format
The most common import mistake is the date. A date like 03/04/2026 is the 4th of March in the United States but the 3rd of April in most of Europe. Look for a date in your file where the first number is higher than 12 (such as 25/03/2026 or 03/25/2026) to see which order your bank uses, and confirm the import preview agrees. A wrong date order puts spending in the wrong month and quietly ruins your charts.
Avoid duplicates
If you download overlapping periods, you will have the same transactions twice. A good tool skips exact duplicates (same date, description and amount), but be careful with two genuinely identical purchases on the same day, such as two coffees. Check the preview if the count looks off. Downloading from the day after your last import is the cleanest approach.
Categorise once, reuse forever
The first import is the slowest, because every merchant needs a category. Do it properly once by creating rules: for example, any description containing “SHELL” is fuel, and any containing “SOBEYS” is groceries. From then on, new imports sort themselves, and you only look at the handful of new merchants. Keep your rules specific enough to avoid mistakes (“AMAZON” may cover both groceries and gifts) and review the uncategorised rows first.
Handle transfers and card payments
Paying your credit card from chequing shows up as spending in one account and income in the other, plus the card purchases themselves. Count only the card purchases. Mark the payment and any moves between your own accounts as transfers so they stay out of your income and spending totals.
Keep your files private
A CSV contains your real transactions. Store it somewhere safe, delete copies you no longer need, and be cautious about uploading it to tools you do not trust. Budget Dashboard processes the file in your browser and stores the result in your browser, so the file is not uploaded to our servers. You can read how this works in the Privacy Policy.
Ready to try it? Open the app, use the sample data to see how it looks, then import your own file.
This guide is general information for everyday budgeting, not financial, tax or legal advice. Rules, limits and rates change, so check official sources or ask a qualified professional about your own situation.
Published by Budget Dashboard. Questions or corrections? Contact us.