Check the file's separators first
CSV carries text values without spreadsheet formatting. This export uses commas between fields, double quotes around quoted fields, and commas as decimal separators inside numbers. The spreadsheet instructions below are for desktop use.
Try a lap recording workflow
Test named counters and laps in your browser. The export steps below apply to the iPhone app.
Open online stopwatchesImport into Excel
Microsoft explains delimiter selection and the Text Import Wizard for files that need more control than automatic opening provides.
Read Microsoft's import guideImport into Numbers on Mac
Apple shows how to adjust delimiters, text qualifiers, and encoding before editing an imported table.
Read Apple's import guideCheck Google Sheets number formats
Google explains how the spreadsheet locale determines the decimal separator used for numeric values.
Read Google's number format guide01
Make names and notes useful outside the app
Give each counter a name you can identify without its color or folder. For a workshop, "Bench A assembly" and "Bench B assembly" are more useful than two counters called "Task". The CSV includes names. It does not include colors or folder membership.
Open a recorded lap and add a short note such as "Tool change". Then stop every counter you plan to export. Keep the results until you have checked the saved file. For a running counter, the exported total includes the current lap, but that unfinished lap is left out of the exported lap columns.
Check. Start with one stopped counter that has several laps and a note.
02
Select counters and save the CSV
In Stopwatches, open Settings, choose "Export Data", then "In CSV format". Mark the counters you need. "Select all" selects the entire list, and "Deselect all" clears it. Selection applies to whole counters. There is no individual lap selection on this screen.
Tap "Save". The app creates stopwatches.csv and opens the system share sheet. Use "Save to Files" to keep a copy, or transfer it to your computer using an available action. The actions shown depend on your device and installed apps.
Rename the saved copy with a date and task, for example 2026-10-13-workshop-assembly.csv. Use CSV to analyze results in a spreadsheet. The app has a separate export action for transferring the counters themselves to another device.
Check. Select at least one counter and confirm that the saved file has a .csv extension.
03
Read the results block before sorting
The first header contains Title, Is running, Fulltime (seconds), then lap #1 (seconds), lap #2 (seconds), and so on. Title is the counter name. Is running contains YES or NO. Fulltime (seconds) is the total duration. The counter with the most recorded laps determines how many lap columns appear.
Each counter takes two rows. The first contains its name, status, and durations. The next contains notes: the first three cells are empty, and each comment sits below its corresponding lap. An empty lap cell on a counter with fewer laps means there is no record. Do not turn it into a zero-duration lap.
For example, Bench A has two laps of 45.25 and 54.75 seconds. Its total is 100 seconds. A note about the second lap appears on the following row under 54.75. To compare benches, copy the result rows to a separate sheet and put relevant notes in dedicated columns. Sorting the entire original block can detach a note from its result.
Check. Compare one name, total, pair of laps, and note position with the app before rearranging rows.
04
Keep start and pause intervals separate
After a blank line, a second block begins with Title, Lap, Timing start, Timing pause, Timing duration (seconds), Timing completeness, Comment. It describes active intervals within each lap. Pausing and resuming within one lap can produce several rows for that lap.
Timing start and Timing pause are Unix timestamps in seconds. Timing duration (seconds) is the interval length. A complete value means the event log is complete; partial means it is incomplete. A record without an event log uses legacy, leaves start and pause blank, and takes the duration from the saved lap. Missing timestamps do not mean zero elapsed time.
Use the first block for total-duration comparisons. Move the second block to another sheet if you need to inspect pauses. Adding totals, laps, and interval durations together counts the same measured time more than once.
Check. Find the second Title header and keep that block outside the range you sort for results.
05
Import into Excel, Numbers, or Google Sheets
In desktop Excel, use Data and From Text/CSV. Choose comma as the delimiter and inspect the preview. If decimal values remain text, specify a decimal comma when converting them to numbers. Microsoft's Text Import Wizard offers this in its advanced settings. Command names vary by Excel version.
On a Mac, open the CSV in Numbers. If columns look wrong, select the table and use Adjust Import Settings in the Format sidebar's Table tab before editing. Choose comma as the delimiter, double quotes as the text qualifier, and UTF-8 encoding. Leave "Treat consecutive delimiters as one" off: empty cells keep notes aligned with their laps.
In Google Sheets on a computer, check the spreadsheet locale under File and Settings before importing. It controls number formats throughout that spreadsheet, including the decimal separator. For a trial, create a separate spreadsheet with a locale that uses decimal commas. Then choose File, Import, upload the CSV, and select comma as the separator.
Check. The exported value "45,25" should become one numeric cell containing 45.25 in a dot-decimal display. Do not replace every comma in the source file: some commas separate columns.
06
Calculate with seconds and check one result
Keep imported durations as ordinary numbers first. A total of 100 seconds is 1 minute 40 seconds. Divide seconds by 60 for decimal minutes, or by 3600 for decimal hours. For example, 90 seconds equals 1.5 minutes. It does not equal 1 minute 50 seconds.
If the total is in C2, =C2/60 returns decimal minutes. Test it with a known value such as 90 seconds and confirm that the answer is 1.5. A formula error or unexpected answer is a reason to check numeric import. Once the values are correct, save the working spreadsheet separately and keep the original CSV as your unchanged record.
Do not confuse numeric seconds with Excel time, which is stored as a fraction of a day. A recognized time value needs a different formula; changing the cell format alone does not convert seconds to hours.
Check. Sort numeric seconds and compare measurements that use the same timing workflow.
Run a small export test first
One short trial lets you check the full path from a recorded lap to a spreadsheet calculation.
- Create a test counter, record two laps, and stop it.
- Add a short, single-line note to one lap.
- Export only that counter and save the CSV.
- Import the file and compare its total, both laps, and note with the app.
- Divide a numeric duration by 60 and save a separate working spreadsheet.
When the imported data looks wrong
Why did the whole result land in one column?
The import likely chose another delimiter, such as semicolon. Import the original file again and select comma explicitly. Keep double quotes as the text qualifier so a decimal comma inside a quoted number does not split it into two cells.
Why did a note split across rows or shift cells?
Check the original note for line breaks or double quotes. The current export does not fully escape them. For a verifiable export, use short, single-line notes without double quotes and export again. Keep the original note separately if you need its full text.
Stopwatches
Test an export with one counter.
Record two laps and a note in Stopwatches, stop the counter, and save a CSV. Open it in your usual spreadsheet before exporting results you need to keep.
Open Stopwatches in the App Store