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.
• 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.

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.
• Inspection code sets — Import the code references your inspections program runs against — section numbers, titles, edition labels, categories, and links — into a new or existing code set.
• 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.

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, training history, 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.
• 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