A CSV importer is often the first feature a customer uses with real business data. If it returns only 'invalid file,' staff must guess which records need repair. A useful importer explains its interpretation before writing and returns corrections in terms the data owner recognizes.
Related service: Custom software development- 01Confirm the file format and column mapping.
- 02Preview interpreted values and matching records.
- 03Validate required data and business rules.
- 04Commit only the agreed import scope.
- 05Return counts, errors and correction instructions.
SECTION 01
Show how the importer reads the file
Define whether the file has a header, which separator and encoding are accepted, and how dates, empty fields and leading zeros behave. RFC 4180 describes common CSV conventions, including quoted fields, but it is not a universal guarantee that every spreadsheet export has the same format.
Ask the agency to preview identifiers, names and a representative awkward value such as a comma inside a company name. Keep external reference codes as identifiers when appropriate instead of turning them into numbers. A dry run should also identify duplicate matches and missing related records. Parsing valid CSV and accepting valid business data are different checks.
SECTION 02
Illustrative example: an equipment register
Imagine an operations team imports 80 equipment records. One serial number begins with zeros, a description contains a line break, and three rows refer to an unknown location. The preview should preserve the serial identifier, display the multiline description correctly and identify the location references that need correction.
The team chooses an all-or-nothing import because incomplete locations would make the register confusing. Nothing is written until the three rows are corrected. A different workflow could accept valid rows and return rejected ones, but that choice must be explicit. This example illustrates an import policy, not a claim about a completed customer migration.
SECTION 03
Make the correction loop part of the scope
A bounded first release can support one documented template and one matching key. Automatic recognition of arbitrary spreadsheets is a different, larger feature. Existing software import tools may already meet the need if their errors, rollback and permission checks are adequate. Test with a real, appropriately sanitized sample before replacing them.
Require an error summary with record identifiers, field names, understandable reasons and suggested corrections, following accessible validation principles from W3C WAI. Test missing headers, quoted commas, empty required cells, ambiguous dates, oversized files and duplicate identifiers. Re-import the corrected file and verify final created, updated, skipped and rejected counts. Restrict downloaded error files because they can contain the same sensitive data as the source.
SECTION 04
Frequently asked questions
Should valid rows import when other rows fail?
Choose deliberately. Partial acceptance can help independent records; related records may need all-or-nothing handling. The preview and result must make that policy clear.
Can a file that opens in Excel still fail?
Yes. Spreadsheet applications interpret values and formats differently. The importer needs a documented format and a preview of the values it will actually use.
What makes an error report useful?
It identifies the record and field, explains the failed rule and provides a correction path. It also shows whether any data was written before the error.
PRIMARY REFERENCES
Sources and further reading
These references cover the standards, platforms, or published prices discussed in the guide. Worked examples and checklists are our editorial guidance.
- Common CSV format conventionsIETF Datatracker
- Accessible form validationW3C WAI
EDITORIAL METHOD
About this guide
We use AI to assist with drafting and editing. Catapult AI Work is responsible for the published content. Examples illustrate possible approaches; they are not client case studies unless identified as such.
Budget examples are not Catapult package prices. Check linked provider pages for current fees and plan limits before making a purchase.
Read the editorial policy