What is Comma-Separated Values (CSV)

CSV (Comma Separated Values) files are plain text files that store data in a table format, using commas to separate each field, making it easy to import and export between tools.

A brief history

Originally developed as a straightforward way to represent rows and columns in plain text, CSV became a common data format as spreadsheets and databases gained popularity. Because it was easy to generate, read, and process across platforms, it quickly became a standard for data exchange. Decades later, it’s still widely used for everything from importing product data to syncing large datasets between tools.

Good to know

CSV files are widely supported across platforms, but not all programs interpret them the same way. Before importing into a tool, double-check settings like the delimiter (comma vs. semicolon), character encoding, and whether headers are included.

Know more

Frequently Asked Questions

When should I use a CSV file?
CSVs are a good option when you need to move tabular data between systems, like exporting product lists from your PIM or uploading inventory into an ecommerce platform. They’re lightweight, widely supported, and easy to open in tools like Excel, Google Sheets, or Notepad.
Why is my CSV file not importing correctly?
There could be a few reasons:Check that your file uses commas (or the delimiter expected by the system, some use semicolons).Make sure headers are formatted exactly as expected by the target platform.Look for extra spaces, missing values, or special characters that might throw off the structure.
Can I include images or formatting in a CSV file?
Not really. CSVs only store plain text and basic data. You can include a link to an image (like a URL), but not the image itself. Formatting like bold text, fonts, or colors won't be preserved.