Apple Health Duplicate Steps Checker

Why Apple Health looks like it's counting your steps twice

If you wear an Apple Watch and carry your iPhone, both devices detect your movement independently and each one writes its own step records into Apple Health. When you glance at the Health app, you see a single sensible daily number — because the Health app quietly deduplicates those overlapping records behind the scenes, giving priority to one source at a time so the same steps aren't added twice.

The trouble starts when you export your data. The raw export.xml file keeps every single record from every source, exactly as it was written. So the moment you load it into a spreadsheet and write =SUM() over the step column, you add the iPhone's steps and the Watch's steps together for every minute you had both devices with you. The result can look almost twice as high as reality. This is the single most common reason people believe "Apple Health step count is wrong" — the numbers aren't wrong, the raw export just isn't deduplicated for you.

What this tool actually does

It streams your export.xml, pulls out only HKQuantityTypeIdentifierStepCount records, and groups them by calendar day and by source (your iPhone, your Apple Watch, and any third-party apps like a treadmill or a pedometer app). Then it computes two numbers for every day:

• Naive total — the raw sum of every step record, the same number you'd get from a spreadsheet. This is the inflated figure.
• Deduplicated total — a corrected number that removes the double counting from overlapping sources.

How the deduplication is calculated

For each day the tool sorts every step record by its start time and walks through them in order, keeping track of the latest point in time already accounted for. Each record covers a time interval from its startDate to its endDate. When a record's interval overlaps one that's already been counted and comes from a different source, the tool treats it as a duplicate of that span: rather than adding both, it keeps only the single larger contributor for the overlapping period. Records that don't overlap anything are always counted in full.

This is a transparent approximation of the source-priority merging Apple itself performs. It's not a perfect reconstruction of Apple's internal algorithm — Apple weighs device priority and sampling in ways it doesn't publish — but it reliably strips out the roughly-double inflation caused by two devices recording the same walk, which is exactly what you care about. The double-counted figure you see per day is simply naive − deduplicated, and the inflation percentage is (naive − deduplicated) ÷ deduplicated × 100.

How to read your results

A low inflation percentage (under ~10%) usually means you mostly rely on one device, or you rarely carried your phone and watch together. A large inflation percentage (50–100%) is the classic signature of an iPhone and Apple Watch both logging your daily walks. Look at the per-source breakdown: if two sources each contribute a large share of raw steps, that overlap is your double counting. The deduplicated total is the number to trust — it should line up closely with what the Health app shows you on screen.

Reassurance: you don't have a broken watch or a buggy phone, and you don't need to delete a data source. The Health app is already showing you correct, deduplicated numbers day to day. This tool simply gives you those corrected numbers for the raw export so your spreadsheets, dashboards and analyses aren't thrown off.