Export google maps results to an excel sheet

I am working on a website and I want to list all of the bars in my area.  I'm looking for a way to take the results from google maps and export those results to a excel file.  Is this possible?  There are over 75 bars in my area and if I could avoid having to type each one that would be great!

Thanks
MyhrcgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions ConsultantCommented:
Try this

Right click 'Open in Google Earth' when viewing your map.
Select 'Copyshortcut' or 'copy link location'
paste into the browser address bar, and find the bit that says output=nl and change to output=kml and press go.
you should then download a .kml file.
rename it to have a .xml extension, and try opening in Excel. (choosing .xml as the file type)
0
MyhrcgAuthor Commented:
When I right click the map in Google Chrome,  the only options that I have are Directions from here, Directions to here, What's here? Search nearby, and Measure distance.  In Google Earth, when is Copyshortcut or Copy Link Location?  Please keep in mind that all this is new to me :-).
0
Michael FowlerSolutions ConsultantCommented:
OK it seems the easiest way is create the map using https://mapsengine.google.com/projects/new

Add the bars to a layer in your map

Finally export the map to kml

Open the kml file in excel

https://support.google.com/mymaps/answer/3024925?rd=1
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MyhrcgAuthor Commented:
I apologize for the late response.  I have no idea how to add layers or create maps using the link you provided.  Can you provide a walkthrough please?
0
Michael FowlerSolutions ConsultantCommented:
@Myhrcg sorry for the delay.

1/ Create a new map with Google's "My Maps"
2/ Perform a search to find the locations you want. In this example I have used "Hotels Sydney" as the search
https://www.google.com/maps/d/edit?mid=z5DECsvHxjZU.kXcOzq4b9qKk
3/ For each correct flag select the flag and then click on "Add to Map" (Flag will then appear as red). You can perform multiple searches until you are happy that you have added all the locations to your map
3/ Select the folder icon
4/ Choose the Export to KML option
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aikimarkCommented:
I've had better luck getting data from Yelp than from Google
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
MyhrcgAuthor Commented:
I have chose a different solution.  Thanks anyway guys.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google Apps

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.