| How to plot multiple addresses from an Excel Spreadsheet | Shawn LVNV | 7/19/10 11:44 AM | I work for a delivery company and am looking for an application or 3rd party site that will allow me to import a spreadsheet of 100+ addresses and plot them to be printed - NOT PUBLISHED. All of the addresses will be within the same or adjoining zip |
| Re: How to plot multiple addresses from an Excel Spreadsheet | ehg | 7/19/10 2:26 PM | There are several options but none directly with GoogleMaps. Try one of the following services for mapping batch points. 1. using Mapchannels:http://mapchannels.com/ 2. using "batchgeo": http://batchgeocode.com/3. using Google's Fusion Tables: htt |
| Re: How to plot multiple addresses from an Excel Spreadsheet | jon23781 | 11/3/10 7:45 AM | Using ehg's very helpful response above I went to http://tables.googlelabs.com/ and it worked perfectly. After importing the excel spreadsheet I went to 'edit' > 'modify columns' --> and then selected 'type' drop down changing it to location --> 'sa |
| Re: How to plot multiple addresses from an Excel Spreadsheet | basinclr | 3/20/11 8:20 PM | Great answer !!! I found http://batchgeocode.com/ worked the best for our company customer sales |
| Re: How to plot multiple addresses from an Excel Spreadsheet | tempelt | 3/21/11 11:50 AM | Wow, jon23781's direction to use visualize > map was truly magic. Fairfax county lists all of the licensed in home day care providers but there's >50 in my zip code. Since this let me do it automatically, I found two in-home day care places near my |
| Re: How to plot multiple addresses from an Excel Spreadsheet | trishboss | 5/5/11 11:07 AM | jon23781, I followed the steps and i'm also there but my data is broken down in columns by address, city, state, zip. Does anyone have help for how to do this? thanks. |
| Re: How to plot multiple addresses from an Excel Spreadsheet | SurfsideRabbit | 5/5/11 4:05 PM | trishboss, use the CONCATENATE function in Excel to combine values from multiple cells into one string |
| Re: How to plot multiple addresses from an Excel Spreadsheet | vivekrjain | 5/27/11 1:22 PM | Based on the help above I was able to plot all sold and available homes in my neighborhood. Currently all the homes are "red dots" on the map... can I somehow have red dots if column A = Sold and current green dots if column A = Available? |
| Re: How to plot multiple addresses from an Excel Spreadsheet | davidjmcgeown | 7/6/11 8:19 AM | Hi, this is really good. I am having a problem though. I used http://tables.googlelabs.com/ I am trying to plot a user community for expenses training. Where there are more than one user in a location, it doesn't show more than one record. Any one h |
| Re: How to plot multiple addresses from an Excel Spreadsheet | extralife | 8/4/11 9:25 AM | Thanks ehg & jon23781 - it works well for UK addresses too. |
| Re: How to plot multiple addresses from an Excel Spreadsheet | rdy4trvl | 5/24/12 4:00 PM | Very nice. However, I can only "visualize" 20 rows of data on the map. Is there a limit or am I missing something?Thanks |