What is Spreadsheet Listing?
Spreadsheet import allows you to fill out a template file in order to bulk add multiple listings to Mercari. This tool is intended for power users who use their own methods to fill out the template, either manually or with automation. We are unable to support developing automated methods of filling in this template.
Before listing, please review our Prohibited Items and Prohibited Conduct lists.
Where can I find the template?
The template can be downloaded here.
What software do I need to edit the template?
A spreadsheet software such as Microsoft Excel or Apple Numbers is required to edit the template.
How do I fill out the template?
Insert the information of listings you want to create into the format specified with the listing_template sheet.
Please reference the tabs labeled item_condition_names, brand_id, category_id, category_size_group_id, size_id, shipper_payer_name, and shipping_method for supplementary information needed to fill out the listing_template format.
How do I import listings from a spreadsheet?
1. Select the "Upload listing spreadsheet" button on the import listings page
2. Upload your the listing_template file as either a csv or xlsx format.
- For xlsx files, when prompted to select a worksheet, choose import_template
- For csv files, be sure to upload the data in the format specified by the listing_template sheet
3. Fix Any errors as flagged in the uploader, and select "Import" to create your listings as drafts
Is this feature available on both the app and website?
Spreadsheet imported listings are supported on desktop browsers only. The feature is currently not available on app.
What happens after I import my listings?
Imported items are put into your drafts and will need to be activated prior to becoming listings on Mercari. If an imported listing doesn’t have all the required information to post, it will be put into the “Action Required” section of your drafts.
How long does the import process take?
Processing time can vary depending on how many listings are being imported. Most imports should complete within a couple minutes.
What are the minimum and maximum listing prices on Mercari?
Items must be priced between $1 and $2,000.