Geocode by Awesome Table

Introduction

Geocode by Awesome Table is a map tool that helps you get latitudes and longitudes from addresses in a Google Sheet and display them on a Google map you can share.

Capabilities, Benefits, and Key Features

  • Convert multiple addresses into Maps coordinates - longitudes and latitudes - at once
  • See and edit all your Google Sheets spreadsheets with new columns for the longitudes and latitudes
  • Display and run third-party web content in prompts and sidebars inside Google applications
  • Connect to an external service
  • Allow this application to run when you are not present
  • See your primary Google Account email address
  • See your personal info, including any personal info you've made publicly available

Limitations / Technology Requirements

Geocode works with Google Sheet.

What can I expect?

  • Support Tier: Tier 2 - Sponsor Support: If students were to contact IT Help, they refer the user to an individual sponsor, typically an instructor of a given course. The sponsor would work directly with the vendor on any unresolved issues.

  • Acquisition Model: Registration: Online user account is used to login to the application each time of use, frequently using Miami's Identity and Access single-sign on capability with your Miami UniqueID and password. 

  • Licensing Model: Registered User License: The license is included with online registration.

  • Authentication Model: GSuite or Azure: Application allows for users to login using a federated login to Google or MS Azure. If using your Miami account, @miamioh.edu,  on these services, the login is subject to the same requirements as though you logged into those services directly. In many cases, it is possible to use a personal Google or Microsoft account that is unrelated to your Miami account. 

Who may use it?

Miami University faculties, students, and staff.

How do I get started?

  • Visit this link and click "Install" to add Geocode to your Google's account add-ons list
  • Create a Google Spreadsheet (or reuse one of your existing ones)
  • Add physical addresses and other info
  • Use the spreadsheet menu Add-on > Geocode
  • Indicate the column containing your addresses 
  • Click on the button to start the geocoding
  • That’s all! Once the geocoding is done, you will see two more columns in your spreadsheet (for latitude and longitude data) and a link to the Maps view created.

Is there a charge to me or my department?

There is no cost for this application.