Solved

iPhone GPS Customer List

Posted on 2013-11-15
2
362 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

iCloud Drive was introduced after iOS 8 was launched last year. This drive is Apple’s online storage device that lets users sync their files and access them from all their Apple devices.   There is a lot of data that is not automatically backed up…
Learn new improvements released by Google for Google Calendar. Noted in this article are simple tips and tricks that can make your everyday use of Google Calendar better.
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…

821 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