How Do I Create a Map From Google Sheets?

You can use Google Sheets data mapping software to create maps from Google Sheets data.

Maptitude has tools that make it easy to visualize and analyze your Google Sheets or tabular data.

Table of Contents

Creating a Map From Google Sheets Data in Maptitude Online

Creating a Map From Google Sheets Data in Maptitude Desktop

Creating a Map in Maptitude Online

1. Request a free mapping software trial of Maptitude Online or use your existing Maptitude Online account.
2. Click Create Map at the top of the page.
3. You can copy and paste the data you would like to map directly into the table.
   Or, download your Google Sheets data as an Excel file by going to File>Download>Microsoft Excel (.xlsx).
   Click Browse and select your converted Excel file and Sheet that you would like to map.
   Click Next.
4. Use the drop downs to properly configure your Excel columns. Click Next.

   

5. Select the type of map you would like to create.
   To see your data as points on the map, choose one of the Locate options.
   To see your data attached to ZIP Codes, Counties, States, etc., choose one of the Show options.
   Click Next.

   

6. Optionally, you can choose to create a theme with your data.
7. Optionally, you can also add labels or text showing one of the columns in your Excel file.
   Click Next.

   

8. If you are mapping your data as points, you can optionally add one of the following analyses: buffers, weighted center, and areas of influence.
   For more information on the analyses options, please see:
   Tutorial video on the buffer analysis in Maptitude.
   Tutorial article on the weighted center analysis in Maptitude.
   Tutorial video on areas of influence in Maptitude.

   

9. Enter a name for the map and click Finish.

   

Creating a Map in Maptitude Desktop

1. Download your Google Sheets data as an Excel file by going to File>Download>Microsoft Excel (.xlsx).
   You don’t need Microsoft Excel installed on your device to download your data.
2. Download a free mapping software trial of Maptitude Desktop or use your existing Maptitude Desktop license.
3. Select New map of my data/table/spreadsheet and click OK.
4. Select the Excel file and Sheet that you would like to map. Click OK.
5. Use the Your Fields drop downs to properly configure your Excel columns. Click Next.

   

6. Select the type of map you would like to create.
   To see your data as points on the map, choose one of the Locate options.
   To see your data attached to ZIP Codes, Counties, States, etc., choose one of the Show options.
   Click Next.

   

7. Optionally, you can choose to link your data, which means any changes made to the Excel file will update the map in Maptitude.
   For more information on linking data, please see the tutorial video on linking data in Maptitude.
   Click Next.
8. Optionally, you can choose to create a theme with your data.
   For more information on themes, please see the tutorial video on thematic mapping in Maptitude.
9. Optionally, you can also add labels or text showing one of the columns in your Excel file.
   For more information on labels, please see the tutorial video on labeling in Maptitude.
   Click Next.

   

10. If you are mapping your data as points, you can optionally add one of the following analyses: buffers, weighted center, areas of influence, and density.
    For more information on the analyses options, please see:
    Tutorial video on the buffer analysis in Maptitude.
    Tutorial article on the weighted center analysis in Maptitude.
    Tutorial video on areas of influence in Maptitude.
    Tutorial video on the density analysis in Maptitude.

    

For more information on mapping Excel data, please see the video tutorial on mapping Excel data in Maptitude.