BatchGeo is a great service that allows you to import address information from an Excel spreadsheet to create a map with locations. You can also put the locations into groups that are color coded. You can then embed the map into a website.
Here’s a more detailed how-to.
WordPress.com however only likes Google Map embedding. To embed a map after plotting the locations with BatchGeo you first have to export the map’s KML data into a new Google map.
Here’s how to do this.
- Follow directions to create a map with BatchGeo.
- Save your map.
- Name your map.
- When your map appears on screen in Batch Geo scroll to the bottom of the page.
- Select the Download NAME OF YOUR MAP Google Earth (KML) link. This will download a file to your computer. It should be named something like BatchGeo.KML.
- Open Google Maps. (For these next steps you will need a Google account.)
- Select the My places button in the left column.
- Select the Create Map button.
- Name your new map.
- Select the Import link.
- In the Import KML window select Browse
- Find the map file on your computer, select it and then select Open.
- Select Upload from File. The map data will be uploaded and you will see your BatchGeo map in Google Maps.
- Select the Done button at the top of the column.
- Select the chain link icon at the top right of the column.
- Copy the embed code in the second text box.
- Go to WordPress.com and create a New Post. (This same procedure works for WordPress.com Pages.)
- Select the Text tab at the top of the editing area.
- Paste your embed code wherever you’d like the map to appear.
- Select Save Draft, Publish or Update. The embed code will change slightly.
- Select Preview and you will see your map on the page.
- If you need to add additional text. images or links to the Post page select the Visual tab.