What you send
The file as it arrived
- Supplier Ref
- WR-19
- Trade
- £12.50 GBP
Sepky / Supplier price list
Excel
Clean a supplier price list from Excel
Weekly price books land as .xlsx files, often with a code column the supplier named differently each time. Sepky reads the sheet, matches those headers to your columns, and gives back a workbook you can pass on.
What you get back
The columns you saved
- sku
- WR-19
- price
- 12.50
Column names
In the file
Supplier RefTrade
In the result
skuprice
How this file is cleaned
- Attach the workbook. Sepky reads the first sheet as rows.
- Match Ref and Trade. Those headers map to sku and price from the columns you saved.
- Download the result. History keeps the cleaned file. The original workbook is not stored.
Questions
- Do I change the file before sending it? The workbook is the file you send. There is no export-and-rename step first.
- 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.