Fitbit data export to dashboard
A year of Fitbit days, without the zeros lying to you.
Export your data from the Fitbit dashboard, drop the CSV here, and daily totals become a year you can actually read. Step counts written with thousands separators are parsed as numbers instead of text, days where the tracker was off the wrist come through as zeros and are excluded from averages rather than dragging them down, and sleep minutes are kept separate from time in bed.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
A zero-step day is not a zero-step day
Fitbit records a row per calendar day whether or not you were wearing the thing. Charge it overnight and forget it on the desk, and that day arrives as zero steps, zero calories burned, zero everything. Ten days like that across a year is enough to move your average daily steps by several hundred, and there is nothing in the file marking them as different from a genuine day spent on the sofa. Distinguishing the two is judgment, and the honest approach is to treat a full row of zeros as no data rather than as a rest day.
The formatting problem is smaller but hits first. Fitbit writes large numbers with thousands separators, so a good day reads 12,431 and lands in your spreadsheet as text. Steps, Activity Calories and Calories Burned are the usual victims, which is to say the three columns anyone opens the file for. This page strips the separators, reads the values as numbers, and flags the all-zero days so you can decide whether to keep them.
How to export from Fitbit
- Sign in to the Fitbit web dashboard Go to fitbit.com and sign in with the account tied to the device. The export lives on the web, not in the phone app, which only offers a limited share of individual days.
- Open the data export settings Click the gear icon at the top right, choose Settings, then Data Export. This is separate from the full account archive request, which is a much larger and slower download.
- Pick a date range and the CSV format Fitbit limits how long a range you can export at once, typically about a month at a time, so a year takes several passes. Choose CSV rather than XLS if you want a clean parse.
- Select the data categories Activities, sleep and body are separate checkboxes. Tick all three if you want steps, sleep and resting heart rate on the same timeline, since they merge into one daily row.
- Download and drop the file here Separators are stripped on load, zero days are flagged in the summary, and Date becomes the axis for every panel without any format wrangling.
The month-at-a-time limit means most people end up with a folder of files. Merge them into one before loading if you want a year-long view, and check for a duplicated day where two ranges overlap.
Try with sample Fitbit data (the same columns, 91 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Fitbit names it.
- Steps by day. The headline series, with tracker-off days shown as gaps rather than as floor-hugging zeros that flatten the whole chart.
- Active minutes breakdown. Sedentary, lightly, fairly and very active as a stacked view, which is a far better read on a day than steps alone.
- Sleep against time in bed. Minutes Asleep inside Time in Bed, with the difference being how long you lay there awake. That gap is the actual sleep quality signal.
- Awakenings and sleep efficiency. Number of Awakenings against Minutes Asleep, which usually explains a day that felt bad despite a decent total.
- Resting heart rate trend. The slowest-moving and most informative number in the file. A week of elevated resting heart rate usually precedes noticing you are ill.
- Weight and calories. Weight where it was logged, against Calories Burned, for anyone tracking the two together over months rather than days.
Date,Calories Burned,Steps,Distance,Floors,Minutes Sedentary,Minutes Lightly Active,Minutes Fairly Active,Minutes Very Active,Activity Calories,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed,Resting Heart Rate,WeightWhat to watch in a Fitbit export
- Big numbers have commas in them. 12,431 steps is a string, not a number. In an improperly quoted file that comma can also split the column, which turns one row into two misaligned ones.
- Days with the tracker off are zeros. Not blanks. A row of zeros is indistinguishable from a genuinely sedentary day, and averaging across them understates every activity metric you have.
- Sleep and time in bed are separate columns. Minutes Asleep, Minutes Awake and Time in Bed measure three different things. Reporting time in bed as sleep is a flattering mistake almost everyone makes.
- Sedentary minutes include sleep. Depending on the device and settings, the Minutes Sedentary figure can absorb your overnight hours, which is why it so often sits near a thousand.
- The export range is capped. Roughly a month per download, so a year is a dozen files and the boundary days between two ranges are easy to duplicate.
- Weight is sparse by nature. It only exists on days you stepped on a scale or logged manually. Blank is correct there, and interpolating between weigh-ins invents data.
Strip the commas, throw out the days the tracker spent on a desk, and never confuse time in bed with sleep. Fitbit's daily grain is coarse compared to a sports watch, but it is consistent, and consistency over a year is what makes a trend real.
Frequently asked questions
Why won't my step count add up in a spreadsheet?
Because Fitbit writes thousands separators inside the number, so 12,431 is text rather than a value. Excel and Sheets will not sum text, and they will not tell you why the answer is zero. Find and replace the commas works, unless the file is unquoted, in which case that comma may already have split the column. This page strips the separators as it parses each cell.
Should I include days when I did not wear the tracker?
No, and the file will not tell you which they are. A day the device spent charging comes through as zero steps, zero calories and zero active minutes, identical in shape to a real rest day. Including them pulls every average down. The rule of thumb is that a row of zeros across all activity columns is missing data, and this page flags those rows and excludes them by default.
What is the difference between Minutes Asleep and Time in Bed?
Time in Bed is how long the device thought you were lying down. Minutes Asleep is how much of that it scored as actual sleep. The difference, along with Minutes Awake and Number of Awakenings, is the closest thing in the file to a sleep quality measure. Reporting time in bed as your sleep total typically overstates by thirty to sixty minutes a night.
Why are Minutes Sedentary so high every day?
Because on many Fitbit configurations that figure includes the hours you were asleep, so a normal day starts with seven or eight hundred sedentary minutes before you have done anything. It is not a sign of an unusually still life. If you want a waking-hours view, subtract Time in Bed from the sedentary total, and compare across days rather than reading the absolute number.
How do I build a full year?
Export month by month, since Fitbit caps the range of a single download, then merge the files into one keeping a single header row. Check the boundaries afterwards, because it is easy to include the last day of one range and the first day of the next as overlapping duplicates. Deduplicating on the Date column cleans that up in one pass.
Where does my health data go?
Nowhere. The file is read by JavaScript inside your browser tab and the charts are drawn from memory. A Fitbit export contains sleep patterns, resting heart rate and weight, which is health data in the ordinary and the legal sense. This page has no server, no account and no analytics on your file contents, so the only copy is the one on your disk.
Related tools
Load a quarter of Fitbit days and see the gaps
91 daily rows with comma-formatted step counts, a few days the tracker spent on a desk, sleep and time in bed as separate columns and a sparse weight log.
Open the sample Fitbit dashboard