North Vault Digital · Practical data hygiene

How to clean a bank CSV export before importing it

Bank exports often look like ordinary spreadsheets until an import rejects the header, date format, delimiter, or debit/credit layout. This checklist helps you inspect a copy safely before the next step.

1. Keep the original export unchanged

Work from a copy. Preserve the original filename, export date, account period, and source system. A clean-looking spreadsheet is not evidence that the rows still reconcile.

2. Check the structure before changing values

• Confirm the delimiter: comma, semicolon, tab, or another separator.
• Find the real header row if the export begins with a title, account label, or report preamble.
• Check that each transaction row has the expected number of fields.
• Look for repeated headers, blank rows, footer totals, shifted quotes, or invisible characters.

3. Review dates, amounts, and signs

Do not silently reinterpret financial values. Record the date convention, currency symbols, decimal separator, and whether money out is represented as a negative amount or a separate debit column. If the destination system requires a specific layout, compare its documented import template with the export before mapping.

4. Check duplicate and missing transactions

Compare date, description, amount, and any available transaction reference. Exact duplicates may be export artifacts, but similar rows can be legitimate recurring transactions. Flag uncertain rows for review instead of deleting them automatically.

5. Validate the cleaned copy

Compare row count, date range, and totals against the original. Keep a short note of every structural change. Import only after the output is readable and the destination software accepts the expected columns.

What this guide does not do

This is a structural-cleanup checklist, not accounting, tax, or banking advice. North Vault Digital does not connect to banks through this page and does not receive the file through the free utility.

Use the free browser utility Inspect the public release

Optional paid package: Bank CSV Normalizer package. Provider checkout telemetry is not available to this page.