This tool transforms a Google spreadsheet of "events" with GPS coordinates into a GeoJSON feature collection, which you can copy and use to build custom maps. See this blog post for more on why/how...
How to use it
- Start with a Google spreadsheet with column headings: "date", "place", "city", "province", "nation", "latitude", "longitude" (*required). See: an example spreadsheet.
- Publish the spreadsheet and make note of the key in the url.
- Input the key in the form below and submit. The key to the example spreasheet is the default, try it out before you create your own.
- Recommended: Check your results. Jason Sanford's GeoJSONlint validates GeoJSON.