Glossary
CSV, or comma-separated values, is a plain-text format for tabular data. It represents records as rows and fields as separated values, commonly with a header naming each column. CSV is widely used to move product data between spreadsheets, PIM and other systems, but a CSV file does not define the business meaning of its columns.
A common CSV convention separates fields with commas and uses quoting where a field contains commas, quotes or line breaks. In practice, software also uses other delimiters and encoding conventions. Sender and recipient must agree how the particular file should be read.
For example, a supplier can provide one row per product with columns for SKU, description, colour and weight. A description containing a comma needs correct quoting so it stays in one field instead of shifting the remaining values into the wrong columns.
CSV does not enforce data types, unique identifiers, units or required fields. Those rules belong to the import specification and validation process. A column called size is still ambiguous until the expected meaning and format have been defined.
Treat product identifiers as text, preserve leading zeros and check whether spreadsheet software has converted long codes or dates automatically. Agree how missing values, multiple values and product removals are represented. Keep the original delivery so an import error can be traced to the file and row that produced it.
Explore practical support for organising, improving and maintaining product information.