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
Log in to the Jolt Web Portal.
Navigate to Lists: Go to the Lists section from the main menu.
Edit a List: Create a new list or choose an existing one that you want to edit.
Step 2: Start the Bulk Import Process
Open Bulk Import:
Step 3: Configure Import Settings
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.
Enter Prompt:
In the Prompt field, type the task or action that needs to be done. This will describe what the item is for.
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.
Allow N/A (Optional):
Step 4: Import Your Data
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.
Save and Start Import:
Step 5: Finalize Changes
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.