Blog

OneDrive Spreadsheets: Map Location Data

ZeeMaps allows you to create interactive maps from location data stored in Microsoft’s OneDrive spreadsheets. ZeeMaps can periodically update the map as the spreadsheet changes.

You upload and attach your OneDrive spreadsheet to a map only once, then the map can be automatically kept updated as your spreadsheet changes. This way, you do not have to worry about making changes to both your spreadsheet and your map.

In order for this to work, make sure that you do not:

  1. Change the name or location of the spreadsheet
  2. Change the columns of your spreadsheet.

If you make any of the above two changes to your spreadsheet, then you must delete all data from your map and re-upload and attach your spreadsheet.

Attach a OneDrive Spreadsheet to a map

To attach a OneDrive spreadsheet to a map, first create a map on ZeeMaps. Use the Additions -> Add (Upload) Multiple Markers menu item on your map, and then select the Cloud Drive Spreadsheet Option.

Upload Data from OneDrive Spreadsheet to a a map
Upload Data from OneDrive Spreadsheet to a a map

In the Cloud Drives drop-down, select the Microsoft OneDrive option for the Provider control, and hit the Fetch My Spreadsheets button.

Select OneDrive Provider
Select OneDrive Provider

At this point, a window should be activated that asks you to sign-in to your Microsoft OneDrive account and give ZeeMaps access. Once you’ve granted access, you should see a list of your spreadsheets and be able to select the spreadsheet that you want to upload to the map. From here on, follow the steps for uploading a spreadsheet to a map.

If you want your spreadsheet changes to be automatically reflected on your map, make sure that you check the option for “Regularly update from Cloud Spreadsheet” in Step 2 of the confirmation process for the upload:

Periodically Update Map from OneDrive Spreadsheet changes
Periodically Update Map from OneDrive Spreadsheet changes

From then on, the map should be automatically updated when your spreadsheet changes.

To see what spreadsheets are attached to your map, use the View -> Cloud Drive Sheets menu item on your map.

Group Highlighted Regions by Color

ZeeMaps allows you to highlight geographical areas, e.g., zip codes, counties, cities, states, or geometrical areas like circles, rectangles on your map. You can use such highlighted areas to mark out sales territories, or show service areas on a map. Often, your “region” will comprise of several smaller “geographical” areas. For example, a pizza delivery service might consist of an area composed of several zip codes. Or, a sales territory map might divide the country into several regions comprising of several states each.

Group Highlighted Regions

We’ve added a capability to “group” highlighted areas by color. Use the View > Group Regions menu to combine the borders of your highlighted areas. Once you do this, boundaries will be removed from all contiguous highlighted areas of the same color.

 

combine highlighted regions
Menu item to combine regions

While the highlighted areas are grouped, you cannot add or make changes to existing areas. To do that, un-group the areas, make the changes, and then group the areas again.

Grouping and un-grouping of regions requires an active Enterprise plan subscription.

For example, here’s a map that has several US Zip Codes highlighted grouped together. Following it is a the same map without the grouped highlighted regions.

Interactive Map with several highlighted zip codes grouped together by color

Interactive Map with highlighted zip codes and other areas

Las Vegas Zip Codes Spreadsheet Uploaded to a Map

ZeeMaps now allows you to highlight US Zip Code areas on a map by uploading a spreadsheet with address and color information. Previously we supported highlighting regions only few at a time. As an example, in this blog post, we’ll show you how to highlight all the Las Vegas zip codes on a map.

Las Vegas Zip Codes Spreadsheet

We collected all the the las vegas zip codes and put them in a spreadsheet. A small sample of the spreadsheet is shown below:

City, State, Zip Code, Color

Las Vegas, NV, 89101, red
Las Vegas, NV, 89111, blue
Las Vegas, NV, 89102, green
Las Vegas, NV, 89103, red
Las Vegas, NV, 89106, blue
Las Vegas, NV, 89107, green
Las Vegas, NV, 89109, red
Las Vegas, NV, 89128, blue

The complete spreadsheet of the Las Vegas zip codes can be downloaded from: Las Vegas Zip Codes.

We’ve added the “color” column to our table to indicate which color we’d like to use to highlight a specific zip code. You can modify the color later once the map has been created. ZeeMaps supports 31 different colors that can be used for spreadsheet uploads. For a complete list of supported colors, see the menu item Map -> Legend on your map.

Upload Las Vegas Zip Codes Spreadsheet to a Map

Create a map and then use the menu item Additions -> Add (Upload) Multiple Markers. This will result in a dialog that asks for the spreadsheet file:

Upload Spreadsheet to Map for Las Vegas Zip Codes
Upload Spreadsheet to Map for Las Vegas Zip Codes

In this dialog, as shown in the figure above, you can select the option to upload the data as pins or as highlighted areas for the zip codes. Since we want to create a map with zip codes highlighted, we’ll chose the option of “US Zip Code Regions”.

The spreadsheet can be in Excel file format or a CSV file. You can also copy-and-paste data from a table, or attach a spreadsheet maintained on a Google Drive. The advantage of using a spreadsheet on a Google Drive is that you can have the map be automatically updated based on changes to the spreadsheet.

Once you submit the data, a dialog will ask for confirmation of the column mappings to the field values. Make sure your columns are assigned to the appropriate fields, otherwise the data may not be mapped correctly.

Confirm column mappings for Las Vegas zip codes upload
Confirm column mappings for Las Vegas zip codes upload

Las Vegas Zip Codes Map

After you confirm the column mappings, the highlighting of zip code areas will start. It may take a few minutes for large files. You’ll get an email report when the upload is finished. Refresh your map and it should show you the highlighted areas. Our interactive map of Las Vegas zip codes is embedded below.

Click on a highlighted zip code to see more information determined from the additional columns of your spreadsheet. In the information bubble, you can click on the title or name to get an edit dialog to make changes to that specific entry, including the ability to change the color.

When highlighting regions through spreadsheet uploads, the normal region limits apply: 5 for Basic (free) plan, 10 for Professional, 25 for Professional Publisher. In addition, the Enterprise plan is restricted to 5,000 highlighted regions through spreadsheet uploads. If you need more, please contact us for special provisioning.

 

 

Trip Planner in ZeeMaps for multi-point routes

Trip Planner Overview

ZeeMaps can used as a trip planner to plan your routes visiting multiple points marked on your map. Routes, an ordered list of destinations, can be created on any map, even maps not your own. Some highlights of trip planning with ZeeMaps routes are:

  • The ZeeMaps trip planner can optionally optimize your route for distance or time.
  • Routes are associated with your account for each map, so you’ll need to sign-in to create a route.
  • The trip planner allows you to print your routes, with a map showing the overall route and each stop labelled and listed on the print page.
  • Routes are available when you access the map from your Smart Phone, so you can easily get directions to your next stop from where you are.

Using the ZeeMaps Trip Planner

To create a new route on a map, use the menu item Additions -> Route. This will show you a dialog containing the route. For example, here’s a route on our Used Computer Stores map for a few stores in San Jose and Santa Clara, California.

Trip Planner: Create a route
Trip Planner: Create a route

Start clicking on pins on the map to add to the route. In the route dialog, you can select the route to be either automatically optimized for Distance or for Time. If not, you can leave it to be manual. If the route is in manual mode, you can drag-and-drop the destinations in the route to re-order your route. With a route dialog, you can do the following:

  • List All: list all the routes that you have defined on this map
  • Print: get a map print-out of your route, with each stop marked on the map and listed
  • Reset: clear your current changes
  • Show: show the routes between the destinations
  • Save As: Save your route for future reference
  • Close: dismiss the route dialog

Routes in Smart Phone

After you’ve defined your routes on a map, visit the map from your Smart Phone. To see the routes, click on the menu item and click on the Routes option. This will bring up a list of your routes, so you can click on the one that you want. Once you are on the route, you can click on any destination to get directions to that destination.

Trip Planner: Routes in Smart Phone
Trip Planner: Routes in Smart Phone