How to export Apple Watch counter entries to a spreadsheet
A daily total of three cups tells you how much coffee you drank. To study how those cups were spaced, you need the individual entries. You can record them on Apple Watch and use Tally on your iPhone to export them.
Start with a small batch you can recognize
Use one counter, such as Coffee, and log three separate cups on your watch. For a quick test, note when you tapped. On your iPhone, open Coffee’s history and check that all three entries have synced before you export.
Choose the detailed export
Open Tally’s CSV export on your iPhone. Choose the option for individual entries. The summary export is useful when you want totals. For this exercise you need the detail file so you can match each tap to a row. Save the CSV and open it in Numbers, Excel, or another spreadsheet app.
Check the rows before doing the math
Find Coffee and the date of your test. Look for three entries and compare them with the history on your phone. If the sheet contains a single total, check which export you selected. If an entry is missing from the phone history too, let the watch sync and export again.
If you need the time of each tap
Inspect the original CSV in a plain-text viewer first. A spreadsheet may display only a date even when a cell contains a time. If the raw values include times, format the cells to show both date and time, sort them oldest first, then subtract adjacent values to find the gap between cups. Check the first value against the time you noted on your watch before using the result.