Solved

iPhone GPS Customer List

Posted on 2013-11-15
2
359 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
Comment Utility
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
Comment Utility
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 to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

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

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now