A small spreadsheet may be perfectly adequate at the start. Trouble begins when several people maintain their own versions and nobody knows which pump entry is current. The important choice is how the team will maintain a trusted record.
Start with one equipment mismatch
Two engineers enter the same pump under different tags. Searching its description cannot establish whether these are two assets or two descriptions of one asset. Identity, location and signal relationships need a consistent rule in whichever tool you use.
Match the tool to the work
| Work to do | Useful option to evaluate |
|---|---|
| Temporary calculations and free-form analysis | A spreadsheet offers flexibility. |
| Shared records with defined fields and relationships | Try a structured engineering register. |
| Moving an existing equipment list | Check import preview, mapping and validation. |
Move a small, representative set first
- 01
Select a manageable set of real equipment and tidy the column names.
- 02
Make units, tags and unknown values explicit before importing.
- 03
Preview the file and check column mapping and the duplicate policy.
- 04
Compare imported records and relationships with the source, then review validation findings.
Agree where corrections will happen
After migration, choose the authoritative editing location. Independently updating both the spreadsheet and register recreates the original disagreement. Validation can flag inconsistent data; it does not certify the design or verify field wiring.
Frequently asked questions
Must we stop using Excel?
No. Keep it for suitable analysis and exchange, while making the trusted record clear to the team.
Does a duplicate tag always mean a duplicate asset?
Not necessarily across separate scopes. Check the naming boundary and location before deleting anything.
Should an empty value become zero?
Only if zero is the actual value. Unknown, not applicable and zero carry different meanings.
Can we discard the source after import?
Retain it under your records policy until reconciliation and evidence requirements have been settled.