Solved

iPhone GPS Customer List

Posted on 2013-11-15
2
367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

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.
Email is way too noisy, prone to hiding the important stuff, and really becoming unreliable for critical/timely communications. There are better ways to communicate.
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 tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

691 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