MantPro logo MantPro
  • Features
  • Apps
  • Why MantPro
  • Demo
  • Cloud
  • Pricing
  • FAQ
  • Download
👤My account
🌐 EN ▾
  • Español ES
  • English EN
  • Euskara EU
  • Català CA
  • Galego GL
  • Português PT
  • Français FR
  • Deutsch DE
Home › Guide: from Excel to a CMMS

How to move maintenance from Excel to a CMMS

By Daniel Serrano Armenta, industrial maintenance electrician

Almost every maintenance department starts with a spreadsheet: one tab for machines, another for preventive tasks with dates, another for spare parts. It works while one person is in charge of it. This guide explains when it is worth switching to a CMMS, how to prepare the data you already have and how to import it into MantPro, a free and open source CMMS, without typing it all again.

Signs that Excel is no longer enough

  • Preventive tasks get missed because nobody opened the file that day, and nothing reminds you.
  • There are several copies of the file (the manager's, the workshop's, the one in an email) and none of them is up to date.
  • Technicians don't have it to hand at the machine, so they write on paper and someone types it up later… or not.
  • You can't tell what was done to a machine last year, or what it cost.
  • Stock doesn't add up: parts get used and nobody deducts them.
  • An audit asks for the history and it takes days to put together.

If two or three of these sound familiar, a CMMS will save you more time than the switch costs.

Step 1: decide what to move

You don't need to move everything on day one. In order of importance:

  1. Assets: the foundation for everything else.
  2. Preventive tasks (recurring tasks): what makes the biggest difference from day one.
  3. Users: the technicians tasks are assigned to.
  4. Spare parts, if you run a storeroom.
  5. Open pending jobs.
  6. Past job history, if you have it and want to keep it.

Step 2: tidy up the asset list

This is the step that saves the most work later.

  • One clear, unique name per asset ("Compressor 2 building B", not "compressor").
  • Hierarchy: if one piece of equipment sits inside another (a line with several machines), say which is the parent. In MantPro you enter the parent or the full path, for example "Line 1 > Furnace".
  • Zone or building for each one.
  • Code if you already use them, and useful notes ("check the refractory every 6 months").
  • Remove duplicates: two rows for the same machine end up as two separate histories.

Step 3: turn preventive tasks into recurring tasks

In the spreadsheet they usually appear as "monthly inspection" plus a date. For the CMMS, each task needs:

  • A specific title ("Bearing lubrication – Pump 3").
  • Frequency (daily, weekly, monthly, yearly…).
  • Start date or last time it was done, so the next due date comes out right.
  • Grace days: how late it can be before it counts as overdue.
  • Assigned technician or trade, if any.

Preventive tasks based on running hours, cycles or kilometres are set up afterwards in MantPro, in each asset's meters. More in preventive maintenance.

Step 4: prepare the storeroom

For each spare part: name, code (if any), unit, current stock, minimum stock and location (zone, shelving unit, shelf and section). In MantPro, locations that don't exist yet are created automatically on import, and the opening stock is recorded as an "Initial stock" entry. More in spare parts inventory.

Step 5: import into MantPro

  1. Download MantPro and install it on the office or workshop PC.
  2. Sign in as an administrator and open File → Import from Excel/CSV…
  3. Click Download template if you want to start from a sheet with the columns ready, or pick your own Excel file (.xlsx) or a CSV straight away.
  4. Choose the sheet and what it contains (assets, items, alerts, users, pending jobs or history), or import the whole workbook at once.
  5. MantPro matches the columns automatically; check that each one goes to the right field.
  6. Choose what to do with records that already exist: skip them or update them with the file's data.
  7. Look at the row-by-row preview: what is new, what will be updated, what will be skipped and what has errors, with the reason.
  8. Click Import. A backup is saved automatically first, and if something fails nothing is changed.

Rows with errors can be saved to a separate file to fix and import again. Imported users get a temporary password they must change when they first sign in.

Download MantPro for free

Step 6: roll it out to the team

  • Print the QR labels and stick them on the machines.
  • Install the app on the technicians' phones using the QR code shown on the PC; it works offline.
  • Assign the first pending jobs and let technicians close them from their phones, with photos.
  • Stop updating the spreadsheet from day one: two systems in parallel always drift apart. Keep the old file as an archive.

Common mistakes when leaving Excel

  • Dates stored as odd text. Use Excel dates or the DD/MM/YYYY or YYYY-MM-DD format.
  • Old .xls files. Open them in Excel or LibreOffice and save them as .xlsx.
  • Repeated asset names without saying which line they belong to.
  • Wanting everything perfect before starting. It is better to import assets and preventive tasks, start working and fill in the rest as you go.

Frequently asked questions

Can I import my spreadsheet as it is?

Yes, as long as it has a header row and one row per record. MantPro matches the columns automatically and you can correct the matching before importing. You can also use its downloadable template.

What data can be imported into MantPro?

Assets, storeroom items, recurring alerts (preventive tasks), users, pending jobs and past job history, from Excel (.xlsx) or CSV.

What happens if I import the same file twice?

You choose what to do with existing records: skip them or update them. In the job history, entries with the same date and title are skipped.

What if the import goes wrong?

A backup is saved automatically before importing, and if there is an error nothing is changed. Rows with errors can be saved separately to fix them.

How much does it cost to switch to MantPro?

Nothing. MantPro is free and open source, with no limits on assets, tasks or users.

MantPro · AGPL-3.0 licence · AnabasaSoft
Made by Daniel Serrano Armenta, industrial maintenance electrician
Pricing Free CMMS Preventive maintenance Spare parts inventory QR labels Offline mobile app Guide: from Excel to a CMMS Guide: electrical preventive maintenance Who is behind it Contact
Legal notice Privacy Terms of service Data processing Cookies