From spreadsheet to asset register in one afternoon

When is a spreadsheet no longer enough?

A spreadsheet is a fine place to start a list. It struggles once the list has to remember things. When someone types over a cell, the old value is gone, and nobody knows who changed it or why.

The signs are easy to spot. There are several copies with names like "final" and "final 2". Two people edit at once, and one of them loses their work. Service dates are missed because nobody opened the file that week. Nobody can say who had the drill last month.

An asset register fixes this. Each item gets one record with its own history, reminders and holder. Moving across does not need a big project. If you follow the steps below, one focused afternoon is a realistic goal.

What is the plan for the afternoon?

Work through six steps in order. Cleaning usually takes the longest.

1. Make a copy of the spreadsheet, and work only on the copy.
2. Clean the copy, so a computer can read it without guessing.
3. Choose your categories and fields.
4. Import one category at a time, with a preview.
5. Check the result against the original.
6. Retire the spreadsheet, so there is only one place to look.

How do you clean the sheet?

Clean data imports quickly. Messy data turns into messy records that you then fix one by one. These rules cover most problems:

• One header row. Remove titles and notes above it, and unmerge every merged cell.
• One row per item. Delete blank rows, subtotal rows and grand totals.
• One fact per column. Split "Make and model" into two columns. Move remarks into a Notes column.
• One format per column. Write all dates the same way. Keep units out of number cells: put "Hours" in the header and only the number in the cell.
• One spelling per value. "Ford", "ford" and "FORD" should become one value, because such columns often become choice lists.
• Serial numbers as text. Format those columns as text, so leading zeros survive.
• No duplicates. Sort by serial number and look for repeats.
• Blank means unknown. Leave empty cells empty, instead of writing "n/a", "?" or "-".
• One sheet per kind of thing. Vehicles, tools and laptops go into separate files.

If one list points to another, such as items to their suppliers, bring in the list being pointed to first. Spell names the same way in both lists, including the names of people and places.

Do not fill gaps with guesses. In TagOrbit almost nothing is required and a record always saves, so an item with gaps can come in now and be completed later.

How do you choose categories and fields?

A category is one kind of thing that shares the same questions. Vehicles and laptops are different categories, because you ask different things about them. Laptops and desktops can share one category, with sub-types for the few fields that differ.

People and companies are not items. Customers, suppliers and staff go into their own lists as contacts. Things that happen, such as rentals, purchases and services, are events. Related categories are grouped into departments.

Then go through your columns one by one and ask: does anyone use this? If not, leave it behind. For each column you keep, pick the field type that matches its content:

Columns that say who has an item, or where it is, need the same care as the rest: one spelling per person and per place. They also show only the present. From then on, the register keeps the history. In TagOrbit, custody keeps each hand-over as a dated span with a name, never an overwritten field. Locations can sit inside each other, such as Warehouse, then Shelf A.

You do not have to design all this on a blank page. In TagOrbit you can describe your business in one sentence and let AI propose categories, fields, alerts and departments. You can also start from one of 14 ready-made starter setups. Or pick a blueprint from the gallery: only the structure travels, never anyone's data. Fields are built in a drag-and-drop form builder.

If your list is mostly computers and software licences, also read the guide to tracking laptops, licences and leavers.

How does the import work?

Always import with a preview. A good import shows what it will create before anything is saved, so you can fix a wrong match before it creates wrong records.

Give your columns clear headers, such as "Purchase date" instead of a private shorthand, so each one is easy to match. The preview is your test: read the first rows closely, field by field, before you confirm. Bring in one category at a time, each from its own file.

In TagOrbit you import CSV or Excel files. The preview shows the result before anything is saved. Columns are matched to fields automatically, with AI helping, and you can change any match.

How do you check the result?

Never trust an import you have not checked. These checks are quick:

1. Compare the counts. The number of records should match the number of rows in the sheet.
2. Open a few records at random, and compare each one with its row.
3. Look at dates where the day is 12 or lower, such as 3 April. Day and month can swap there without any error message.
4. Read each choice list, and correct near-duplicates that slipped through.
5. Compare money totals. In TagOrbit, a report on the category with a grand total shows the sum of a money field. It should match the sum in your sheet.

Fix mistakes in the register, not in the old sheet. In TagOrbit, every change keeps its before and after, with who made it and when.

How do you retire the spreadsheet?

Two lists that both look current cause more trouble than one old list. So pick a switch-over day and tell everyone: from that day, changes happen only in the register.

Then make the spreadsheet read-only, add "Archive" and the date to its name, and move it out of the folder people open every day. Keep it for reference, without edit rights.

Retiring the sheet does not lock your data in. In TagOrbit, export is available everywhere, and you can export your data at any time as CSV or Excel.

Once the items are in, a label on each one takes people straight to its record. The guide to labelling your equipment explains what to print and where to stick it.

Where does TagOrbit fit?

TagOrbit gives your list a proper home: an import with a preview and column matching, fields for the usual column types, and no limit on records. It costs €22 per user per month with every feature included, as set out on the TagOrbit pricing page. Start free and import your first category this afternoon.