Bulk Data Import: Move Your Records Into Command Established

Switching software shouldn't mean re-typing years of records by hand. Whether your department is coming from another RMS, a stack of spreadsheets, or a filing cabinet's worth of binders, Command Established is built to get your existing data in fast — and to let you take it back out whenever you want.

Most departments already have their data somewhere: an inventory spreadsheet a captain has maintained for years, a hydrant list from the water district, a roster in a shared drive. Bulk import turns those files into a working system in minutes instead of weeks of manual entry.

How Bulk Import Works

Every bulk import in Command Established follows the same simple path, so once you've done one you know how to do them all:

1. Upload your file. Drag in a CSV exported from your spreadsheet or old system. You'll see a preview of the first few rows to confirm you grabbed the right file.
2. We map your columns for you. Command Established reads your column headers and sample data and figures out which columns map to which fields — automatically. You don't have to match up fields by hand or rename your headers to match ours.
3. Review before anything is saved. You get a row-by-row preview of exactly what will be created. Exclude rows you don't want, fix anything that needs a tweak, and confirm only when it looks right.
4. Import. Command Established creates the records in bulk. Nothing is written to your department until you give the final go-ahead.

Note: Because import is reviewed before it commits, you're never one bad spreadsheet away from a mess. If a file isn't quite right, exclude the problem rows or start over — nothing is saved until you confirm.

Importing Inventory

Inventory is where most departments have the biggest pile of existing data — and it's where bulk import shines.

If you have equipment in a spreadsheet, export it to CSV and upload it. Command Established's import tool reads your columns and maps them to the right inventory fields, even when your headers don't match ours exactly. "DOM" or "Mfr Date" both become the manufacture date; "S/N" becomes the serial number. No manual field matching required.

What gets imported

A single import can populate far more than just item names:

• Identity — Item name, manufacturer, model, serial number, asset tag, barcode, size, and description. Imported barcodes work with the camera scanner right away, as long as they contain only letters, digits, hyphens, and underscores — the import accepts other characters (spaces, slashes, periods), but the scanner and barcode lookup ignore them.
• Condition & lifecycle — Condition, purchase date, in-service date, purchase price, current value, warranty expiration, manufacture date, and retirement-due date.
• Compliance — ISO/FSRS equipment category, applicable compliance standard, and certification expiration — so your gear lands ready for audit reporting.
• Assignments — Where you list a person, apparatus, or storage location, Command Established matches it against your existing roster, rigs, and locations and assigns the item automatically. If it can't find a confident match, the item still imports — just unassigned, so you can place it later.

Tip: You don't need a perfect spreadsheet to start. The only field that's truly required is the item name. Everything else is optional — import what you have today, and fill in the rest over time.

Inventory CSV template

Starting from scratch, or want to know exactly which columns we read? Download our template, fill it in with Excel, Google Sheets, or Numbers, and save it as CSV.

Download the inventory CSV template

The template has a column for each inventory field the importer can fill in, plus three example rows: an SCBA pack on an apparatus, a turnout coat issued to a member, and a consumable stocked at a station. Delete the example rows before you import. Delete any columns you don't need, too. Only Item Name is required.

Tip: Set up your categories, apparatus, stations, and storage locations, and add your members, before you import. The importer matches the Category, Assigned To, and Storage Location columns against what already exists, so items land in the right place the first time.

You don't have to use the template. Columns with other names, extra columns, and a different column order all work. The template is there so you don't have to guess. The ISO/FSRS equipment category isn't a column because the importer works it out from each item's name.

Review every item before it's saved

After processing, you'll step through your items and see exactly how each one was interpreted, with the original spreadsheet values shown alongside. Edit anything that needs adjusting, exclude rows you don't want, and then import only the items you've approved. It's the fastest way to migrate from a spreadsheet-based system without giving up control over what actually lands in your department.

See Inventory Management Best Practices for what to do once your equipment is in — categories, locations, inspections, and ISO readiness.

More Than Inventory

Inventory is the most powerful importer, but it's not the only one. Bulk import is available across Command Established for the records departments most often arrive with already in hand:

• Fire hydrants — Import your entire hydrant inventory from a CSV — numbers, GPS coordinates, type, ownership, water source, ports, colors, flow and static/residual pressures, install dates, and inspection history. Perfect for loading a list handed over by your water district.
• Policies & SOPs — Already have your standard operating procedures as PDFs? Upload them and Command Established extracts the content into editable, versioned SOP records — no copy-and-paste.

Certificates

Have a folder of certificate PDFs and wallet-card photos? Training › Certifications › Bulk upload takes up to 25 files at a time. AI reads each one — name, issuing authority, certificate number, dates, hours — matches it to a member on your roster and to a certificate definition, and queues it for a quick admin review before it lands on the member's record. Members can also submit their own certificates from their personnel page. See Bulk Certificate Upload with AI Parsing.

Note: We're continually expanding self-serve bulk import to more modules. Don't see a one-click importer for what you need yet? Read on — we'll still get your data in.

Bringing the rest of your data over

For any records that don't yet have a self-serve importer — personnel rosters, apparatus, incident records, and more — we'll help you migrate. Send us what you've got, in whatever format you've got it (a spreadsheet, an export from your old RMS, even a messy one), and our team will work with you to bring it into Command Established. Onboarding a new department should never mean starting from a blank slate, and with us it doesn't.

Tip: The best time to ask about migrating your historical data is during onboarding. Reach out to support@commandestablished.com with a sample of what you have and we'll tell you the fastest path to getting it in.

Your Data Is Always Yours

Here's a promise we don't make quietly: whatever you put into Command Established, you can always get back out. We don't hold your records hostage, we don't charge an exit fee, and we don't trap your data in a format only we can read.

• Inventory exports to Excel or CSV — full reports or a selection of items, with the columns and grouping you choose. You can also pull a cost report for spend analysis.
• Training compliance exports to CSV — your full ISO compliance picture, member by member.
• Training records export to an Excel workbook from the training report — every session, every member's hours, instructors, and one row per person per session.
• Payroll exports to CSV that drops straight into your payroll processor.
• Hydrant inspections export to CSV over any date range.
• Budgets export to a complete Excel workbook — categories, line items, expenses, revenues, and grants.
• SOPs, permits, and invoices generate clean PDFs ready to print, file, or send.

These are open, universal formats — CSV, Excel, PDF — that open in any spreadsheet program or PDF reader on earth. No proprietary lock-in, ever.

Need everything at once? Want a complete copy of your department's data rather than a module-by-module export? Just ask. Email support@commandestablished.com and we'll get you a full export. Your data belongs to you, no matter what.

To understand the bigger picture on data ownership and avoiding lock-in, see Future-Proofing Your Department's Data.

Frequently Asked Questions