Practical guidance
Why a CSV opens as one column
When every header appears in one cell, the reader and writer may disagree about the separator. Renaming the file does not change its contents.
Inspect the first two records
Read the header in a text editor. If it says SKU;Title;Price, semicolons separate those fields. If the data says 00007;Stone bowl;"12,50", the comma is inside a price value and should not become a new column.
SKU;Title;Price
00007;Stone bowl;"12,50"Choose the input dialect before the output
- Confirm which character separates fields outside quoted text.
- Set that delimiter in Golanto and check the parsed headers.
- Resolve values such as localized prices separately.
- Export using the separator expected by the destination importer and inspect the result.
Avoid global find and replace
Replacing every semicolon with a comma also changes semicolons inside product text. A real CSV serializer changes field boundaries while preserving the cell values. The useful check is a parse/export/parse comparison of the decoded values.
Worked example
The same two fields with a different separator
SKU;Title
00007;Stone bowlSKU,Title
00007,Stone bowlNo product value changes in this example.
What this check cannot establish
Delimiter detection is a heuristic. A single-column file or very short sample may need the merchant to choose the separator explicitly.
Check your file
Start with a copy. Review changes before downloading your import file.
Open the CSV tool