Solved

iPhone GPS Customer List

Posted on 2013-11-15
2
364 Views
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.
0
Comment
Question by:ttotus
2 Comments
 
LVL 14

Accepted Solution

by:
Michael Dyer earned 500 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.  

Example:

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

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.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

820 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