📄 How to Migrate HVAC Equipment Lists from Centriq and Excel to your Phone

When it comes to managing a large portfolio of commercial mechanical rooms, residential rentals, or a busy facility service fleet, the hardest step isn't tracking the equipment—it's getting the data into the system in the first place. Excel sheets, vendor spreadsheets, and exports from discontinued software contain years of critical maintenance records. Typing them in one by one is a labor cost nightmare that kills digital tracking before it even starts.

That is why we just rolled out our new Universal CSV Importer. It is a fully client-side, offline-first CSV migration wizard built directly into both the desktop web dashboard and the mobile app. The best part? It is 100% free for all users. You can migrate your entire fleet in minutes without paying a cent or talking to an onboarding sales representative.

A Replacement for Centriq (and Other Discontinued Systems)

Many homeowners and property managers were left stranded when Centriq officially shut down and discontinued its consumer home management services earlier this year. Centriq was a popular platform for digitizing appliance details, but when its servers went dark, users were forced to export their data or risk losing it forever. If you were one of the thousands who grabbed your Centriq CSV data export before the shutdown, you can upload it directly to Equipment Tracker Pro.

The importer isn't just for Centriq exports. It is designed to ingest standard `.csv` file exports from almost any spreadsheet, database, or legacy asset tracking tool on the market, including:

• ▸ Spreadsheets — Microsoft Excel, Google Sheets, LibreOffice Calc, or Apple Numbers.
• ▸ Field Service Systems — ServiceTitan, Housecall Pro, Jobber, or FieldEdge.
• ▸ Asset & CMMS Tools — EZOfficeInventory (EZO), ToolSense, OxMaint, Infraspeak, or UpKeep.
• ▸ Home Inventory Competitors — Homer, Dib, HomeZada, or Centriq.

How It Works: Clear, Visual Column Mapping

No two spreadsheets use the same column headers. One sheet might label a column as *Brand*, while another uses *Manufacturer* or *Make*. Our CSV importer scans your file's headers and automatically maps them to the correct fields in the app (labeled as *✨ Auto-Matched*).

If the automatic match needs adjustment, our clean left-to-right mapping UI lets you choose custom columns from a dropdown menu. Target fields are marked as *Required* or *Optional* with clear badges. Any unmapped columns (like purchase cost, dimensions, or custom notes) are automatically appended to each unit's Equipment Notes so you never lose a single byte of data.

Inline Back Buttons and Validation Previews

Before writing any records to the SQLite database on your device, the app loads a complete Validation Preview displaying the first ten mapped items. If the preview flags duplicate warnings (like an existing serial or asset tag match in your active portfolio), you'll see a yellow status badge.

If you notice a mapping error in the preview, you don't have to start over. We added prominent Back buttons at the bottom of the column mapping and preview screens so you can step backward, adjust your dropdown mappings, and verify again before committing the import.

Start Importing for Free Today

Unlike enterprise asset management suites that require multi-month onboarding, sales demos, and setup fees, our CSV importer is available instantly. On mobile, open the app, tap the orange Import ZIP / CSV button on the home screen, select your `.csv` file, and follow the 5-step wizard. On desktop, log in to the dashboard, click Import CSV, and drag-and-drop your spreadsheet.

Moving your data to a new platform can be daunting, but with smart auto-matching and native mobile and web wizards, you can bring all your mechanical systems under one roof today for free.

While bulk CSV importing is free for all users, backing up and syncing your imported equipment database to the cloud or web dashboard requires a Pro subscription at $9.99/month or $79.99/year per user.

Can I import Centriq CSV exports into the app?

Yes. Homeowners and property managers affected by the shutdown of Centriq can upload their CSV data exports directly to map and restore their mechanical and appliance profiles.

What happens to unmapped columns in my CSV file?

Any columns that are not mapped to standard equipment fields (such as purchase cost or custom attributes) are automatically appended to each unit's Equipment Notes so you do not lose data.

Does the importer validate my spreadsheet data before importing?

Yes. The tool shows a Validation Preview of the first 10 items, flagging issues like duplicate serial numbers or asset tags with yellow badges before writing to the database.

Is there a charge or limit for bulk CSV imports?

No. The Universal CSV Importer is 100% free with no limits on the number of equipment records you can import, running entirely client-side on your device.

Do I need a paid plan to sync my imported data?

While importing is free, syncing your database to other devices or the web dashboard requires a Pro subscription ($9.99/month or $79.99/year per user) for cloud database backup.

Jonathan Curtis

HVAC Technician & Founder · Equipment Tracker Pro

Jonathan Curtis is an HVAC technician and the founder of Equipment Tracker Pro. He built the app to solve real-world property handoff challenges — including the absolute nightmare of losing years of maintenance histories and having to reprint physical asset tags.