Spreadsheets for
Bulk Imports

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

Table of Contents

Create the Spreadsheet

Begin the process of importing items by downloading a template and entering your inventory.

  1. Download the template for importing basic items or items with variants.
  2. Open the template using spreadsheet software.

    Microsoft Excel, Apple Numbers, Google Sheets, or Apache OpenOffice are recommended. When opening the template in these programs, be sure to select comma separated if prompted in a box similar to the image below (Apache OpenOffice shown here).

    Click to Enlarge
  3. Enter products into the spreadsheet according to the information in the relevant article below.

    If importing basic items, visit the Bulk Manage: Inventory Imports article for help. If importing items with variants, visit this Bulk Management article instead.

    Click to Enlarge
  4. Save the template according to the specific directions below for your spreadsheet software.

Save the Spreadsheet

Follow the relevant section below to learn how to save your completed spreadsheet based on the spreadsheet software you are using. All steps are the same whether you have a Mac or PC.

After saving the spreadsheet, follow the steps here to import it to BackOffice using Bulk Management.

Microsoft Excel

Save your spreadsheet in .csv format when using Excel.

  1. Click 'File', then 'Save As'.
  2. Click the 'File Format' dropdown and select 'Comma Separated Values (.csv)', then 'Save'.
    Click to Enlarge

Apple Numbers

Save your spreadsheet in .csv format when using Numbers on a Mac.

  1. Click ‘File’, then select ‘Export To’ and ‘CSV’.
    Click to Enlarge
  2. Click ‘Advanced Options’, then select ‘Unicode (UTF-8)’.
    Click to Enlarge
  3. Click ‘Next’.
  4. Click ‘Export’.
    Click to Enlarge

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 (comma-separated values) 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'.

  • Help us improve ShopKeep Support. Was this article helpful?
  • YES   NO