Step 1: Google Sheets

1. Organize event data in a Google Sheet

• Proper headers, etc.
• Get geocodes
  • Use script
    • Source: http://www.digital-geography.com/geocoding-google-spreadsheets-the-simpler-way/#.VMu7Qi5cBpk
    • As a Google Script: https://script.google.com/d/1bEyZtW6RjjB-UzYK6x80fqihtZF7qhhrJKVKRdlH-iBJsUtRbaWJW96X/edit?usp=sharing
    • To deploy:
      • Tools/Script editor/paste in script, save
      • In 2 new columns (label lon/lat), use formulas "=getLon('address cell')" and "=getLat('address cell')"
  • It is important to have accurate addresses or postal codes
    • These can be duplicate (we will use marker clustering/spiderfy)

2. It is important to include a "popupContent" column.

3. Export as CSV and JSON

• CSV for text list: export from Google Sheet as CSV (no coords)
• JSON for map
  • convert to geoJSON from CSV http://csv.togeojson.com/ (with coords)
  • prettify geoJson with http://www.bodurov.com/JsonFormatter/ for easier reading