Uploading or Importing Checklist Data From a File / Spreadsheet

If you have checklist stored in a spreadsheet, you can upload that data to the Checklists tool in an Event using a .CSV file.

To convert your spreadsheet to a .CSV file:

• In Excel - Go to File > Save As; in the "File Format" dropdown, select the "Comma Separated Values (.csv)" option; click "Save".
• In Google Sheets/Drive - Go to File > Download As; select the "Comma-separated values (.csv, current sheet)" option.

To Upload or Import Data in the Checklists Tool

1. Click on the "Checklists" tool button on the Event Dashboard - OR - use the Quick Launch or Switch Event tool to select the appropriate Event and the "Checklists" tool.
2. Click on the "Import/Export" button and select the "Import From a .CSV File" option.
3. Enter in the name of the new checklist.
4. Click on the "Choose File" button to select the .CSV file from your computer.
5. Click on the "Start Import Process" button.
6. Match the fields from your file to the available fields in Planning Pod (Item Name, Completed?). When you are done, click the "Continue to Next Step" button.
   
   • NOTE: If your file does not have a header row, make sure the "Imported file has column headers?" checkbox IS NOT checked.
7. Review the data on the page. If there are any fields that can be edited, double-check them to ensure they contain valid information and edit them if necessary. If the information is not in a valid format, you will not be able to submit it until it has been fixed.
   • NOTE: If the information here looks incorrect, you may need to go back and re-match fields, or you may need to fix your original .csv file and re-try this process.
8. Once all fields are correct, click the "Looks Good - Import Now" button. Your information will be uploaded momentarily.

Once your data is uploaded, you can edit it and add additional information.