How to Prepare a Product CSV File: Complete Guide

To prepare a product CSV file, start with your target platform’s official column headers, enter one row per product or variant, use UTF-8 character encoding, format prices without currency symbols, and supply direct, publicly accessible image URLs. Keep SKU and barcode numbers formatted as plain text to avoid scientific notation errors.

A Comma-Separated Values (CSV) file is the standard data vehicle for importing hundreds or thousands of products into ecommerce stores. Whether you run a storefront on Shopify or WooCommerce, or manage listings across marketplaces, mastering the structure of a product CSV saves hours of manual catalog entry and prevents failed batch imports.

Free toolExcel / CSV → ShopifyConverts your Excel / CSV product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.Open the tool

1. Download and understand the required platform template

Every ecommerce platform and marketplace expects a specific schema. Column headers are case-sensitive and must match the system’s exact naming convention. Using a generic spreadsheet without matching headers will cause the import engine to reject the file or misplace vital product information.

1. Go to your store backend and download the official sample CSV file.
2. Open the file in your preferred spreadsheet editor (such as Microsoft Excel, Google Sheets, or LibreOffice Calc).
3. Inspect the mandatory column headers. For instance, Shopify requires Handle and Title, while WooCommerce uses ID, Type, SKU, and Name.
4. Keep header names in their original case, spelling, and order without adding trailing spaces.

If you are comparing different spreadsheet formats for your store operations, review the guide on Excel vs CSV for product uploads to understand when to work in a native workbook versus exporting to delimited text.

2. Structure core product identifiers and descriptions

The foundation of any product catalog file is the grouping mechanism that ties titles, descriptions, and categories to a single product record.

1. Define the unique handle or product identifier in the first column. The handle is a URL-friendly, lowercase string using hyphens instead of spaces (for example, organic-cotton-t-shirt).
2. Enter the full product title in the title column. Use standard capitalization and omit promotional flags like “Free Shipping” from the title field.
3. Add product descriptions using clean text or valid HTML markup (such as <p>, <ul>, and <li> tags). Avoid pasting rich text directly from word processors, which often inject hidden formatting tags that break store layouts.
4. Enter the vendor or brand name, and map the product to your target category taxonomy.

3. Configure product variants and attributes properly

When a single product comes in multiple variations—such as different sizes, colors, or materials—each variation requires its own row in the spreadsheet while sharing the parent product handle.

1. Fill in the master product details (Title, Description, Vendor, Tags) on the first row of the item.
2. On the subsequent rows for that same product, repeat the identical Handle value.
3. Leave the Title, Body HTML, and Vendor columns blank on those secondary rows.
4. Populate the Option Name columns (e.g., Option1 Name = Size, Option2 Name = Color) and their respective Option Values (e.g., Option1 Value = Large, Option2 Value = Navy Blue).
5. Assign unique SKU codes, prices, and inventory levels to every individual variant row.

If you are migrating existing catalog data across channels—such as bringing products over from Trendyol (one of Turkey’s largest marketplaces) to Shopify—rebuilding variants by hand can be tedious. You can use dedicated conversion workflows like Trendyol to Shopify import or run files directly through Excel / CSV → Shopify to automatically transform marketplace exports into standard store schemas.

Free toolExcel / CSV → ShopifyConverts your Excel / CSV product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.Open the tool

4. Format pricing, inventory, and numeric values

Data parsing engines require strict numerical formatting. Including non-numeric symbols in price or stock columns is one of the most common causes of batch upload failures.

1. Format all price fields as standard decimal numbers using a period (.) as the decimal separator (e.g., 29.99). Never include currency symbols like $, €, or £.
2. Ensure the inventory quantity column contains whole integers only (e.g., 50, not 50.0).
3. Check your barcode and SKU columns. By default, Excel treats long numbers (such as 12-digit UPCs or 13-digit EANs) as scientific notation (e.g., 8.80123E+11). Format these columns as Text before typing or pasting numbers.
4. Enter shipping weight values in consistent units across your entire catalog. If you need to estimate parcel dimensional constraints before setting final weights in your file, use the Volumetric Weight Calculator to match carrier billing formulas.

5. Host and format product image URLs

A CSV file cannot store raw image files inside its cells. Instead, it references images through publicly accessible web URLs.

1. Upload your product photos to a web host, cloud storage bucket, or your ecommerce platform’s media library.
2. Verify that every image URL starts with http:// or https:// and ends with a valid image extension such as .jpg, .jpeg, .png, or .webp.
3. Paste the primary image URL on the first row of the product.
4. For additional gallery images, add new rows beneath the variant rows containing the same Handle, leaving variant data blank, and placing the extra image URL in the Image Src column.
5. Confirm that the image links are publicly viewable by opening one in an incognito browser window. If the image requires login authentication, the import engine will fail to download it.

6. Validate and export with UTF-8 encoding

Character encoding determines how special characters, accents, and punctuation marks are stored. Failing to use UTF-8 results in broken characters (such as replacement symbols “ appearing instead of quotes or accented letters).

1. Review your spreadsheet for accidental trailing commas or line breaks inside text cells.
2. In Microsoft Excel, navigate to File > Save As, choose the file format dropdown, and select CSV UTF-8 (Comma delimited) (*.csv).
3. In Google Sheets, select File > Download > Comma Separated Values (.csv); Google Sheets exports UTF-8 by default.
4. Open the exported .csv file in a raw text editor (such as Notepad or TextEdit) to visually verify that headers, quotation marks, and commas line up neatly.

Product CSV data specifications and platform comparison

The table below summarizes structural requirements across popular store platforms and marketplace formats to help you prepare your file correctly.

Platform	Primary ID Header	Variant Row Requirement	Image URL Format	Encoding Standard	Typical Max File Size
Shopify	Handle	Shared handle, blank parent fields	Direct HTTPS link per row	UTF-8	15 MB - 50 MB
WooCommerce	ID or SKU	Type set to variation, linked to parent ID	Comma-separated URLs or single row	UTF-8	Server upload limit (usually 2 MB - 64 MB)
Hepsiburada	Merchant SKU / Barcode	Explicit attribute columns per category	Hosted image link	UTF-8 / Windows-1254	10 MB - 20 MB
n11	Product Code	Catalog variant rows under master code	Direct HTTPS link	UTF-8	10 MB - 25 MB
Amazon	item_sku	Flat file with parent and child relationships	Main and other image URL columns	UTF-8 / Tab-delimited text	10 MB - 50 MB

For regional platforms such as Hepsiburada (a major Turkish marketplace), you can also reference our detailed walkthrough on the Hepsiburada Excel template or explore catalog migration between systems using n11 to Shopify migration. If you manage stores on other open-source engines, you can use Excel / CSV → WooCommerce or WooCommerce → Shopify to match target fields quickly.

Common mistakes

• Exporting with ANSI or standard ASCII encoding instead of UTF-8: This causes foreign characters, symbols, and quotation marks to turn into corrupted text like é or ?. Always choose the dedicated “CSV UTF-8” format when saving from spreadsheet software.
• Including currency symbols in price columns: Entering values like $19.99 or 19.99 USD breaks automatic number validation during import. Format all pricing cells as pure numbers with period decimals (e.g., 19.99).
• Letting Excel convert barcodes into scientific notation: Pasting 13-digit EAN or GTIN numbers without setting column format to Text turns 8690123456789 into 8.69E+12, permanently losing trailing digits upon saving. Always set cell format to Text prior to pasting barcode data.
• Using private or temporary cloud storage image links: Linking to file paths on your local hard drive or sharing links from private cloud folders blocks the importer from downloading assets. Use direct, public URLs that display the raw image file directly in a web browser.
• Modifying or translating official column header names: Changing headers like Handle to Product Handle or translating them into another language causes the import engine to ignore the column entirely. Retain exact header spelling and casing as provided by the platform.
• Splitting multi-variant items under different handles: Using unique handle values for size or color variations creates separate standalone product listings instead of a single listing with a dropdown menu. Keep the Handle identical across all variant rows for that item.

Frequently asked questions

What character encoding should I use for a product CSV? You should always use UTF-8 encoding for product CSV files. This format preserves accents, non-Latin alphabets, and special symbols across international ecommerce platforms without corrupting characters into unreadable strings.

How do I handle products with multiple size or color variants in a CSV? You must create a dedicated row for each individual variant while repeating the master handle or product identifier on every row. Leave fields that apply only to the parent product, such as the main description, blank on the secondary variant rows.

Why do my barcode and SKU numbers get corrupted in Excel? Spreadsheet applications automatically convert long numeric strings into scientific notation like 1.23E+11. You can prevent this by setting column formatting to plain text or prepending an apostrophe before saving the file.

Can I use local image file paths from my computer inside the CSV? No, ecommerce platforms require publicly accessible direct URLs starting with http:// or https:// to fetch product images. Upload your photos to a content delivery network, cloud storage bucket, or your store media library before populating the image column.

Converting your product spreadsheets automatically

Preparing clean CSV files manually can take hours of tedious column mapping, especially when shifting inventory between different marketplace formats and direct-to-consumer storefronts. If you have an existing product sheet from your supplier or another platform, you can convert it in seconds.

Use the free Excel / CSV → Shopify tool to automatically structure your catalog into a ready-to-import Shopify CSV file. It handles column mapping, variant grouping, and barcode protection entirely inside your browser—keeping your product data private and your imports error-free.