CSV Guides & Tutorials

Practical guides for creating, editing, converting and managing CSV files.

What Is a CSV File?

The plain-text format explained: rows, columns, headers and why CSV is everywhere.

Four ways to create a CSV — spreadsheet, text editor, code, and AI.

Edit single cells or thousands of rows safely, without breaking the file.

Convert a workbook safely without damaging SKUs, dates or special characters.

When to use a plain CSV and when a spreadsheet is the better tool.

Why imports fail: shifted columns, encoding issues, formula injection and more.

Structure product data — names, SKUs, prices, variants, options — for a clean import.

How the Shopify product export format works and how to convert it.