In development — usable.software is not live yet.
Usable.softwareA Balane Tech system
All modules/System coreM03
M03Core· System core

Data import

Move your existing data into Usable effortlessly: upload a file (CSV; just save Excel as CSV), columns and the delimiter are auto-detected, duplicates flagged — then import.

Live preview — real view with sample data

your-address.usable.works
Data import

Not a screenshot: the same interface you get in production.

What you do here

First pick the target module (e.g. Contacts or Vehicles), then upload the file. Without AI, Usable detects the delimiter (including the German semicolon), maps source columns to fields via heuristics, translates option lists (e.g. "open" → status) and resolves references like customer or vehicle by name to an existing id. In step 3 you pick a match field for duplicate detection and see, before importing, how many rows are new, duplicate or incomplete. For Excel, save it as CSV in Excel; a real database connection is handled by the professional migration.

Tips

The first CSV row must contain the column headers. Set columns you don't need to "ignore". If you want it perfect, you can add the professional migration later.

Traceability & law

Every import is logged as a run: target, source, time, counts (new/duplicate/incomplete/error) and who ran it. Because an import almost always moves personal data (contacts, employees, customers, clients), you document the data's origin and the legal basis under Art. 6 GDPR for each run – part of your record of processing activities (Art. 30). Every imported row is tagged internally as "imported" plus the run id. Import health data (Art. 9) only into modules built for it.

Undo & fixing errors

If something went wrong, open the run and roll it back – the imported rows are removed again via the run id. The error report lists every flagged row with its column, field and reason; fix the source file and import again. That keeps the import repeatable without piling up duplicates.

What's inside

  • Data import
  • Import runs
  • Import run
  • Roll back import
  • Delete log