golanto.
Menu
Free toolsFormatsGuidesPricingYour workspace

Same products, different file shape

Choose how the corrected file is formatted.

Preview stays in your browser. When you download, pick the dialect the next tool expects. One credit covers that file, including a repeat download of the same review.

Keep this file’s formatting

Uses the delimiter, line ending, and byte-order mark detected in the file you opened.

The destination importer already accepts this file’s dialect and you only want corrected cell values.

Shopify CSV (comma)

Comma-separated, which Shopify product import expects. Line endings and any byte-order mark stay as they were in the source file.

You are preparing a Shopify product CSV. Shopify documents comma-separated UTF-8 files.

Excel, comma

Comma-separated, Windows CRLF line endings, and a UTF-8 byte-order mark so Excel can recognize Unicode text.

You will open the file in Excel on a system that treats comma as the list separator.

Excel, semicolon

Semicolon-separated, Windows CRLF line endings, and a UTF-8 byte-order mark. Fits locales where comma is the decimal separator.

Excel in your locale splits CSV rows on semicolons, or prices such as 12,50 must stay one cell.

Tab-separated

Tab-separated values with LF line endings and no byte-order mark. The download uses a .tsv name.

A supplier, warehouse, or import tool asks for TSV rather than comma-separated CSV.

Pipe-separated

Pipe-separated values with LF line endings and no byte-order mark. Product text can keep its commas.

The receiving system asks for a pipe delimiter, often because descriptions already contain commas.

How to choose

  1. Read the file with the encoding and delimiter that make the headers line up. UTF-8, Windows-1252, and UTF-16 are available before review.
  2. Review the cells. A format preset does not translate prices, invent inventory, or strip accents.
  3. On the download step, choose the destination format. Shopify product import expects commas. Excel in many European locales expects semicolons.

Open the repair preview · Why a CSV opens as one column · Line endings · UTF-8 byte-order mark

Questions about formatting

Does a download format change my product text?

No. The format chooses the delimiter, line ending, and whether a UTF-8 byte-order mark is written. Cell values, including commas inside descriptions, stay as reviewed.

Which format should I use for Shopify?

Use Shopify CSV (comma). Shopify product import expects comma-separated UTF-8. If the first column name fails to match after Excel has opened the file, check whether a byte-order mark was added.

Which format should I use for Excel?

Use Excel, comma when your system splits lists on commas. Use Excel, semicolon when your locale uses a comma as the decimal separator. Both presets write CRLF line endings and a UTF-8 byte-order mark.