Importing

The data importer takes the spreadsheet your customer already has — CSV, TSV, an Excel workbook or JSON — and turns it into clean, checked rows for your application, without the file leaving the browser. Drop a file or paste rows; the importer finds the separator, the encoding and the heading row, and matches the columns to your fields by name, by the names you say they also go by, and by what the values look like.

Every value is read into its field's type — dates day-first or month-first, numbers with either decimal mark, yes/no, emails, list values by name — and checked against your rules. Problems are marked in a grid of only the rows in view, to fix in place, with duplicates found and bad rows removed in one go, and undo. Then your page gets the records, and can say no.