How Do I Create a Map From Excel Data?

You can use Excel data mapping software to create maps from Excel data.

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

Table of Contents:

Creating a Map From Excel Data in Maptitude Online (VIDEO)

Creating a Map From Excel Data in Maptitude Desktop (VIDEO)

Creating a Map From Excel Data in Maptitude Online

Creating a Map From Excel Data in Maptitude Desktop

Creating a Map in Maptitude Online (VIDEO)

Creating a Map From Excel Data in Maptitude Desktop (VIDEO)

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. Click Browse and select the Excel file and Sheet that you would like to map.
   Or, you can copy and paste the data you would like to map directly into the table.
   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 a free mapping software trial of Maptitude Desktop or use your existing Maptitude Desktop license.
2. Select New map of my data/table/spreadsheet and click OK.
3. Select the Excel file and Sheet that you would like to map. Click OK.
4. Use the Your Fields 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 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.
7. 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.
8. 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.

   

9. 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.

For more information on mapping sales territories using Excel data, please see this video tutorial on mapping sales territories in Maptitude.

For more information on importing Excel data into Google Maps, please see this video tutorial on how Maptitude can export your file into a Google Map-friendly format.