← Articles

Results in a spreadsheet

How to export stopwatch results to CSV and Excel

To move stopwatch results into Excel, export a CSV file and import it with the right delimiter and number settings. Stopwatches lets you select counters and export their totals, recorded laps, and notes. Stop the counters first. The file stores durations in seconds with decimal commas, and it includes separate rows for notes and start/pause intervals.

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 stopwatches

Import 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 guide

Import into Numbers on Mac

Apple shows how to adjust delimiters, text qualifiers, and encoding before editing an imported table.

Read Apple's import guide

Check Google Sheets number formats

Google explains how the spreadsheet locale determines the decimal separator used for numeric values.

Read Google's number format guide

01

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.

Conversion formulas for stopwatch readings and Excel time

Run a small export test first

One short trial lets you check the full path from a recorded lap to a spreadsheet calculation.

  1. Create a test counter, record two laps, and stop it.
  2. Add a short, single-line note to one lap.
  3. Export only that counter and save the CSV.
  4. Import the file and compare its total, both laps, and note with the app.
  5. Divide a numeric duration by 60 and save a separate working spreadsheet.

Set up multiple stopwatches on iPhone

Before recording a group of results, name your counters and check that each starts and stops independently.

Read the setup guide

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
List of running and paused stopwatches organized by folders