Importing your data

Bring your writing history with you.

The biggest reason people stay on a tracker they have outgrown is the data trapped inside it. Years of word counts feel impossible to move, so they stay put. Authorlytica imports a CSV, which means your history is portable: whatever you tracked before, you can carry it over. Your sessions, dates, and totals come with you.

Last updated June 16, 2026

The short version

Get your old history out as a CSV, upload it into Authorlytica, map a couple of columns, and your sessions are in. Authorlytica creates any projects named in the file. The rest of this is just the detail.

Export a CSV

From a spreadsheet or your old tracker, export your history as a CSV file.

Check the columns

Make sure each row has at least a date and a word count. A project column is a useful bonus.

Upload and map

Open import in your settings, pick the file, match the columns, and confirm. Authorlytica creates any projects named in the file.

Step 1: Export a CSV from wherever your data lives

Almost everything can produce a CSV:

  • A spreadsheet. Excel and Google Sheets both export CSV directly from the File menu. If you have tracked word counts in a sheet, you are most of the way there already.
  • Another tracker. Tools that offer a CSV export, such as TrackBear, hand you a file you can use straight away. Check the tool's settings or data page for an export option.
  • A tracker without export. Some tools, including older or closed apps, do not export cleanly. In that case, rebuild a simple sheet by hand with the history that actually matters to you. You rarely need every session from years ago.

Step 2: Make sure the columns make sense

The import needs a row per writing session and, at minimum, two things in each row:

  1. A date. When the session happened.
  2. A word count. How much you wrote that session.

Two optional columns make the result better. A project column lets the import sort sessions into the right books, and any project it names is created automatically. A unit column (words, pages, or lines) keeps things correct if you track in more than one. Extra columns you do not need are simply ignored, so an export from another tool usually only needs light tidying.

Step 3: Upload and map

Open import in settings, pick your file, match the columns. Date and words are required; project and unit are optional. Confirm once and the sessions come in. If a project in the file does not exist yet, Authorlytica creates it.

What transfers, and what does not

  • Transfers: your sessions, their dates, the word counts, and the projects they belong to. Your totals and charts include them right away.
  • Does not transfer: your actual prose. Authorlytica stores counts and goals, never your manuscript, so there is no text to bring across. Authorlytica never touches your writing, only the counts, which is also why export is unrestricted.
  • Back-dated imports fill in your history, but live streak logic keys off real-time activity, so a multi-year streak does not reconstruct itself.

And you can leave just as easily

The reason import matters is the same reason export does: your history should be yours to move. Authorlytica lets you export everything at any time, on every plan, with no email request and no waiting, including a full backup and a CSV of all your sessions. You can come in from a spreadsheet and, if you ever want to, walk back out to one. No lock-in is the point.

Coming from a spreadsheet for good?

If this import is you finally retiring a tracking spreadsheet, two reads will help: how to track your writing without spreadsheets and Authorlytica vs Excel. Both cover what you gain once the formulas are someone else's problem.

Bring your history. Keep your momentum.

Import your past word counts from a CSV. Your totals and charts start where your spreadsheet stopped. Export everything again any time you like. Free forever plan, no card.

Try Authorlytica Free