Aternex
Book a call

Data import wizard

Bring a messy spreadsheet into a system without losing or corrupting a row.

A working demo for Ledgerline, an invented business. All data is made up and nothing you enter leaves this page.

Ledgerline

Receivables / Import invoices

Bring in a spreadsheet

Paste a CSV export below, or load the sample file invoices-march-export.csv, a made-up March invoice list with the usual mess in it.

The first row must be the column names. Commas, quotes and line breaks inside quoted values are kept.

Try it

  • Load the sample CSV or paste your own
  • Map columns and fix the rows that fail validation
  • Import and read the summary

Under the hood

  • Parsing handles quoted fields, embedded commas and blank lines
  • Every rejected row says which rule it broke
  • Duplicates are caught by a normalized key

Built with React, TypeScript, Zod, Vitest.

The same skill in production work