How to import your logbook from a spreadsheet
It’s our goal to be a single, safe place to store your skydiving logbook.
We recognize many skydivers maintain their logbook in digital formats or within other apps. It’s important for us to give skydivers the ability to easily transition to (or export from) Boogie as they please.
The rest of this post describes how to import your logbook from a spreadsheet (exported as a CSV file). If you want to learn how import your logbook from the “Skydiving Logbook” app, check out this post.
To request the ability to import from another source email us at support@boogie.io.
Overview
- Download Boogie’s Google Sheet template
- Fill out your logbook
- From Google Sheets, download as (or save as) a CSV file
- Import your CSV into Boogie - Skydiving Logbook
1. Download Boogie’s Google Sheet template
Download one of our Google Sheets to get started.
Boogie Template (Imperial) Boogie Template (Metric)
2. Fill out your logbook
You’ll start with 10 sample logs, be sure to replace those logs with your logs. There are notes within the column header cells for additional clarity and examples. You can also find additional details here.
Rules for success:
- Don’t rename column headers.
- Don’t add or delete column headers.
- Make sure every log has the “date” column filled out.
3. From Google Sheets, download as (or save as) a CSV file
When you’re finished entering your logbook, download it as a Comma-separated values (.csv) format.
How to download a .csv file from Google Sheets for web:
- Go to File > Download as > Comma-separated Values (.csv, current sheet)
- Once downloaded, move your CSV to a location you can access from your mobile device.
How to save a .csv file from Google Sheets mobile app:
- Tap the three dots in the upper right-hand corner
- Tap Share & Export
- Tap Save As…
- Tap CSV (current sheet)
- Remember where you save the file. You’ll have to find it and select it when you import your CSV into Boogie (described in point 4).
4. Import your CSV into Boogie - Skydiving Logbook
- Within Boogie, tab the Settings icon
- Tap Import Spreadsheet (CSV)
- Tap Choose File
- Find and select your CSV file.
- You remembered where you saved your file, right ;)
It will take a moment for Boogie to process your CSV…
Congratulations! Your logbook has been imported to Boogie.
What if the import failed?
Make sure your logbook adheres to the format documentation detailed below.
Common issues:
- Make sure every row has the date column filled out in the correct format.
- Make sure no columns have been renamed.
- If you’ve done those things, and the import still fails email us at support@boogie.io.
Format Documentation
We’ve included notes within the Google Sheet to make things easier, but here are additional details about the format requirements.
Required column names
The following column names must exist in the spreadsheet.
- date
- time
- name
- icon
- location
- free_fall_seconds
- altitude_ft or altitude_m
- aircraft
- canopy
- accuracy
- accuracy_unit
- description
- signature_license_organization
- signature_license_identifier
- signature_message
date
The date of the skydive. Timezone is Univeral Standard Time (UTC).
Acceptable date formats:
YYYY-MM-DD
example: 2016-01-10MM/DD/YYYY
example: 01/10/2016MM-DD-YYYY
example: 01-10-2016
time
The time of day of the skydive. Timezone is Univeral Standard Time (UTC).
Acceptable time formats:
hh:mm a
example: 3:32 pmHH:mm
example: 15:32
name
A name to describe the log. This often aligns with the icon.
Examples:
- 4 Way RW
- Wingsuit
- Helicopter
icon
Choose one icon that best represents the log.
Supported Icons:
- 3d_camera
- aad_fire
- accuracy
- aff_instructor
- angle
- assisted_deploy
- award
- balloon
- base_generic
- belly
- beer
- big_way
- canopy_fs
- coaching
- combat
- costume
- crew
- cross_country
- ends_in_00
- ends_in_000
- evaluator
- exhibition
- exit_horny_gorilla
- flag
- formation_flight
- formation_skydive
- freefly
- freestyle
- generic
- haho
- halo
- head_down
- head_up
- helicopter
- high_altitude
- high_pull
- hoop
- hop_n_pop
- hybrid
- inflatable
- injury
- instructor_examiner_aff
- instructor_examiner_assisted_deploy
- instructor_examiner_coach
- instructor_examiner_static_line
- instructor_examiner_tandem
- instructor_examiner
- load_organizer
- malfunction
- military_static_line
- mixed_fs
- mr_bill
- naked
- night
- pink_mafia_sisters
- point_of_view_camera
- skysurf
- slick
- spaceball
- special_number
- specialty_plane
- speed_star
- static_line
- student
- student_aff
- student_assisted_deploy
- student_coach
- student_static_line
- student_tandem_passenger
- sunrise
- sunset
- swooping
- tandem_instructor
- tracking
- triathlon
- tube
- unsuccessful
- vertical_fs
- video_and_stills
- water_landing
- wingsuit
- world_record
- xrw
location
The name of the location you skydived at.
Examples:
- Des Moines Skydivers
- Chicagoland Skydiving Center
- Virginia Skydiving Center
- Skydive Dubai
free_fall_seconds
Skydive freefall time in seconds. (1m 5s becomes 65).
Examples:
- 65
- 20
- 71
altitude_ft
Skydive exit altitude in feet. If you have this, do not include the altitude_m column.
Examples:
- 13500
- 12200
- 6800
altitude_m
Skydive exit altitude in meters. If you have this, do not include the altitude_ft column.
Examples:
- 4115
- 3718
- 2073
aircraft
The aircraft for the skydive.
Supported options:
- 172 Skyhawk Cessna
- 182 Skylane Cessna
- 205 Skywagon Cessna
- 206 Stationair Cessna
- 206 Stationair Turbine Cessna
- 208A Caravan Cessna
- 208B Grand Caravan Cessna
- 7 Turbine Comp Air
- Aero 160 Brigadyr
- AL 60 C4M Kudu Atlas Angel Lockheed
- AL 60 Trojan Apollo T Aermacchi
- AN2 Antonov
- AN28 Antonov
- AN32 Antonov
- Balloon
- Beech 99 Beechcraft
- C130 Hercules Lockheed
- C141 Starlifter Lockheed
- C160 Transall
- C17 Globemaster3 Boeing
- C212 Aviocar Cas
- C23 Sherpa Short Brothers
- C27J Spartan Alenia Aeronautica
- C295 Casa
- C31A Troopship Fokker
- CH 47 Chinook Boeing
- DC3 Douglas
- DHC6 Twin Otter De Havilland Canada
- Do 27 Dornier
- DO28 G92 Dornier
- GA8 Airvan Gippsaero
- Helicopter Generic
- King Air Beechraft
- Kodiak Quest
- L410 Turbolet Let
- M28 Skytruck Pzl Mielec
- MI8 Transall
- Model 18 Beechraft
- Nomad Gaf
- PAC P750 Xl Pacific Aerospace
- PC6 Porter Pilatus
- Piper Navajo Pa31 Piper Aircraft
- Pitts Special Aviat
- R44 Raven Robinson
- SC7 Skyvan Short Brothers
- Short 330C23 Sherpa Short Brothers
- SMG92 Turbo Finist Technoavia
- Specialty Aircraft
- UV18 Twin Otter Viking Air
- V 22 Osprey Bell Boeing
canopy
The canopy used on the skydive.
Examples:
- PD Storm 190
- PD Storm 190
- PD Storm 190
accuracy
The skydive accuracy. The accuracy_unit can be ft or m.
Examples:
- 5
- 10
- 53
accuracy_unit
The unit of measure for accuracy.
Options:
- ft
- m
description
A text description or note of the skydive.
Examples:
- lorem ipsum
- lorem ipsum
- lorem ipsum
signature_license_organization
The abbreviation of the organization of the log signer.
Supported Organizations:
- uspa
- cspa
- anpdl
- apf
- bpa
- cbpq
- dfu
- dfv
- ffp
- fsp
- knvvl
- kpa
- lpsf
- nlf
- nzpf
- parafech
- pasa
- pfp
- sff
- thk
signature_license_identifier
The identifier of the log signer.
Examples:
- D12345
- A48573
- C3454
signature_message
A comment or message from the log signer.
Examples:
- Great job.
- Better luck next time.