Mapping Data with Easy Map Maker

Any sufficiently advanced technology is indistinguishable from magic.


Mapping data is cool. It is also a very useful tool. And it used to be hard. You had to convert your table of data into longitute and latitude coordinates, you needed specialized GIS (Geographic Information System) software (http://www.esri.com/what-is-gis).

Google has changed all of that. Google Maps has built in mapping tools, see My Maps for more information on making your own maps.

But what if it was even easier than that? Enter Easy Map Maker easymapmaker.com.

With Easy Map Maker, all you need to do is create a spreadsheet and paste it. Well, to get a good map, you need to do a little more but it takes about five minutes.

What you will need:

A spreadsheet of your data. Microsoft Excel, LibreOffice, GoogleDocs or Comma Delimited Text. BUT, it needs to be set up correctly.  The Address (123 Main Street); City (Pleasantville); State (Ohio); and ZIP Code (90210) go in separate columns. There are Excel tools that will break a single column up into multiple columns but it better to do it right the first time.

You also need the data to go with the addresses. For this example, tip amount is the only other data. But, you could also use this for other information. Coupon used? Order size? whatever.

Next:

Go to Easy Map Maker easymapmaker.com.

Easy Map Maker Home Screen

 

 

 

 

 

 

 

 

 

 

 

It will say: "Click here to paste your data." First click and clear the sample data and then paste the data from you spreadsheet. Make sure to get the column headings.

Nest: Tweek

Click on Set Options. Set the options. My demo map uses the settings as shown below.

Settings for Easy Map Maker

 

 

 

 

 

 

 

The white box on the right will change and show you how your data will look with the map pins.  I used tips in the Group setting to color code dollar amounts.  Generate your map. I have used Easy Map Maker with several hundred data points. That map took about 15 minutes to process. This 24 point map, about 15 seconds.

Look at your map. Is it what you want? Yes? Good. No? Tweek some more.

Demo Map

 

 

 

 

 

 

 

 

 

When you are happy with your map, save it.  DO NOT MAKE YOUR MAP PUBLIC if it contains customer data. You can get fired for that. This map was made with hypithetical data, not actual customer data.

The live map for this demo is available at: http://www.easymapmaker.com/map/735df777aa9393849fc898d80d770191. It will be visible until December 1, 2015. EasyMapMaker didn't kill my demo map. It is still up and visible as of October, 13 2017.