Interview ModeInterviewAdvanced

How would you test an import from Excel/CSV?

Scenario

Your interview prompt

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 flows, risks, edge cases, data conditions, UX, security, API/backend, and performance concerns.

Tip: a stronger answer usually mixes happy path, negative cases, state changes, data, backend, UX, accessibility, and risk.

How to structure your answer

Happy pathNegative casesData rulesSecurity/API risksUX/performance