Moving from a spreadsheet to HabitSync

You can bring your history with you. Export it, map your columns once, and every day you logged comes across dated as the day you logged it. It is free and takes about a minute.

What a spreadsheet is good at

It is yours, it does exactly what you told it to, and nobody is going to sunset it or start charging for it.

A spreadsheet cannot remind you, and it will not tell you anything you did not already work out yourself. Most people also describe the upkeep as a second job: the notes column is the first thing to go.

Getting your data out

  1. Open your sheet and make sure there is one row per day and one column per thing you track.
  2. Download it as CSV, or just select the rows and copy them.
  3. You can paste straight into the importer. There is no need to save a file at all.

Export menus move around. If these steps do not match what you see, look for anything that says export, backup or download, and pick the CSV.

Bringing it in

  1. Make a free account. No card, and the import works on the free plan.
  2. Go to Profile, then Account, and choose Import from a spreadsheet or another app.
  3. Upload the file, or paste the rows straight in.
  4. Check what each column is. We guess, you correct anything wrong.
  5. Look at the summary of what is about to be added, then bring it in.

What comes across

Whatever you tell it to. The importer reads your headers, guesses what each column is, and shows you every guess to correct before anything is saved. Your own words for done, whether that is an x, a tick, a 1 or the word yes, are all recognised.

What does not

Formulas, charts and conditional formatting. Those were doing the analysis job, and the point of moving is that you stop maintaining them.

And you can leave too

The export sits next to the import, on the same free plan. Everything you log comes back out as a CSV whenever you want it, including your medication history. That is the whole reason this page can exist: nobody should be stuck somewhere because their record is.