What you send
The file as it arrived
- Units
- 12
- Amount
- €240,00
Sepky / Order file
Excel
Clean an order file from Excel
A merchant's order sheet often has a quantity with stray spaces and a price copied in with a currency sign. Sepky reads the workbook and returns one row per line with those values cleaned.
What you get back
The columns you saved
- quantity
- 12
- line_price
- 240.00
Column names
In the file
UnitsAmount
In the result
quantityline_price
How this file is cleaned
- Mark both destination columns as numbers. Units and Amount are matched to them.
- Attach the order workbook. The first sheet is the batch.
- Download the cleaned lines. The original sheet is not kept.
Questions
- Do I change the file before sending it? You do not insert a helper column before the upload.
- Which columns come back? The cleaned file uses quantity, line_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.