Back to the subscription dictionary

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.

  1. Format

    Agree delimiter, UTF-8, dates and decimals

  2. Content

    Check IDs, currency, status and interval

  3. Sample

    Import a sample and inspect errors

  4. 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.

Sources and documentation

We update our content regularly and do our best to keep it accurate. If you find an error or think something is missing, please tell us. We are always looking for ways to improve the content.

Found an error? Let us know