How to use the CSV in Excel or Google Sheets
- Download sku-plain.csv from this page.
- Open the file in Excel or Google Sheets.
- Format the SKU column as text before you sort or import.
- The columns are SKU, Product, one column per attribute, and Options.
Worked example
sku-plain.csv from this page uses these columns: SKU, Product, one column per attribute, Options.
The row below is what this page writes for prefix 01, attribute Size value S, and attribute Color value Black. The SKU starts with a zero.
| SKU | Product | Size | Color | Options |
|---|---|---|---|---|
| 01-S-Black | 01 | S | Black | Size: S; Color: Black |
Leading zeros
If Excel or Google Sheets stores 01-S-Black as a number, the cell becomes 1-S-Black. Format the SKU column as text before you sort or import so the zero stays.
Related
FAQ
Is this free?
Yes. You can use this free SKU generator tool in your browser with no account.
Do Excel and Google Sheets keep a leading zero?
No. Excel and Google Sheets drop a leading zero when they store the cell as a number. Format the SKU column as text before you sort or import.