Free Tool

Free CSV Column Auto-Mapper and Header Normalizer

Auto-detect common transaction columns from exported CSVs and generate a normalized CSV with standard headers for cleanup and imports.

Tool workspace

Run the tool below, then copy or reuse the cleaned output in your spreadsheet or finance workflow.

  • Paste any transaction CSV with its original headers intact.
  • The mapper detects common date, description, reference, amount, debit, credit, and balance columns.
  • Blank standardized fields stay blank so you can review what the mapper could not infer.

Output

You will see the detected header mapping and a normalized CSV with standard headers: date, description, reference, debit, credit, amount, balance.

Standard fieldDetected source header
dateposted_date
descriptionmerchant
referenceref_no
amountNot detected
debitwithdrawal
creditdeposit
balancerunning_balance

Input stays in your browser. No upload is required for these free tools.

Related free tools