Spreadsheets for Bulk Imports

Learn how to create and save inventory list spreadsheets for bulk import.

Table of Contents

Create the Spreadsheet

Create your inventory list by downloading the basic template or the advanced template. View the Bulk Management article for more information.

  1. Open the file using spreadsheet software.

    Microsoft Excel, Google Sheets, or Apache OpenOffice are recommended.

  2. Enter product information in the spreadsheet.
    Click to Enlarge

Save the Spreadsheet

Save the spreadsheet for upload in the format based on the spreadsheet software being used.

Microsoft Excel

Save your spreadsheet in . txt format when using Excel.

  1. Click 'File', then 'Save As'.
  2. Click the 'File Format' dropdown and select 'UTF-16 Unicode Text (.txt.)', then 'Save'.

Google Sheets

Sheets autosaves the spreadsheet as it is being worked on. Download a copy to your hard drive for upload.

  1. Click 'File', then 'Download as'. Choose 'Comma-separated values'
  2. An export of your inventory list will appear on the hard drive.

Apache OpenOffice

Save your spreadsheet in .csv format for upload.

  1. Click 'File', then 'Save As'.
  2. Click the 'File type' drop down, select 'Text CSV (.csv)', then 'Save'
  3. If the format prompt appears, click 'Keep Current Format'.
  4. Confirm the character set 'Unicode (UTF-8)' and click 'OK'