Excel Training Tracker to LMS: How to Move Without the Mess

Almost every company starts tracking training in Excel. One sheet with names, courses and dates. Someone in HR updates it after each session, and it works well enough for a team of thirty.

Then the company grows. The sheet gets copied for each location. A manager keeps their own version. Columns are added, renamed and forgotten. When someone asks a simple question, such as who has not finished this year's safety training, the answer takes a day and nobody fully trusts it.

This post is a practical plan for moving your training tracker from Excel to a learning system, step by step, without making a mess of the move itself.

Signs your Excel training tracker has stopped working

A spreadsheet is not the problem on day one. It becomes one slowly. Look for these signs:

• There are several versions. "Training_Tracker_Final_v3_updated.xlsx" sits next to two other files, and nobody is sure which is current.
• Updates depend on one person. When that person is on leave, the sheet stops being updated.
• Completion is typed in by hand. Someone marks a cell "Done" based on an attendance sheet or a WhatsApp reply.
• Nobody can see their own status. Employees and managers have to ask HR whether a course is complete.
• Reports take days. Every audit or management review means filtering, copying and checking by hand.

If three or more of these sound familiar, the sheet is costing you more time than it saves.

What to bring across, and what to leave behind

The biggest mistake in a move is trying to bring everything. Old sheets are full of half-filled columns, people who left years ago and courses that no longer exist. Moving all of that only moves the mess.

Bring across:

• Your current people: name, email, department, designation, employee ID and mobile.
• Your departments, cleaned up so the same team does not appear under two names.
• The courses that are still required, rebuilt as proper courses with a short quiz where it matters.

Leave behind:

• People who have left, unless you need them for a specific audit.
• Columns nobody uses.
• Past completion history, as live data. Keep the old sheet as a locked, read-only archive instead.

That last point needs a word. Past completions in a spreadsheet were typed in by hand, so they are only as reliable as the person who typed them. Keep the file safe and dated, so you can answer questions about the past from it. Start fresh, trusted records in the new system from the day you move.

Clean the list before you import

A clean import saves days of fixing later. Before you upload anything:

1. One row per person. Remove duplicates, especially people listed in two location sheets.
2. Check every email address. It becomes the person's login, so a typo means they cannot sign in.
3. Use the same department names everywhere. "Sales", "sales team" and "Sales Dept" should become one name.
4. Fill employee IDs where you have them. They help match people later, even if names are spelt differently.
5. Split the file if it is very large, by location or department, so each upload is easy to check.

Moving your training tracker in five steps

1. Set up departments and roles. Decide who is an admin and who only learns.
2. Import people in batches. Start with one department, check the result, then do the rest.
3. Build or upload the required courses. Start with the ones auditors ask about first.
4. Assign courses to departments or groups, with a due date.
5. Run both for one cycle. Keep the old sheet read-only for a month, so people have something to compare against while they get used to the new reports.

After the first cycle, stop updating the spreadsheet completely. Two live sources of truth is worse than one.

Before and after: Excel vs an LMS

Common mistakes to avoid

• Importing everyone at once and finding a column mismatch after 400 rows.
• Not telling people that the new system is coming, so invite emails are ignored.
• Copying old course names without checking if the content is still correct.
• Keeping the old sheet alive "just in case", so updates go to both places.

Where to start

1. Pick one owner for the move.
2. Clean one department's list using the steps above.
3. Import it and check every row.
4. Assign one required course to that department.
5. Check the report after a week, then roll out to the next department.

In ElevityHub, you can import people from a CSV or Excel file, with name, email, department, role, designation, employee ID and mobile. Each file can have up to 500 rows. A check-only run shows what will happen to each row before anything is saved, and you can download the rows that need fixing. New departments are created as you import. Once courses are assigned, progress reports can be filtered by department, course or status and exported to CSV. You can set it up yourself in minutes.