Latest Post:

What is a CSV file?

Definition

A CSV file stores a table as text. Records contain fields separated by commas, and an optional header names the columns. Quoting allows fields to contain commas or line breaks.

CSV does not preserve spreadsheet formatting, worksheets or formulas. Export settings can also vary between tools, including the delimiter and text encoding.

Why it matters

CSV is a convenient way to move a table between systems because it is plain text and widely supported. Its simplicity also means the file does not carry all the information a spreadsheet or database knows about its values. A customer identifier such as 00127 can be misread as a number, and a date like 03/04/2026 can be interpreted differently between tools.

Before importing an important export, check a few representative rows:

  • Confirm the column headings and delimiter.
  • Check identifiers, dates, decimal values and missing entries.
  • Compare the imported row count and a known total with the original export.

Those small checks help catch problems before they become misleading charts.