How to Migrate From Spreadsheets to a Free CMMS
A practical, step-by-step way to move your maintenance and OEE tracking off spreadsheets into a free browser-based tracker, bring the history you already have with you, and make the new logging habit stick.
The short answer
- Export your maintenance sheet to CSV, then import it into the free OEE Lab tracker, so your shift history lands in a real dashboard instead of a formula that breaks when someone moves a column.
- Rebuild the structure once: add your machines to the asset register, set recurring PM tasks, and log each new shift in about 2 minutes so reason codes and OEE stay consistent across every shift.
- It all runs in your browser with no account, giving you OEE with availability, performance, and quality, a downtime Pareto, a work order board, and CSV/JSON export you own, for free.
- When one plant on one device stops being enough and you want OEE read straight off your PLCs with detected losses auto-routed to work orders, that is where Fabrico takes over.
Spreadsheets are where almost every plant starts tracking maintenance and OEE, and for good reason: they are free, everyone knows them, and you can stand one up in an afternoon. The trouble shows up after a year, when formulas break on a bad row paste, only one person can safely edit at a time, and nobody trusts the downtime totals because every shift typed the reason codes differently. This guide walks through moving off that sheet into a free OEE tracker and light CMMS without throwing away the history you have built, and the free CMMS vs spreadsheets breakdown covers when a sheet is still fine.
The migration itself is short. Export your existing log to CSV, use the tracker's Import history button to load past shifts, and you start with a populated dashboard rather than a blank slate. From there the structural wins arrive for free: the OEE, availability, performance, and quality maths are calculated for you, a downtime Pareto ranks your real losses, and reactive fixes move onto a proper work order board instead of a hidden tab.
None of this asks you to pay anything or wait on IT. If you want the full setup sequence, the how to implement a free CMMS walkthrough sequences assets, PMs, and roles in order, and the wider free manufacturing software guide shows what else is on the table before you spend a euro.
What you get, free
Import your spreadsheet history
Export your existing maintenance or OEE log to CSV and load past shifts with the Import history button, so you migrate onto a full dashboard instead of starting from zero.
OEE and A/P/Q calculated for you
Once shifts are in, the tracker does the maths every spreadsheet forces you to build and maintain by hand: OEE with availability, performance, and quality broken out, plus a comparison against the 85% world-class benchmark.
A downtime Pareto from consistent codes
Structured reason codes replace free-typed spreadsheet cells, so your losses rank in a downtime Pareto you can actually trust across shifts and people.
Work orders, PM schedule, and asset register
The reactive fixes and recurring tasks that lived in scattered tabs move onto a real work order board, a preventive maintenance schedule per asset, and a machine-by-machine register.
Export CSV, back up and restore JSON
Your data stays yours: export shifts and work orders to CSV any time, or download a full JSON backup and restore it on another device. No lock-in, ever.
No account, browser-local, installs as a PWA
Everything lives in your browser with no sign-up wall, and you can Add to Home Screen to run it full-screen on the tablet next to the line.
Log one shift and the free tracker shows your OEE, your loss Pareto and how you compare to world-class. Add work orders and preventive-maintenance reminders in the same place.
Where free stops, and Fabrico begins
The free tracker is built for getting started fast and for one plant on one device. When a site gets serious about its losses, the manual steps start to cost more than they save. This is exactly where Fabrico takes over.
| Capability | Free OEE Lab tracker | Fabrico |
|---|---|---|
| Data capture | Import your old sheet once, then log each new shift by hand in about 2 minutes, data stays in your browser. | Reads OEE automatically off your PLCs, no manual entry once you are live. |
| Micro-stop cause | You investigate sub-5-minute stops yourself and note the reason, same as you did in the sheet. | Computer vision identifies the true cause of each micro-stop, with video evidence. |
| Loss-to-fix loop | You spot the loss, then raise the work order yourself on the board. | A detected loss becomes an auto-routed work order through the closed PLC-to-work-order loop. |
| Scope and multi-site | One plant on one device and browser, best for a single line or shift. | Plant-wide and multi-site from one central view. |
| Integrations | Standalone, run it on its own, export data to CSV or JSON when you need it elsewhere. | Integrates with PLCs, MES, and ERP so OEE flows with your stack. |
| Access and roles | Local device sign-in with people and roles on that one device. | Org roles across the plant with a full audit trail. |
| Data residency | Your data lives in your own browser storage on your device, just like the file did. | EU-built with EU data residency, outside the reach of the US CLOUD Act. |
| Reporting | Instant OEE, a downtime Pareto, a printable PDF report, and a shareable scorecard you run yourself. | Live plant-wide dashboards plus scheduled reports. |
| History and ongoing migration | A one-time CSV import brings your spreadsheet history across, then new data is entered by hand. | History and every new shift are captured continuously off the PLCs, with no re-keying from a sheet. |
Frequently asked questions
How do I get my existing spreadsheet data into the free tracker?
Export your maintenance or OEE log from Excel or Google Sheets as a CSV, then open the free tracker (oee-tracker.html) and use the Import history button on the shift log. Your past shifts load into the dashboard so you begin with real OEE and a downtime Pareto instead of an empty tool. If your sheet is messy, tidy the columns to a consistent header first, since clean reason codes are what make the Pareto trustworthy afterwards.
Will I lose my spreadsheet history when I migrate?
No. The migration is additive: your original file stays exactly where it is, and the CSV import copies that history into the tracker. On top of that, the tracker lets you export back to CSV or download a full JSON backup any time, so you always keep a portable copy. Nothing is locked in, and you can restore that backup onto another device whenever you need to.
Do I have to rebuild all my OEE formulas?
That is the part you get to delete. Where a spreadsheet makes you build and maintain the OEE, availability, performance, quality, and Pareto formulas by hand, the tracker calculates all of it automatically the moment a shift is logged or imported. You migrate the data, not the fragile formulas, which is the main reason the numbers stop breaking after a bad edit.
How do I keep the logging habit going after the migration?
Make it faster than the sheet was. A shift logs in about 2 minutes, so put the tracker on the tablet next to the line (installed as a PWA via Add to Home Screen) and log at end of shift while the causes are fresh. Assign the work order board and PM reminders to real people so the tool has a job every day, not just at month-end. Consistency in reason codes is what turns daily logging into a downtime Pareto worth acting on.
Is my data private once it leaves the spreadsheet?
Yes. The free tracker keeps everything in your own browser storage on your device, with local sign-in for people and roles, and no account required. That is a genuinely private, single-device setup, the same privacy posture your local spreadsheet had. If you later need organization-level privacy, EU data residency, and an audit trail, that is a platform question rather than a device one, which is where Fabrico fits.
When do I outgrow the free tracker and need more than a migration?
The clear signals are the same ones that pushed you off the spreadsheet, only bigger: more than one line or site needing the same live number, hours each week spent hunting the cause of micro-stops, or an auditor about to ask for a trail. At that point manual entry, even fast manual entry, is the bottleneck. Book a Fabrico demo to see OEE read automatically off your PLCs, computer vision pinpointing the true cause of each micro-stop with video, and detected losses auto-routed into work orders.
When free is not enough, Fabrico is the upgrade
Migrating off a spreadsheet into the free tracker is the fastest honest way to get consistent OEE numbers and a real work order board without paying anything, and it works genuinely well for one line on one device. The ceiling is the same one the spreadsheet had: someone still enters the data by hand, investigates every micro-stop themselves, and raises each work order manually. Fabrico removes that manual layer by reading OEE straight off your PLCs, using computer vision to identify the true cause of each micro-stop with video evidence, and closing the loop so a detected loss becomes an auto-routed work order. It is EU-built with EU data residency, outside the reach of the US CLOUD Act, and its ISO 27001, 20000-1, and 9001 certifications support audit-readiness. When your migrated tracker starts feeling like a faster spreadsheet rather than enough, book a Fabrico demo and see what automatic capture looks like on your actual lines.
Book a Fabrico demoMore free software: All free software · Free CMMS + OEE Software: the Loss and the Work Order in One Tool · Free downtime tracking software: log stops by reason, get a downtime Pareto instantly · Free maintenance management software: work orders, PM, and assets, no cost · Free maintenance scheduling software
Free OEE tracker and light CMMS · Free CMMS vs spreadsheets · How to implement a free CMMS · Free downtime tracking software · Free manufacturing software options · What is OEE, explained