CSV import preview checklist for small SaaS products

A CSV import preview checklist helps a small SaaS product prevent bad data before it reaches the customer account. The goal is not to support every spreadsheet style. The goal is to show users what will happen, what is wrong, and what they can fix before committing the import.

The first step is header mapping. Users often upload files with “email,” “Email Address,” “contact_email,” or localized column names. A good preview shows which columns were recognized, which columns are required, and which optional fields were ignored. If the product guesses a mapping, the user should be able to correct it before continuing.

The second step is row-level validation. The preview should show examples of invalid rows, not just a count. Missing email, duplicate ID, invalid date, unsupported currency, or text that exceeds a field limit should be visible in plain language. Users need to know whether they can fix one row, remove a small group, or repair the whole file.

The third step is duplicate handling. Many failed imports come from re-uploaded files. The product should say whether duplicates will be skipped, updated, merged, or rejected. If the product updates existing records, the preview should show at least a sample of what will change. Silent overwrites are dangerous for small teams because the person importing may not own the original data.

The fourth step is partial import policy. Some products import valid rows and report failures. Others reject the whole file until every row is fixed. Both choices can work, but the preview must say which one will happen. Users should not discover partial success only after the import finishes.

A practical preview screen includes file summary, mapped columns, error samples, duplicate rule, import count, skipped count, and a final confirmation sentence. The sentence should be specific: “Import 412 contacts, skip 7 duplicates, and reject 3 invalid rows.” That line prevents more support tickets than a generic “Continue” button.

CSV import preview checklist for small SaaS products

// COMMENTS

ON THIS PAGE