Import Data
Bring data into Sequence from a spreadsheet or another app using CSV files. Import is available on web only.
You can import:
- Workouts — Workouts for your personal workout library
- Coaching Workouts — Workouts you can assign to your coaching clients
- Daily Metrics — Values for one daily metric, such as body weight or sleep hours
- Logbook Entries — Your climbing history, added to a logbook as completed sessions on each date
Workout import adds workouts to your library. It doesn’t add them to your planner or record past sessions.
Importing a File
Open Import
Go to Settings → Account, find Data Management, and click Import next to Import Data. Choose what you’re importing.
Check the format
The Instructions tab lists every field the import accepts. Click Download Example CSV File for a template to fill in.
Upload and match the columns
On the Import Data tab, upload your CSV file. Columns whose headers match the field names are matched automatically, whatever their case. Match any others yourself, then click Process →.
Choose where the data goes
For daily metrics, choose the metric under Choose Metric Type. For logbook entries, choose the logbook under Choose Logbook, then the workout it’s on under Choose Workout. The logbook has to be on a workout already.
Submit
Click Submit. If the import fails, Sequence shows what went wrong so you can fix the file and try again. For logbook entries, errors are listed by line.
Try a small file first to check your formatting. A file can have up to 10,000 rows.
File Format
Files must be CSV with a header row.
Workouts
| Column | Required | Description |
|---|---|---|
name | Yes | Title of the workout |
description | Yes | Short description of the workout |
details | No | Detailed instructions for the workout |
category | Yes | Must match the name of one of your categories |
duration | Yes | How long the workout normally takes, in minutes |
outdoor | Yes | true or false |
Coaching workouts use the same columns.
Daily Metrics
| Column | Required | Description |
|---|---|---|
date | Yes | Date of the value, in YYYY-MM-DD format |
value | Yes | A number, which can include decimals |
Each file holds values for one metric. To import several metrics, import one file for each.
Logbook Entries
| Column | Required | Description |
|---|---|---|
name | No | Name of the route or problem |
grade | Yes | Must be a valid grade, such as 7b+, 5.12c or 26 |
location | Yes | Where you climbed it, as free text |
day | Yes | Day of the ascent (1–31) |
month | Yes | Month of the ascent (1–12) |
year | Yes | Year of the ascent, such as 2024 |
style | Yes | One of onsight, flash, redpoint, attempt or work |
attempts | No | Number of attempts. Blank counts as 1 |
flags | No | Comma-separated flags, such as Repeat,Top rope |
notes | No | Notes on the ascent |
Each date in the file becomes a completed session of the workout you chose, with that day’s entries in its logbook. To import into a different logbook, such as routes and boulders, or onto different workouts, import a separate file for each.
Existing Records
If a workout with the same name, or a daily metric value on the same date, already exists, the import stops without saving anything. To replace those records, turn on Overwrite existing records for workouts or Overwrite existing values for daily metrics, then submit again.
Overwriting replaces your existing workouts or values with the ones in the file, and can’t be undone.
Related
- Workouts — See your imported workouts
- Logbook — See your imported climbs
- Daily Metrics — See your imported values