This feature enables fire departments and EMS agencies to create standardized inspection checklists by importing them from Excel templates. This streamlines the inspection process, ensures consistency across all inspections, and reduces manual setup time while maintaining compliance with local codes and regulations.
Background Information
The Import XLS feature allows departments to bulk-create inspection checklists rather than building them item by item within the system. This is particularly valuable for departments with extensive inspection requirements, multiple inspection types, or those migrating from paper-based or other digital systems. The template-based approach ensures all required fields are properly formatted and reduces data entry errors during initial setup.
Required Permissions
Users must have Administrator or Inspection Manager permissions to access the Inspections module and import inspection checklists. Standard field users cannot create or import inspection types but can use existing checklists for conducting inspections.
Video
Step-by-Step Guide
1. Click on Inspections.
2. Click on Inspection Types.
3. Click on Import XLS to download the template.
4. Click on Download sample spreadsheet.
5. Sample Spreadsheet with example data.
6. Column A - Inspection Type.
Enter a name for the new Inspection Type.
Copy and paste for all rows added to the checklist.
7. Column B - Section.
Enter checklist Section names.
8. Column C - Question.
Enter Checklist Item (Inspection Question).
Enter a name for the Sub-category to create a subcategory in your checklist.
Character count for the Question is 2,500.
9. Columns D, E & F - Code Set, Edition Year & Code Number.
Enter data as needed to associate a code with the Checklist Item.
This step is non-mandatory.
10. Column G - Question Type.
Enter a question type as displayed for each Checklist Item.
Note formatting with the underscore between words.
Examples:
standard_inspection
single_select
multi_select
free_text
group_name (Used to create Subcategories)
Note that data is ignored for the Free Text question type in Column H.
Note that data is ignored for the Group Name question type in columns D, E, F, H, & I.
11. Column H - Answers.
Enter answers for single select and multi select with a comma between answers.
Enter Standard Inspection Responses with an underscore between text.
NOTE: Spelling has to match you set-up for Standard Inspection Responses.
12. Column I - Mandatory.
Yes for mandatory response for the checklist item.
No or no data will make the Checklist item non-mandatory.
13. Save your checklist template as a .xlsx file type.
14. To import your checklist, click on Import XLS.
15. Select Choose File and select the file to import.
16. Click on Import.
17. You should see this banner upon successful importation of the Checklist.
18. If errors are present in your template, you will see this error message.
Fix the error(s) noted and reimport.
19. Click on Edit to complete the set-up of the Inspection Type and Checklist.
20. Update Inspection Type, if desired.
21. Select a Default Schedule, if desired.
22. Click on Inspection Timer, if desired.
23. Update Signature requirements as desired.
24. Click on Billing and set your Billing option.
25. Click on Checklist to edit your checklist as needed.
26. Click on Forms , set Default Answers for the form and select which form(s) to use.
27. Click on Email and set your email options.
28. Click on Save.
Best Practices
Template Preparation:
Review existing inspection requirements before creating your template
Group related questions into logical sections for easier field use
Use clear, specific language for inspection questions
Test your template with a small sample before importing large checklists
Question Types:
Use standard_inspection for most pass/fail scenarios
Reserve free_text for situations requiring detailed explanations
Group related items using group_name to improve checklist organization
Error Prevention:
Double-check spelling in Column H against your Standard Inspection Responses
Ensure consistent Inspection Type names across all rows
Verify question types use proper underscore formatting
Save files in .xlsx format only
Troubleshooting & FAQs
Import Errors:
If you receive error messages during import, common issues include:
Incorrect question type formatting (missing underscores)
Mismatched Standard Inspection Response spelling
Invalid file format (must be .xlsx)
Missing required data in mandatory columns
Template Issues:
Character limit exceeded: Questions over 2,500 characters will cause import failures
Formatting problems: Ensure question types match exactly as specified
Missing data: Verify all required columns contain appropriate information
Post-Import Configuration:
Checklist not appearing: Verify the import success message appeared
Questions out of order: Edit the checklist manually to reorder items
Missing answer options: Check Column H formatting and re-import if necessary
Frequently Asked Questions:
Q: Can I edit the checklist after importing?
A: Yes, use the Edit function to modify questions, add items, or change settings
Q: What happens to existing inspection data if I update a checklist?
A: Existing completed inspections retain their original data; changes only affect new inspections
Q: Can I import multiple inspection types at once?
A: No, each inspection type requires a separate import process
Purpose Statement The Inspection Type feature allows Fire/EMS agencies to create standardized inspection processes for various property types and compliance requirements. This functionality enables departments to maintain consistent inspection ...
Purpose Statement This article demonstrates how to create and edit comprehensive inspection checklists within the Fire/EMS software platform. Inspection checklists enable departments to standardize their inspection processes, ensure regulatory ...
Purpose Statement This guide demonstrates how to efficiently complete inspection checklists within the Inspection Record module. The checklist system enables fire and EMS personnel to conduct standardized inspections, document violations, add ...
Purpose Statement The Import Fee Schedule feature allows administrators to efficiently bulk upload multiple fee schedule items into the system using a standardized Excel template. This feature streamlines the process of setting up billing structures ...
Purpose Statement This feature enables sequential numbering for checklist items on inspection forms, providing clear organization and easy reference for inspectors and administrators. The numbering system improves documentation accuracy, enhances ...