Sepky / Product catalog

Excel

Clean a product catalog from Excel

A catalog spreadsheet from a brand or a distributor usually has a long title and a price cell with a symbol. Sepky returns the title and the price in the columns your catalog already uses.

What you send

The file as it arrived

Description
Wool throw / grey
RRP
$120.00

What you get back

The columns you saved

title
Wool throw / grey
price
120.00

Column names

In the file

DescriptionRRP

In the result

titleprice

How this file is cleaned

  1. Save title as text and price as a number. That is the catalog shape you want back.
  2. Attach the .xlsx. Description and RRP are matched from the first row.
  3. Use the cleaned sheet. Download it from the response or from History.

Questions

  • Do I change the file before sending it? You attach the spreadsheet. Column names on the account do the matching.
  • Which columns come back? The cleaned file uses title, 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.

Get started