iPhone GPS Customer List

Posted on 2013-11-15
Medium Priority
Last Modified: 2013-12-06
Hi Experts,
We have a list of potential customers in Excel that we have given to our sales guys. I would love for them to be able to click on the address portion on their iPhone and it automatically open in either Google Maps or Apple's Maps app. Is this possible? I can't seem to find much about it online. Thank you for any help or guidance.
Question by:ttotus
LVL 14

Accepted Solution

Michael Dyer earned 2000 total points
ID: 39651793
if you could add a new column in your spreadsheet and use a formula to append this "https://maps.google.com/?q=" to the addresse it should create a link that will open that address directly in google maps.  


http://maps.google.com/?q=1200 Pennsylvania Ave SE, Washington, District of Columbia, 20003
LVL 15

Expert Comment

by:Allen Falcon
ID: 39653132
How are they opening the Excel spreadsheet on the iOS devices?  

If you convert it to a Google Sheet, the phone should initiate a call and the address, if completely (street, city, state) is in a field, can trigger maps (and you can use the link, above).

If you have Google Apps for Business/Education/Government, you can also install QuickOffice for free, which lets you edit the Excel file in its native MS Office format.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
While there are many new features for iOS 11, these are the five that can improve your digital lifestyle.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question