Skip to main content
All CollectionsListsManaging Checklists in the Jolt Web Portal
How to Import List Items in Bulk from a Spreadsheet
How to Import List Items in Bulk from a Spreadsheet
Curtis Nash avatar
Written by Curtis Nash
Updated over 4 months ago

How to Import List Items in Bulk from a Spreadsheet

If you need to add a large number of items to a list quickly, you can use the Bulk Import feature. This guide will walk you through the steps to import your list items efficiently.

Prerequisites

To use the Bulk Import feature, you must have one of the following admin permissions:

  • Location Website Admin

  • Content Group Admin

  • Company Admin

Video Walkthrough

For a visual guide, you can watch our video: How to Import List Items in Bulk

Instructions

Step 1: Access the Lists Section

  1. Log in to the Jolt Web Portal.

  2. Navigate to Lists: Go to the Lists section from the main menu.

  3. Edit a List: Create a new list or choose an existing one that you want to edit.

Step 2: Start the Bulk Import Process

  1. Open Bulk Import:

    • Click the blue add button (usually marked with a β€œ+” symbol).

    • Select Bulk Import Items from the dropdown menu.

Step 3: Configure Import Settings

  1. Select Item Type:

    • Choose the type of items you want to import from the dropdown list. Ensure that the item type matches exactly as shown in the dropdown. Note that Multiple Choice, Sublists, and Stopwatch items cannot be imported in bulk.

    • For details on available item types, refer to our article on List Item Types.

  2. Enter Prompt:

    • In the Prompt field, type the task or action that needs to be done. This will describe what the item is for.

  3. Add Points (Optional):

    • Assign a point value to each item if you want to reward points upon task completion. For more information on setting points, refer to the Points | Lists article.

  4. Allow N/A (Optional):

    • Check the box Allow N/A if you want employees to have the option to mark the item as Not Applicable (N/A). If left unchecked, employees will not be able to mark it as N/A.

Step 4: Import Your Data

  1. Copy and Paste Data:

    • Copy your list data from your spreadsheet (use Ctrl + C or Cmd + C).

    • Paste the data into the import field in Jolt (use Ctrl + V or Cmd + V).

    • Note: Do not use the mouse to drag and drop data; use keyboard shortcuts for copying and pasting.

  2. Save and Start Import:

    • Click Save All to ensure your settings are saved.

    • Select Start Import to begin importing your items.

Step 5: Finalize Changes

  1. Save Your Changes:

    • After importing, make sure to click Save before exiting the page to ensure all your data is stored correctly.

Related Articles

  • Create a List

  • List Item Types

  • Points | Lists

If you have any questions or need additional help, feel free to reach out to our support team.

Did this answer your question?