How to Import Fire Extinguishers

🔥 Overview: Importing Fire Extinguishers

You have the option to import fire extinguishers in bulk rather than adding them manually to a building. To do so, an extinguisher group must first be created within the building. Once the group is added, you can import data directly into that group.

You can import using your own file or the sample template provided at the end of this article.

This article walks through how to import fire extinguishers at the building-level. 

🚨 Important: 

• Date Format: All date fields must be formatted as: YYYY-MM-DD (Example: 2026-01-01)
  • Before getting started, it is very important to review the required date format for any date fields in your file.
  • Incorrect formats will result in invalid rows during import. 
• Supported Fire Types: You can import your own file as long as it is one of the following formats:
  • .XLS .XLSX .CSV

📍 Step 1: Navigate to the Building's Fire Extinguishers tab

1. Navigate to the Building Detail screen
2. Click the Fire Extinguishers tab 
3. If needed, create the extinguisher group 
   • Enter a group name
   • Click the ➕ (plus) button

⬆️ Step 2: Upload Your File

1. To the right of the extinguisher group, click Import
   
2. Click Import on the next screen 
3. Add your file:
   • Drag and Drop 
   • Click to Upload 
   • Copy/Paste
     

🧾 Step 3: Select Header Row

1. If your file includes column headers, select the correct header row. If not, select No headers in this sheet 
2. Click Next to continue
   

🔗 Step 4: Map Your Columns

Match the columns in your file to the fields in Inspect Point. The system will attempt to auto-map fields, but you should always review them carefully.

Use the dropdown to select which column from your file should map to each template field. Naming may differ between your file and Inspect Point, so be sure to confirm each mapping is correct.

Once all fields are mapped correctly, click Next.

Example:

If your file has a column called 6 Year, you may need to map it to the Last Six Year Maintenance field in Inspect Point.

Helpful Tips:

• Use the Bulk Actions menu to:
  • Reset all mappings
  • Auto-map all columns (recommended to review after)
    

✅ Step 5: Verify Your Data

This step allows you to review the data before importing.

Invalid rows will be highlighted in red with the cells with the invalid date will appear in a darker red. 

⚠️ Common Issue: 

• Date Format: All date fields must be formatted as: YYYY-MM-DD (Example: 2026-01-01). 
• A value like 2026 alone will be marked invalid

❌ Invalid Data - Fixing & Deleting 

Fixing Invalid Data

To fix invalid date there are two options: 

1. Update the Original File - Fix the data in your original file then re-import. 
2. Fix Directly in the Tool - Edit the individual cells or use the Find & Replace option to bulk update. 
   • Example: Update all dates listed as 2023
     • Find: 2023
     • Replace with: 2023-01-01

Removing Invalid Rows

You can remove invalid rows individually or all at once. 

Individually - Click the X (remove) button all the way to the right of the row. 

Bulk Remove - Click the Remove all invalid rows option at the top of the table. 

🚨 Important:

• Invalid rows will not be imported 
• Removed rows will not be imported

🚀 Step 6: Complete the Import

Once everything looks correct:

1. Click Submit and wait for the processing to complete
2. A success message will appear

Viewing Imported Data

To view your imported extinguishers:

1. Go back to the building's Fire Extinguishers tab
2. Click into the extinguisher group

Your imported data will appear here.

🚨 Important:

Import time depends on the number of extinguishers.

If you don't see your data right away:

• Wait a few minutes and refresh the page
• Do not re-import immediately, as this may create duplicate records

📄 Using the Sample Template

You can also use the provided sample template.

Before uploading:

• Delete the second row (sample data)
• Keep the first row (headers)

If the sample row is not removed, it will be imported as an extinguisher.