mapping excel spreadsheet data for free
DESCRIPTION
Learn how to use a free mapping platform, Topo.ly, to easily optimize sales territories, enhance customer presentations, and segment markets. Developed using a Google Maps interface, users can plot data with a simple copy and paste from a spreadsheet.Businesses are overwhelmed by data, and managing the excessive information is becoming complicated. However, in a world of increasing technology, the key to business analysis and reporting is visualization.Upon registering for a free account with Topo.ly, users can begin the two-step process of building maps. First: Name the map. Second: Paste a list of addresses from Excel or any other spreadsheet application. Within seconds, all addresses and other location-specific data is plotted in a map.GIS and mapping software have become complex. Topo.ly aims to simplify it.Topo.ly FeaturesTopo.ly has developed key features to simplify mapping within its application:- Build maps by pasting a list of addresses from an Excel spreadsheet- Apply filters to view certain locations- Share maps across users- Add multiple data layers to a single map- Secure data and maps with password-protected loginTopo.ly's new mapping application is available at http://topo.lyTRANSCRIPT
Mapping is Awesome!
• Mitigate market and competitive risks• Identify growth opportunities• Enhance marketing strategies
Step 1: Login
• Login at http://Topo.ly
Step 2: Create Map
• Click “Create New Map”
Step 2: Create Map
• Name your map
Step 2: Create Map
• Click “Add new data set” to add locations from Excel to your map
Step 2: Create Map
• Name the data you are adding to the map• You can add many data sets (or layers)
to the map
• Copy data from Excel.• Be sure your spreadsheet columns have
any of the following headers:– Name– Address– City– State– Postal Code
Step 2: Create Map
Step 2: Create Map
• Paste data into Topo.ly and click Continue• It’ll look a little funny but don’t worry
Step 2: Create Map
• After locations are processed, click “Finish”
Step 3: Visualize!
• You’re done with your map!• Here’s a tour of what you can do…
Step 3: Visualize!
• Click on your location to see all your spreadsheet information
Step 3: Visualize!
• Click “Map” in top right corner to see a map view rather than satellite view
Step 3: Visualize!
• Click on the icon to change it’s color
Step 3: Visualize!
• Click the filter icon to narrow your view by any value from any of your spreadsheet columns
Step 3: Visualize!
• For example, click on the High Sales filter to show locations with high sales
Step 3: Visualize!
• Click on the data icon to see your spreadsheet data of all your locations
Step 3: Visualize!
• Click “Share” to share your map with anyone
Step 3: Visualize!
• Click “Add/Remove” to add more data layers to your map
Step 3: Visualize!
• Drag the Street View Icon to your map to see the street view near your location