Interview ModeInterviewAdvanced

How would you test an import from Excel/CSV?

Scenario

An admin tool imports customers from Excel or CSV. Users upload a file, map columns, preview rows, fix validation errors, skip or update duplicates, and commit the import as a batch.

What would you test?

List checks, risks, edge cases, data conditions, and user experience concerns you would cover.