If you have any experience with the Google Charts API, you might expect the Google Sheet GeoMap chart to work like the Geo Chart offered there. Of course, I was curious about what counts as “location names” and wanted to test the limits of this GeoMap chart. The second column should contain numeric values.” According to the error message that pops up if your columns are problematic: “The first column should contain location names or addresses. For any map, you will need (exactly) two columns. The main thing to remember when trying to create any map or chart in a Google sheet is that the tool is very particular about the order of columns. If you’d like to try creating these maps yourself, you can use this template (you’ll have to log into your Google account first, and then click on the “Use this template” button to get your own copy of the spreadsheet). I’ve created a few examples in a public Google Sheet, so you can see what the data and final maps look like. While there are plenty of more powerful mapping tools if you want to have a lot of features (e.g., ArcGIS, QGIS, Google Fusion Tables, Google Earth, GeoCommons, Tableau, CartoDB), you might consider just sticking with a spreadsheet for some of your simpler projects. Earlier this semester I was researching how the Sheets tool in Google Drive could be used as a quick and easy visualization tool when I re-discovered its simple map functionality.
![google spreadsheet converter to graph google spreadsheet converter to graph](https://i1.wp.com/www.alphr.com/wp-content/uploads/2020/12/sg1.png)
Here at Data & GIS Services, we love finding new ways to map things.