Skip to content

CSV export and import ​

Use CSV export and import to create, update, or move listings in bulk in Crosslist.

INFO

CSV export and import are available on Gold and Diamond plans.

Export your listings to CSV ​

Crosslist lets you export your listings to a CSV file directly from the listing overview.

You can use the file as a backup, to review your inventory in a spreadsheet, or to bulk update your listings: export your current listings, edit them in a spreadsheet, then re-import the file to apply your changes.

How to export your listings ​

  1. Navigate to the listing overview.
  2. Click Export to CSV at the top of the table.

CSV Export Button

The file is saved to your browser's default download location, usually the Downloads folder.

INFO

You can export on a phone or tablet, but the file is easiest to open and edit on a computer.

WARNING

CSV export is based on the filters you currently have applied on the listing overview, such as quick filters or advanced filters, not on which listings you've selected with the checkboxes.

CSV Export Based On Filters

If you haven't set any filters, Crosslist will export all of your listings.

What the export includes ​

The export is a CSV file with one row per listing and 37 columns. It contains the details you fill in on the main listing form, such as title, description, price, category, size, shipping and photos. It also includes the listing ID and dates, such as when the listing was created, posted and sold.

An empty cell means the field is not set on that listing.

See Export columns for a description of every column.

WARNING

Marketplace-specific fields that depend on the category are not exported. These are the extra fields a marketplace asks for based on the category you pick, such as Coin type or Department on eBay. To check or change these details, open the listing in Crosslist.

INFO

The CSV export is currently the only way to download your photos in bulk. The Photos column contains a direct, public URL for each photo, which you can open or download in your browser or with a bulk download tool.

Open the export file in Excel or Google Sheets ​

Some listing descriptions and internal notes contain line breaks. Use one of the methods below so each listing stays on a single row. Other methods can split long descriptions over several rows.

Excel: double-click the file

Double-click the CSV file to open it in Excel. This works when your computer's list separator is a comma, which is the default in the US and UK.

Excel: import with Data > From Text/CSV

Use this method if double-clicking puts all data in one column, or if accents and symbols don't display correctly.

  1. Open a blank workbook in Excel.
  2. Click Data > From Text/CSV and select your export file.
  3. Set File origin to 65001: Unicode (UTF-8).
  4. Click Transform Data.
  5. In the Applied Steps list, click the gear icon next to Source.
  6. Set Line breaks to Ignore quoted line breaks and click OK.
  7. Click Close & Load.

WARNING

Excel's legacy Text Import Wizard (used in versions before Excel 2016) is not supported because it splits multi-line descriptions over several rows.

Excel can remove leading zeros from SKUs that contain only numbers (for example, 003518 becomes 3518). To keep them, use Data > From Text/CSV, click Transform Data, and set the type of the SKU column to Text before loading

Google Sheets

  1. Open a blank spreadsheet in Google Sheets.
  2. Click File > Import > Upload and select your export file.

Google Sheets opens the file correctly without extra settings.

Export file format ​

FormatHow it appears in the file
EncodingUTF-8. Accents, symbols and emoji are kept as typed.
SeparatorComma. Text that contains commas, quotes or line breaks is wrapped in double quotes.
Prices and measurementsNumber with two decimals and a dot as decimal separator, no currency symbol (for example 28.00).
Yes/no fieldsTrue or False
Dates and timesYYYY-MM-DD HH:MM:SS (for example 2026-10-10 12:47:17)
Multiple values in one cellTags and Photos are separated by |. Labels are separated by a comma.
Line breaksKept inside Description and InternalNote. In a text editor, one listing can span several lines.

Export columns ​

These are the 37 columns in the export file, grouped by topic.

Listing details ​

ColumnWhat it containsFormat / example
IdUnique Crosslist ID of the listing2a001ea2-e405-4eda-84c9-64f79083381d
TitleListing titleText
DescriptionListing descriptionText, may contain line breaks
BrandBrand nameNike, Calvin Klein
ConditionItem conditionNewWithTags, NewWithoutTags, VeryGood, Good, Fair, Poor
ColorMain colorBlack, Blue, Gray
Color2Secondary colorSame values as Color
QuantityNumber of units availableWhole number, for example 1
WhoMadeEtsy: who made the itemIDid, SomeoneElse, Collective
WhenMadeEtsy: when the item was madeMadeToOrder, From2020To2026, From1990s

Pricing and offers ​

All amounts are in your account's currency.

ColumnWhat it containsFormat / example
PriceListing price28.00
OriginalPriceOriginal retail price35.00, or empty when not set
CostOfGoodsWhat you paid for the item4.99
SmartPricingWhether Smart Pricing is onTrue / False
SmartPricingPricePrice set under Smart Pricing40.00
AcceptOffersWhether buyers can send offersTrue / False
IsAuctionWhether the listing is an auctionTrue / False
AuctionStartingPriceAuction starting price20.00

Category and size ​

Category and size each come as an ID and a readable label. Use the label when you work in a spreadsheet.

ColumnWhat it containsFormat / example
CategoryIdCrosslist category ID4dd77941-8b84-9c55-85ca-62c437645669
CategoryLabelFull category pathClothing, shoes & accessories > Menswear > Men's activewear > Men's tracksuits
SizeIdCrosslist size ID78c1966f-1623-2e16-092e-b126ed286978
SizeLabelSize as shown on the listingS, M, 8, 10

Shipping ​

A weight or dimension of 0.00 means it was not filled in. For shipping prices, 0,00 means you pay the shipping (seller pays), and an empty cell means the price from your shipping profile is used.

ColumnWhat it containsFormat / example
ShippingWeightPackage weight32.00
ShippingWeightUnitUnit of ShippingWeightOunces, Grams
ShippingHeightPackage height5.00
ShippingWidthPackage width12.00
ShippingLengthPackage length14.00
ShippingPriceShipping price for domestic buyers. 0.00 means seller pays, empty means your shipping profile is used.4.99
InternationalShippingPriceShipping price for international buyers. 0.00 means seller pays, empty means your shipping profile is used.14.99

Organization, status and photos ​

ColumnWhat it containsFormat / example
SKUYour own stock codeFree text, for example TOTE 035
TagsSearch tagsSeparated by |, for example denim|jacket|vintage
LabelsYour Crosslist labels for organizing listingsSeparated by a comma
InternalNotePrivate note, never published to marketplacesText, may contain line breaks
CreatedWhen the listing was created in Crosslist2024-08-29 07:53:44
LastListedOnMost recent time the listing was posted to a marketplace2026-10-10 15:17:00, empty if never posted
SoldWhen the listing was marked as sold2026-06-25 14:37:31, empty if not sold
PhotosPublic photo URLs in listing orderSeparated by |, for example https://media-na.crosslist.com/…/p1.jpg

Import listings from CSV ​

Use CSV import to create or update listings in bulk in Crosslist.

This is useful when you are moving listings from another system, preparing listings offline, or making bulk edits in a spreadsheet.

Step 1: Download or edit the template ​

  1. Open the CSV template in Google Sheets here.
  2. Click File > Download > Microsoft Excel (.xlsx).
  3. Navigate to the Template sheet.

INFO

Alternatively, you can edit directly in Google Sheets

  1. Open the CSV template here.
  2. Make sure you are signed in with your Google account.
  3. Click File > Make a Copy.
  4. Navigate to the Template sheet.

The template also includes helper sheets:

  • Categories (for valid Category id values)
  • Sizes (for valid Size id values)
  • Info (for valid field values)

Step 2: Fill in your listing data ​

Add your listing data to the Template sheet.

A few important rules:

  • Use Id only when updating existing listings
  • Use exact values for fields like Condition and booleans (TRUE / FALSE)
  • Use category and size IDs (not labels)
  • For multiple images, separate filenames with |

Example for the Images column:

img1.jpg|img2.jpg|img3.png

Step 3: Save your file as CSV ​

Crosslist requires a .csv file, not an .xlsx Excel file.

  1. Make sure you are on the Template sheet.
  2. Click File > Save As (or Save a Copy).
  3. Choose file format: CSV UTF-8 (Comma delimited) (*.csv)
  4. Save the file.

INFO

Alternatively, you can also export from Google sheets:

  1. Open the file in Google Sheets.
  2. Make sure you are on the Template sheet.
  3. Click File > Download > Comma Separated Values (.csv).

WARNING

Saving as CSV only saves the active sheet. Save the Template sheet, not Categories or Sizes.

Step 4: Prepare your image ZIP (optional) ​

If you want to import images, create a .zip file containing the image files.

Requirements:

  • Filenames must match the Images column exactly
  • Include the file extension (for example .jpg, .png)
  • Use | between multiple filenames in the CSV

If filenames do not match, the images will not import correctly.

Step 5: Upload your files in Crosslist ​

Navigate to the CSV import screen by clicking the Import button at the top of your screen. Then select CSV:

Open CSV import

This will open the first step of the CSV upload process:

  • Upload your CSV file (required)
  • Upload your ZIP file with images (optional)

CSV upload screen

Then click Map to continue.

Step 6: Map your columns ​

In the Map step, match each of your CSV columns on the left to the correct Crosslist field on the right.

Map CSV columns

INFO

  • Review all mappings before importing
  • Leave unused columns unmapped, or else they will overwrite the existing values in Crosslist
  • Double-check fields with strict allowed values (for example Condition, Color, Is auction)

Step 7: Import your listings ​

In the Import step, Crosslist validates your data and processes the file.

The import works on an all-or-nothing basis. If even one row contains an error, the entire file will not be imported.

If there are validation errors, Crosslist will show the issues for each affected row.

CSV validation results

Please fix the errors in your CSV file and upload it again.

Creating versus updating listings ​

To create new listings:

  • Leave Id empty, or
  • Omit the Id column

To update existing listings:

  • Include the Crosslist listing Id in the Id column
  • Make sure each Id is unique in the file

WARNING

During updates, all mapped columns overwrite the corresponding Crosslist fields, including Images, even when the CSV value is empty. To prevent a field from being updated, leave that mapping column blank in the mapping step above.

Common import issues ​

  • Invalid Category id or Size id
  • Size id that doesn't match the size group of the category
  • Wrong enum values (for example Very Good instead of VeryGood)
  • Boolean values not using TRUE / FALSE
  • Image filenames in CSV do not match the ZIP file
  • CSV exported from the wrong sheet

Supported fields ​

The following columns are supported for CSV import.

FieldExplanationAllowed values / formatExample input
IdUnique Crosslist identifier for the listing. Only necessary when updating listings.Crosslist id; must be unique.7d952d33-3e44-45d1-bf08-dacd9e8420a1
TitleShort, searchable name of the listing.Text; 5–255 characters.Classic Denim Jacket
DescriptionFull description shown to buyers.Text; can include line breaks; max 12 000 charactersStylish vintage denim jacket in great condition
PriceSale price.Number; >= 0 (e.g., 49.99).49.99
Original PriceCompare-at/MSRP price.Number; blank or >= price.79.99
BrandBrand of the item.Text.Levis
Category idCrosslist category id of your listing.Existing category ID see sheet Categories0b6009b3-0082-7581-7b4b-096e0b105294
Size idCrosslist clothing size id.Existing size ID see sheet Sizes; allowed values depend on the size group of the selected category. First check the size group in sheet Categories, then use sheet Sizes to find the allowed size ids.f9ea6dc9-36f2-458a-3070-f8947835429a
ConditionItem condition state.One of: NewWithTags, NewWithoutTags, VeryGood, Good, Fair, Poor.VeryGood
ColorPrimary color.One of: Red, Pink, Orange, Yellow, Green, Blue, Purple, Gold, Silver, Black, Gray, White, Cream, Beige, Brown, Tan, Khaki, Turquoise, Apricot, Coral, Burgundy, Rose, Lilac, LightBlue, Navy, DarkGreen, Mustard, Mint, Multi, Clear.Blue
Secondary colorOptional secondary color.One of: Red, Pink, Orange, Yellow, Green, Blue, Purple, Gold, Silver, Black, Gray, White, Cream, Beige, Brown, Tan, Khaki, Turquoise, Apricot, Coral, Burgundy, Rose, Lilac, LightBlue, Navy, DarkGreen, Mustard, Mint, Multi, Clear.LightBlue
ImagesImage file names.Pipe delimited list. Must match the file names (including extension) in the uploaded zip fileimg1.jpg|img2.png|img3
QuantityNumber of items available.Integer >= 0.1
Shipping weightWeight for shipping calculation.Integer >= 0; Uses the unit specified in the Shipping weight unit column (if provided). Otherwise, defaults to ounces when Crosslist is set to Imperial, or grams when set to Metric.2
Shipping weight unitUnit of the shipping weight.One of: Ounces, GramsOunces
Shipping heightPackage height.Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric.10
Shipping widthPackage width.Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric.30
Shipping lengthPackage length.Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric.40
Domestic shipping priceShipping cost domestic.Number >= 0 or empty.5.99
Worldwide shipping priceShipping cost international.Number >= 0 or empty.14.99
Free domestic shippingIs domestic shipping free.Boolean: TRUE/FALSE.FALSE
Free worldwide shippingIs worldwide shipping free.Boolean: TRUE/FALSE.FALSE
TagsSearch keywords.Pipe-delimited tags.denim | jacket|vintage
SKUStock keeping unit.Text; should be unique.SKU12345
Who madeWho created the item.One of: IDid, SomeoneElse, Collective.SomeoneElse
When madeProduction era.One of: MadeToOrder, From2020To2024, From2010To2019, From2005To2009, From2000To2004, From1990s, From1980s, From1970s, From1960s, From1950s, From1940s, From1930s, From1920s, From1910s, From1900To1901, From1800s, From1700s, Before1700, Before2005.From1990s
Smart pricingAutomatic pricing enabled.Boolean: TRUE/FALSE.FALSE
Smart pricing pricePrice used for smart pricing.Number or empty.10.5
Accept offersCan buyers make offers.Boolean: TRUE/FALSE.TRUE
Is auctionAuction format enabled.Boolean: TRUE/FALSE.FALSE
Auction starting priceStarting bid price.Number; applicable if auction.20
Internal notePrivate internal note.TextSample internal note