Moving Your Old Spreadsheet Into a Tracker Without Losing History

Most of us start logging in a spreadsheet. It's free, it's on your laptop, and it does the job for a while. Then the tabs pile up, the old files get renamed, and you're not sure which version has your last few bloodwork results in it. Moving that history into a tracker is worth doing, but only if you do the prep first. Import a CSV or Excel log badly and you'll spend a weekend fixing rows you could have cleaned in twenty minutes.

Here's how I'd go about it.

Get all your files into one place before you import a CSV or Excel log

Before you touch any import button, gather everything. Dig through your downloads folder, your cloud drive and that old USB stick. You're looking for every file that holds numbers you care about: weight, body measurements, bloodwork results, phase notes, check-in dates.

Once you've found them, work out which file is the master. If you've been keeping a blast and cruise log in one tab and a weight log in another, decide which one has the fuller history. Don't merge them yet, just label them.

A few things to check:

• Open each file and confirm it actually loads. Corrupted files happen.
• Note the date range each one covers, so you can spot gaps later.
• Make a copy of everything into a single folder called something obvious, like "log-export".

That folder is your safety net. Even if the import goes sideways, you've lost nothing.

Clean the columns so each one means one thing

Spreadsheets let you do anything, which is exactly the problem. You might have a column called "weight/notes" where some rows hold a number and others hold a sentence. That's fine for your eyes, but an import needs structure.

Go through your columns and give each one a single job:

• One column for the date, nothing else in it.
• One column for the weight value, numbers only.
• Separate columns for each body measurements you track, such as waist or arm.
• A notes column for anything freeform.

Delete empty columns and any half-finished scratch calculations off to the side. If you've got merged cells, unmerge them. If you've got a header row that spans two lines, squash it into one. Keep the header names short and consistent, because they'll become your field labels in the tracker.

This is also the moment to settle on units. If half your history is in one unit and half in another, pick one and convert the rest now, while you can still see the original file next to it.

Sort out your dates, because they break more imports than anything

Date formats are the usual culprit. A spreadsheet might read 03/04 as March the fourth or the third of April depending on where it was made, and an import will happily take whichever it decides.

Pick one format and apply it to the whole column before you export. Something unambiguous like 2024-03-04 is safest. Then scan the column for anything that isn't a real date: blanks, text like "around then", or a stray year with no month.

If you've kept bloodwork results across several test dates, check that each date is on its own row and matches the file the lab sent you. You want to be able to compare your own results side by side later, and that only works if the dates are right.

Export to CSV and check it with your own eyes

Once the sheet is clean, save a copy as CSV. Open that CSV in a plain text editor or a fresh spreadsheet and look at it. You're checking for three things:

• Every row is still there, including the oldest ones.
• No commas inside notes have pushed values into the wrong column.
• The header row reads exactly how you want your fields labelled.

If something's off, fix it in the original spreadsheet and export again. Repeat until the CSV looks boring. Boring is what you want.

After the import, confirm your history landed intact

Run the import, then do a spot check rather than trusting it blindly. Pick a handful of dates from across your history, including the very first entry and the most recent, and confirm they're there with the right numbers. Check a few bloodwork results against the original lab files, since those are the ones you'll want to look back on.

Then use the app's own tools to keep things tidy going forward. You can log results from different test dates and compare your own results side by side over time, and the calendar gives you reminders and a feed for test dates and check-ins. Weight and measurement charts will draw themselves from what you type. If you ever want a second pair of eyes on your records, there's an optional read-only dashboard link you can share with someone you choose.

And if you spot a mistake weeks later, you can fix it. Entries are encrypted at rest, and you can export all your data or delete your account at any time, so nothing is locked away.

One last habit worth keeping: hang on to that original folder of spreadsheets. It costs you nothing and it's a decent backup while you settle in.

Your history, in one place

Moving years of records is a bit of a chore, but it's a one-off. Do the prep properly and you'll have your weight, body measurements, bloodwork results and phases in one tidy, private place you can actually look back through.

Registration only needs an email address and password, and you get an anonymous username assigned automatically, so no real name goes anywhere. It's free during early access, so you can create a free account and start importing today.