Spreadsheets for Bulk Imports

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

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 step by step assistance.

  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 .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

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