Free tools

Categorize bank transactions from a CSV

Drop in a bank or credit card CSV and every transaction is sorted into a spending category, with a chart of where the money went and a downloadable CSV that includes a Category column. It runs in your browser and works with most US bank exports.

Your file stays on your device. It is read and sorted in this tab and never uploaded.

Or paste CSV text
Made-up transactions and merchants.

One per line, as keyword = Category. Your rules run before the built-in ones.

How to use it

  1. Export transactions from your bank or card as a CSV (most banks put this under Statements or Download transactions).
  2. Drop the file into the box, or paste the CSV text. Try the sample data first if you just want to see how it works.
  3. Read the category chart, check the list for anything left as Other, and add a rule like local hardware = Home projects to fix it.
  4. Download the categorized CSV or the category totals to use in a spreadsheet.

What the categories mean

Categories come from keyword matching on the description your bank prints, so a charge from a merchant with an unusual name lands in Other until you add a rule for it. Card payments, transfers and savings moves are excluded from spending, and refunds and paychecks count as money in. ATM withdrawals land in Cash, and bank fees and card interest in Fees and interest.

A CSV is frozen on the day you downloaded it. Next month means another export, another upload and the same rules typed again, which is where a live connection to the account helps.

Questions

How do I categorize bank transactions from a CSV?

Export your transactions from your bank or card as a CSV, drop the file into the box above, and each line is sorted into a category such as groceries, dining out, utilities or subscriptions. You can then download the result as a new CSV with a Category column.

Which CSV formats work?

Most US bank and credit card exports: a header row with a date, a description and either one signed amount column or separate debit and credit columns. Dates like 01/31/2026, 2026-01-31 and Jan 31, 2026 are all read. If your bank shows charges as positive numbers, the tool detects that from paychecks and deposits in the file, and you can flip it with the checkbox.

How does it decide the category?

It matches words in the description against a built-in list of merchants and terms, for example grocery chains, gas stations, streaming services and utility providers. The first match wins, and anything it cannot place is labeled Other so you can see exactly what is left.

Can I fix a category it got wrong?

Yes. Type a rule in the Your own rules box, one per line as keyword = Category, for example local hardware = Home projects. Your rules run before the built-in ones and the results update as you type. Use a built-in name like Groceries to merge into that category, or invent a new one.

Are transfers and paychecks counted as spending?

No. Card payments, Zelle and Venmo moves and transfers between your own accounts are left out of the spending totals so the same money is not counted twice. Paychecks, deposits and refunds are listed separately under money in. A bill paid on autopay, such as a phone or internet bill, still counts as spending in its own category.

Does my file get uploaded?

No. The file is read and sorted in your browser tab. Nothing is sent to a server, and closing the tab clears it.

Skip the CSV export

Same idea, but automatic and always current once the bank is connected. Connect your bank to Claude or ChatGPT and ask it about your real accounts any time.

“Break down my spending by category for the last 3 months and flag anything unusual.”

Read-only access for Claude, ChatGPT, Cursor and other MCP apps. Nothing stored. $5 a month per connected bank.

More free tools

All free tools