What you send
The file as it arrived
- Cost
- $249,99
Sepky / Price format
CSV
Fix European price formats in a CSV
A comma used as the decimal mark, or a thousands dot, breaks a price import. Sepky reads cells such as $249,99 and €1.250,00 and returns ordinary decimal numbers.
What you get back
The columns you saved
- price
- 249.99
Column names
In the file
Cost
In the result
price
How this file is cleaned
- Set price as a number. That is the whole rule for this file.
- Send the CSV. Cost is matched to price.
- Import the numbers. 249.99 is what comes back, with the symbol and the comma gone.
Questions
- Do I change the file before sending it? You mark the destination column as a number. The currency text is the supplier's problem.
- Which columns come back? The cleaned file uses price.
Related files
Clean this file in Sepky
1,000 lines are free. $100 a month covers 50,000 lines, saved columns, file upload, code send, and History. The original file is not kept.