Import and export your data

Export

Go to My Account and, under Export, select Gigs CSV, Expenses CSV or Payments CSV.

Each file shares a gig ID column, so expenses and payments stay linked to their gigs if you re-import them.

Import

1. Go to My Account and find Import.
2. Choose what This CSV holds: Gigs, Expenses or Payments.
3. Choose the File and select Upload & continue.
4. On Match columns, choose which CSV column fills each field. giggd guesses for you, so a column called location is matched to Venue and fee to Expected pay. Fields marked * are required. Leave anything else on — Don’t import —.
5. Check the Preview of the first rows, then select Import N rows.

The Import results page shows Rows added, Rows skipped and the reason for each skipped row.

Required columns

Importing	Required
Gigs	Band, Venue, Date (YYYY-MM-DD). Also Split between (people) if Pay scope is band.
Expenses	Gig ID, Amount (total)
Payments	Gig ID, Amount (total)

Good to know

• Importing only adds rows. It never changes or deletes what’s already there.
• Import gigs first. Expenses and payments attach to an existing gig by its ID. Rows pointing at a missing gig are skipped.
• Dates use YYYY-MM-DD and times use HH:MM.
• Imported gigs count towards the free gig limit.