CSV file
A CSV file is a text file containing tabular data for export and import between systems. CSV means Comma-Separated Values; some systems use related dialects with semicolons. Agree the delimiter, character encoding and interpretation of fields before importing.
Prepared with AIContent updated
Records, fields and quotes
A file can begin with column headers. In comma-separated CSV, a field containing a comma, line break or quote is normally double-quoted, and quotes inside it are doubled. A field can therefore span a line break; counting physical lines is not always enough.
A controlled CSV import
Illustrative transfer of subscription data between two systems.
- Format
Agree delimiter, UTF-8, dates and decimals
- Content
Check IDs, currency, status and interval
- Sample
Import a sample and inspect errors
- Reconcile
Compare counts, totals and duplicates
Opening a spreadsheet does not by itself prove the import is correct.
Agree number and date formats
Some exports use semicolons and decimal commas, while others use commas and decimal points. Agree the format rather than allowing a spreadsheet to guess. Preserve identifiers with leading zeroes as text and use an explicit currency column for multi-currency data.
UTF-8 supports international characters, but the receiving system must read the same encoding. Use an agreed unambiguous date format and include time zones where times matter.
Subscription data needs a measurement definition
Do not sum raw invoice amounts as MRR. The file needs enough information to identify active status, recurring prices, discounts, currency and billing interval. Annual values need monthly normalisation under the chosen policy.
Net customer-count movement alone does not establish churn, because new customers can mask losses. Track customer identifiers and effective end dates within the opening group.
Validate before and after import
Check required fields, duplicates, record counts, totals and error logs. Test a small sample and reconcile the imported result. Automated imports must handle reruns without creating duplicates.
Spreadsheets can interpret text as formulas
CSV does not preserve spreadsheet formatting, but text from untrusted sources can be interpreted as formulas when opened in a spreadsheet. Use explicit data-type imports and an export strategy suited to the actual application. Quoting alone does not solve every case.
Questions and answers
Is CSV the same as Excel?
No. CSV stores text-based table data; an Excel workbook can also contain worksheets, formulas, formatting and other features. The importer decides how CSV values are interpreted.
Why do columns shift?
Check delimiters, quoting and embedded line breaks. The receiving system must use the same dialect as the export.
How do I preserve amounts and identifiers?
Specify decimal format, currency and data type. Identifiers with leading zeroes should normally be treated as text rather than numbers.
