Can I use Google Maps to find addresses?

Asked By Joe T Carver 0 points N/A Posted on - 04/20/2015

I am recording certain addresses around a specific area and it would be easiest for me to copy and paste. If I use Google Maps, can I copy and paste the addresses in an Excel spreadsheet, and would it require a lot of formatting? I haven't had luck trying this but maybe someone knows some tricks I am missing. Thank you.

• Status: Open
• Question Views: 491
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet

Answered By Dave Crinit 5 points N/A #181222

Can I use Google Maps to find addresses?

Yes of course, you can simply use Google Maps to find addresses of a certain location and it is possible to copy paste those on a Excel spreadsheet. Really, it does not require a lot of formatting. Yet it is time consuming & might have to face restrictions sometimes.

Nevertheless, it is possible to export the page into an excel file. First append "&output=kml" to the URL's end, download the file, again change the extension into an XML file & import it to Excel as follows, 

• Go to Data tab >> From Other Sources >> From XML Data Import >> Select the file

​Best Regards!

 

About Dave Crinit

Questions
0

Answers
211

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/20/2015
• Question Category: Internet