Rep Jam Gig

Import Guide

Bring your repertoire with you.

One CSV file fills the whole app — repertoire, musicians, jams and gigs. Five steps, and the only typing is your own song list. Importing never deletes anything, and running the same file twice never creates duplicates, so there is no way to get this wrong that can't be re-run.

Download the template

In the app: Repertoire tab → Import / Export → Download Template. Your phone's share sheet opens — send it wherever your spreadsheet lives, to your computer or your cloud storage, or email it to yourself.

Already have your songs in a spreadsheet? You can skip the template and shape your own file instead — keep the same header row, and step 3 tells you which columns matter.

Open it and read the top

Excel, Numbers and Google Sheets all open CSV files. The template starts with a block of lines beginning # — those are instructions, and the importer ignores them, so keep or delete them as you like. Below the instructions sit the header row (leave it as it is) and one filled example of each row type. Replace the examples with your own rows.

Every row starts with a Type — song, musician, jam or gig — that says what the rest of the row means. Most columns stay blank on any given row; that's normal.

Fill in your rows — what each type needs

Gold columns are required; the rest are optional. Blank cells are simply left out — they never erase anything already in the app.

song — one row per tune in your repertoire

  • Title
  • Key
  • Status
  • Composer
  • Lyricist
  • Year
  • Genre
  • Notes

Status is Ready, In Progress or Want to Learn — blank counts as Ready. Key is your performance key, written however you say it (Bb, C‑, Gm). A blank Genre shows as "jazz standard". Year is a plain number.

song,Fly Me to the Moon,C,Ready,Bart Howard,,1954,jazz standard,,,,,,,,,Uptempo swing feel

musician — one row per person in your directory

  • Name
  • Instrument
  • Instagram
  • Notes

Write the Instrument however you like — "keys" and "piano" count as the same instrument, and your wording is what shows on their card. Instagram works with or without the @.

musician,,,,,,,,Dana Reyes,piano,dana.reyes.music,,,,,,Gin Mill session — plays Thursdays

jam — one row per song you played that night

  • Date
  • Title
  • Venue
  • Key
  • Musicians
  • Notes

Rows sharing the same date and venue count as one jam night. Write Musicians as Dana Reyes (piano), Lee Park (bass) — anyone listed with an instrument joins your Musicians directory automatically, and any song not yet in your repertoire files itself into In Progress with its songbook credits. Your jam log builds your library for you.

jam,Autumn Leaves,Gm,,,,,,,,,2026-07-18,The Gin Mill,,,Dana Reyes (piano),Called it as a bolero

gig — one row per song in the running order

  • Date
  • Venue
  • Gig
  • Set
  • Title
  • Key
  • Musicians
  • Notes

Rows sharing the same Date + Venue + Gig become one gig, and Set numbers its sets — blank means set 1. Two rows with Set 1 and three with Set 2 rebuild a two-set gig, in order. Musicians and Notes only need to appear on one of the gig's rows. A gig row with no Title saves the gig itself, empty and ready for songs later.

gig,Autumn Leaves,Gm,,,,,,,,,2026-08-02,Blue Note,Friday Late Set,1,Dana Reyes (piano),
gig,Fly Me to the Moon,C,,,,,,,,,2026-08-02,Blue Note,Friday Late Set,1,,

Dates are best written YYYY-MM-DD (2026-08-19). American-style 8/19/2026 and 2026/08/19 are accepted too, and so is 8/19/26, the two-digit year Excel writes when it saves a file again — it reads as 2026. Day-first dates aren't read the way you mean: 05/08/2026 comes in as 8 May, and 19/08/2026 is skipped as unreadable, so use YYYY-MM-DD.

The header row ends with a Chart column. Export All Data fills it in to name a song's chart inside its zip; in your own file, leave it blank.

Save it as a CSV

  • Numbers: File → Export To → CSV
  • Excel: File → Save As → CSV UTF‑8
  • Google Sheets: File → Download → Comma‑separated values

Then get the file somewhere your phone or tablet can reach it — cloud storage, your downloads, or any folder your file picker can see. Save it as a .csv: the picker shows CSV and text files, and the zip the app exports, so a file saved as anything else may show up greyed out.

Import it

Back in the app: Repertoire → Import / Export → Choose a File, and pick your file. A confirmation tells you exactly what happened — how many songs, musicians, jams and gigs were added, what was merged with entries already on file, and whether any rows were skipped.

Safe to run again. Songs and musicians already in the app are matched by name and merged — a blank cell in your file never erases what's there — and jams or gig songs already logged are skipped, not duplicated. A tune you called twice is two rows, and both are kept; importing the same file again still adds nothing. Fixed a typo? Just edit the file and import it again.

If something looks off

  • "Nothing to import" usually means the header row was removed or renamed. Column order doesn't matter, but the names do.
  • "…rows skipped" points at rows missing what they need: a song or jam row without a Title, a jam or gig row without a readable Date, or a Type that isn't song, musician, jam or gig.
  • Commas and quotes in titles or notes are fine — your spreadsheet handles the wrapping when it saves the CSV.
  • Still stuck? Send the file (or a few rows of it) through the support page and we'll look.