Appearance
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
- Navigate to the listing overview.
- Click Export to CSV at the top of the table.

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.

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.
- Open a blank workbook in Excel.
- Click Data > From Text/CSV and select your export file.
- Set File origin to 65001: Unicode (UTF-8).
- Click Transform Data.
- In the Applied Steps list, click the gear icon next to Source.
- Set Line breaks to Ignore quoted line breaks and click OK.
- 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
- Open a blank spreadsheet in Google Sheets.
- Click File > Import > Upload and select your export file.
Google Sheets opens the file correctly without extra settings.
Export file format
| Format | How it appears in the file |
|---|---|
| Encoding | UTF-8. Accents, symbols and emoji are kept as typed. |
| Separator | Comma. Text that contains commas, quotes or line breaks is wrapped in double quotes. |
| Prices and measurements | Number with two decimals and a dot as decimal separator, no currency symbol (for example 28.00). |
| Yes/no fields | True or False |
| Dates and times | YYYY-MM-DD HH:MM:SS (for example 2026-10-10 12:47:17) |
| Multiple values in one cell | Tags and Photos are separated by |. Labels are separated by a comma. |
| Line breaks | Kept 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
| Column | What it contains | Format / example |
|---|---|---|
| Id | Unique Crosslist ID of the listing | 2a001ea2-e405-4eda-84c9-64f79083381d |
| Title | Listing title | Text |
| Description | Listing description | Text, may contain line breaks |
| Brand | Brand name | Nike, Calvin Klein |
| Condition | Item condition | NewWithTags, NewWithoutTags, VeryGood, Good, Fair, Poor |
| Color | Main color | Black, Blue, Gray |
| Color2 | Secondary color | Same values as Color |
| Quantity | Number of units available | Whole number, for example 1 |
| WhoMade | Etsy: who made the item | IDid, SomeoneElse, Collective |
| WhenMade | Etsy: when the item was made | MadeToOrder, From2020To2026, From1990s |
Pricing and offers
All amounts are in your account's currency.
| Column | What it contains | Format / example |
|---|---|---|
| Price | Listing price | 28.00 |
| OriginalPrice | Original retail price | 35.00, or empty when not set |
| CostOfGoods | What you paid for the item | 4.99 |
| SmartPricing | Whether Smart Pricing is on | True / False |
| SmartPricingPrice | Price set under Smart Pricing | 40.00 |
| AcceptOffers | Whether buyers can send offers | True / False |
| IsAuction | Whether the listing is an auction | True / False |
| AuctionStartingPrice | Auction starting price | 20.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.
| Column | What it contains | Format / example |
|---|---|---|
| CategoryId | Crosslist category ID | 4dd77941-8b84-9c55-85ca-62c437645669 |
| CategoryLabel | Full category path | Clothing, shoes & accessories > Menswear > Men's activewear > Men's tracksuits |
| SizeId | Crosslist size ID | 78c1966f-1623-2e16-092e-b126ed286978 |
| SizeLabel | Size as shown on the listing | S, 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.
| Column | What it contains | Format / example |
|---|---|---|
| ShippingWeight | Package weight | 32.00 |
| ShippingWeightUnit | Unit of ShippingWeight | Ounces, Grams |
| ShippingHeight | Package height | 5.00 |
| ShippingWidth | Package width | 12.00 |
| ShippingLength | Package length | 14.00 |
| ShippingPrice | Shipping price for domestic buyers. 0.00 means seller pays, empty means your shipping profile is used. | 4.99 |
| InternationalShippingPrice | Shipping price for international buyers. 0.00 means seller pays, empty means your shipping profile is used. | 14.99 |
Organization, status and photos
| Column | What it contains | Format / example |
|---|---|---|
| SKU | Your own stock code | Free text, for example TOTE 035 |
| Tags | Search tags | Separated by |, for example denim|jacket|vintage |
| Labels | Your Crosslist labels for organizing listings | Separated by a comma |
| InternalNote | Private note, never published to marketplaces | Text, may contain line breaks |
| Created | When the listing was created in Crosslist | 2024-08-29 07:53:44 |
| LastListedOn | Most recent time the listing was posted to a marketplace | 2026-10-10 15:17:00, empty if never posted |
| Sold | When the listing was marked as sold | 2026-06-25 14:37:31, empty if not sold |
| Photos | Public photo URLs in listing order | Separated 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
- Open the CSV template in Google Sheets here.
- Click File > Download > Microsoft Excel (.xlsx).
- Navigate to the Template sheet.
INFO
Alternatively, you can edit directly in Google Sheets
- Open the CSV template here.
- Make sure you are signed in with your Google account.
- Click File > Make a Copy.
- 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.
- Make sure you are on the Template sheet.
- Click File > Save As (or Save a Copy).
- Choose file format:
CSV UTF-8 (Comma delimited) (*.csv) - Save the file.
INFO
Alternatively, you can also export from Google sheets:
- Open the file in Google Sheets.
- Make sure you are on the Template sheet.
- 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:

This will open the first step of the CSV upload process:
- Upload your CSV file (required)
- Upload your ZIP file with images (optional)

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.

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.

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 Goodinstead ofVeryGood) - 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.
| Field | Explanation | Allowed values / format | Example input |
|---|---|---|---|
| Id | Unique Crosslist identifier for the listing. Only necessary when updating listings. | Crosslist id; must be unique. | 7d952d33-3e44-45d1-bf08-dacd9e8420a1 |
| Title | Short, searchable name of the listing. | Text; 5–255 characters. | Classic Denim Jacket |
| Description | Full description shown to buyers. | Text; can include line breaks; max 12 000 characters | Stylish vintage denim jacket in great condition |
| Price | Sale price. | Number; >= 0 (e.g., 49.99). | 49.99 |
| Original Price | Compare-at/MSRP price. | Number; blank or >= price. | 79.99 |
| Brand | Brand of the item. | Text. | Levis |
| Category id | Crosslist category id of your listing. | Existing category ID see sheet Categories | 0b6009b3-0082-7581-7b4b-096e0b105294 |
| Size id | Crosslist 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 |
| Condition | Item condition state. | One of: NewWithTags, NewWithoutTags, VeryGood, Good, Fair, Poor. | VeryGood |
| Color | Primary 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 color | Optional 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 |
| Images | Image file names. | Pipe delimited list. Must match the file names (including extension) in the uploaded zip file | img1.jpg|img2.png|img3 |
| Quantity | Number of items available. | Integer >= 0. | 1 |
| Shipping weight | Weight 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 unit | Unit of the shipping weight. | One of: Ounces, Grams | Ounces |
| Shipping height | Package height. | Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric. | 10 |
| Shipping width | Package width. | Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric. | 30 |
| Shipping length | Package length. | Integer >= 0; Uses inches if Crosslist is set to Imperial, or centimeters if set to Metric. | 40 |
| Domestic shipping price | Shipping cost domestic. | Number >= 0 or empty. | 5.99 |
| Worldwide shipping price | Shipping cost international. | Number >= 0 or empty. | 14.99 |
| Free domestic shipping | Is domestic shipping free. | Boolean: TRUE/FALSE. | FALSE |
| Free worldwide shipping | Is worldwide shipping free. | Boolean: TRUE/FALSE. | FALSE |
| Tags | Search keywords. | Pipe-delimited tags. | denim | jacket|vintage |
| SKU | Stock keeping unit. | Text; should be unique. | SKU12345 |
| Who made | Who created the item. | One of: IDid, SomeoneElse, Collective. | SomeoneElse |
| When made | Production era. | One of: MadeToOrder, From2020To2024, From2010To2019, From2005To2009, From2000To2004, From1990s, From1980s, From1970s, From1960s, From1950s, From1940s, From1930s, From1920s, From1910s, From1900To1901, From1800s, From1700s, Before1700, Before2005. | From1990s |
| Smart pricing | Automatic pricing enabled. | Boolean: TRUE/FALSE. | FALSE |
| Smart pricing price | Price used for smart pricing. | Number or empty. | 10.5 |
| Accept offers | Can buyers make offers. | Boolean: TRUE/FALSE. | TRUE |
| Is auction | Auction format enabled. | Boolean: TRUE/FALSE. | FALSE |
| Auction starting price | Starting bid price. | Number; applicable if auction. | 20 |
| Internal note | Private internal note. | Text | Sample internal note |