Outdoor routes
Date, route, grade, style, tries, crag and notes. Grades are French, like 6a or 7b+.
Climbing logbook template
A spreadsheet for logging your climbs: date, route, grade, style, tries, crag and notes. Two versions, one for outdoor routes and one for the gym.
Get the template
Gym climbs and bouldering log
Routes and boulders indoors, with a column for discipline. Boulders can be Font or V grades.
Use it as a bouldering log too: set Discipline to boulder and use Font or V grades.
What's in each column
One climb per row on the first sheet. Log attempts too: every try on a route you haven't sent yet is how you see a project come together.
| Column | What to put | Example |
|---|---|---|
| Date | Year-month-day. | 2026-04-19 |
| Route | Required. The route's name. In the gym template this is Climb: hold colour or wall. | El Chupacabras |
| Grade | Required. French for routes; Font or V for gym boulders. | 7a |
| Discipline | Gym template only. Route or boulder. | boulder |
| Style | Onsight, flash, redpoint, repeat or attempt. | redpoint |
| Tries | How many goes it took. | 3 |
| Crag | Optional. The gym template has Gym here. | El Chorro |
| Notes | Optional. Where the beta goes. | Kept the left heel on the arete at the crux. |
How to keep a climbing logbook
- Log the same day, while you still remember the moves.
- One row per climb, including the ones you didn't send.
- Write the grade from the topo, not how it felt. How it felt goes in Notes.
- Log warm ups too. They show how much you climb, not just how hard.
- Every few weeks, sort by grade and look at where most of your climbs sit.
Want to see how a climber actually uses hers? Read What I track in my climbing logbook.
Onsight, flash, redpoint: which style to log
- Onsight
- Sent first try, with no beta.
- Flash
- Sent first try, with beta.
- Redpoint
- Sent after one or more earlier tries.
- Repeat
- A route you've sent before.
- Attempt
- Not sent yet.
Why log your attempts
Attempts are where projects come from. Log every try on a route you haven't sent, with a note on what stopped you, and the next session starts with your own beta.
Example rows
These are example rows, the same as the Example sheet in each file. They are not imported.
Outdoor routes
| Date | Route | Grade | Style | Tries | Crag | Notes |
|---|---|---|---|---|---|---|
| 2026-04-19 | El Chupacabras | 7a | redpoint | 3 | El Chorro | Third go. Kept the left heel on the arete at the crux. |
| 2026-04-13 | Warm up slab | 6a | onsight | 1 | El Chorro | |
| 2026-08-29 | Timberrr | 7a | attempt | 3 | Valea Cernei | Take the bad undercling at bolt 3 as a pull from the left. |
Gym climbs
| Date | Climb | Grade | Discipline | Style | Tries | Gym | Notes |
|---|---|---|---|---|---|---|---|
| 2026-10-22 | Green holds, dihedral | 6b+ | route | flash | 1 | My gym | |
| 2026-10-13 | Blue overhang | 6C | boulder | redpoint | 2 | My gym | Heel hook on the second move. |
| 2026-10-01 | Black crimps | 7a+ | route | attempt | 1 | My gym |
When you want charts
Import the same file into RoxClimbs and get your grade pyramid, projects and progress from it. In the app, open Settings and import the file.
Import your logbookCommon questions
Which template should I use?
The outdoor one for routes you climb on rock. The gym one for routes and boulders indoors. It has a column for discipline.
Can I use it in Google Sheets?
Yes. Use Copy to Google Sheets and you get your own copy in your Google Drive. You can also open the .xlsx file in Google Sheets, Excel or Numbers.
Which grades can I use?
Outdoor routes use French grades, like 6a or 7b+. In the gym, routes use French grades and boulders use Font or V grades, like 6B or V4.
Can I import it later?
Yes. Import the file into RoxClimbs from Settings, as .xlsx or .csv. Only the first sheet is read, so the guide and example sheets stay out of your logbook.
Should I log failed attempts?
Yes. Log them with the style attempt. They show what you're working on, and in RoxClimbs you can turn them into a project.
Should I log warm ups and repeats?
Yes. A climb you've sent before gets the style repeat. Warm ups and repeats are most of your climbing, and they show your volume.
What's the difference between flash and onsight?
Both mean you sent it first try. Onsight means you had no beta at all. Flash means you knew something about it first, like watching someone climb it.