What you send
The file as it arrived
- Article
- 00491
- £ ex VAT
- £7,40
Sepky / SKU and price
Excel
Clean SKU and price columns
Most supplier sheets come down to two columns that matter: a code and a price. The code has stray spaces. The price has a symbol. Sepky returns sku and price and leaves the rest of the sheet's naming to the match.
What you get back
The columns you saved
- sku
- 00491
- price
- 7.40
Column names
In the file
Article£ ex VAT
In the result
skuprice
How this file is cleaned
- Save sku as text and price as a number. That pair is enough for this sheet.
- Attach the workbook. Article and £ ex VAT are matched from the first row.
- Keep the cleaned pair. Download it, or open it later from History.
Questions
- Do I change the file before sending it? You only name the two columns you want back.
- Which columns come back? The cleaned file uses sku, 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.