Sell on Amazon Sign In
This article applies to selling in: Japan

Using Listing Loader

There are two ways to use Listing Loader.

Option 1 – Use the template with macros

This option requires a Windows operating system with Microsoft Excel 2002, 2003, or 2007.

Step 1 Enter listing information

Enter listing details for your products, using one of these options:

  • Type your listing details directly into theListings-Template tab.
  • Click Import Listings on the Listing Loader menu to import a text file that contains your listing details.

When macros are enabled, the Listing Loader menu is available in Excel. See Use Template Macros.

Step 2 Perform product lookup (optional)

Product Lookup and Bulk Lookup features require authorization through Amazon Marketplace Web Service (Amazon MWS). Learn more.

If you are using a version of the Listing Loader template that is older than 2.0, and Bulk Lookup and Product Lookup do not pull any product information into the template, download the latest version of Listing Loader. If you aren't sure which version you have, check the top of column B on the Template tab.

Product Lookup and Bulk Lookup check the Amazon catalog for the products you are trying to list, and then fill in the Title and ASIN-hint fields for existing products. You can use the Title field to verify that your product matches with the correct Amazon product.

Look up products using one of these options:

  • Bulk: Fill in the product id column for each listing and then click Bulk Lookup on the Listing Loader menu to check the Amazon catalog for all of the products. Depending on the number of listings, this can take a while to complete.
  • Interactive: Click Turn on Product Lookup on the Listing Loader menu to check the Amazon catalog for each listing as you enter the product id.
Step 3 Review product lookup results (optional)

If a product does not exist in the Amazon catalog, or has multiple matches, your listing information for that product will be put in one of these two tabs:

  • Products not found
  • Products with multiple matches

Follow the instructions in the tabs if any of your listings appear there.

Step 4 Validate listings (optional)

Click Validate on the Listing Loader menu to validate your data. This checks your listing data for completeness and can reduce upload failures caused by input errors.

Step 5 Upload Listings to Amazon

Upload your listings to Amazon using one of these options:

  • Upload Macro - Click the Upload macro button on the Listing Loader menu and provide your Amazon MWS credentials. Learn more.
  • Seller Central - Save the Listings-Template tab as a tab-delimited text file (.txt) and upload that file from the inventory upload section in your seller account.

Option 2 – Submit tab-delimited file in the Listing Loader format

After you finish populating the Listings-Template sheet in the Listing Loader template with your listings data, you are ready to create the inventory file that you will upload to Amazon using Seller Central.

Step 1 Save your work as an Excel workbook. We suggest creating a back-up copy and adding a date to the file name to keep a history of your work, if you want to refer to prior versions or in case there is an error in processing.
Step 2 Make sure you are on the worksheet tab that contains your data. On the File menu, click Save As.

The Save As dialog box appears.

Step 3 In the Save As Type list, select Text (Tab-delimited) (*.txt). Browse to where you would like to save the file, rename the file, and click Save.
Step 4 You might see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets. Click Yes.
Step 5 You might see a warning that your file contains features incompatible with the selected text (tab delimited) file format. Click Yes.

You are now ready to upload your inventory file. For more information, see Upload My Inventory File.

Sign in to use the tool and get personalized help (desktop browser required). Sign In


Reach hundreds of millions of customers

Start selling on Amazon


© 1999-2022, Amazon.com, Inc. or its affiliates