Geocode by Awesome Table Alternative: 5 Options Now That It's Abandoned

Geocode by Awesome Table has over 1 million installs, but its last update was April 2024 and recent reviews report widespread failures with no developer response. The best free alternative is InstaMaps, which offers =GEOCODE() formulas and generates live maps without requiring a Google API key.

This is for spreadsheet users whose address plotting suddenly stopped working. Whether you manage a 200-home delivery farm, coordinate 5 regional sales crews, or just need to map 47 weekly stops, you will have a functioning sheet with coordinates and a shareable map within five minutes.

What Happened to Geocode by Awesome Table?

Credit where it is due: for the better part of a decade, Geocode by Awesome Table was the default answer for getting latitude and longitude into Google Sheets. The marketplace statistics reflect this dominance: it holds over 1 million installs and 463 reviews. But the numbers also tell a story of abandonment. The add-on was last updated in April 2024, and its most recent reviews uniformly report the exact same failure state.

Users state that the app is down, geocoding requests fail, and nobody from the developer has responded. The developer, Talarian, shifted its focus to its main Awesome Table product, leaving the geocoding tool unattended.

An unmaintained add-on that bridges your spreadsheet to external APIs is living on borrowed time. Google frequently tightens its OAuth security requirements, alters billing structures, and deprecates older endpoints. When Google inevitably updates its API quotas or connection protocols, the integration breaks.

Because Talarian is no longer pushing updates, there is no patch coming to resolve these API mismatches. When an add-on breaks, your formulas return `#ERROR!` or `#N/A`, halting your data processing. Even if the add-on flickers back to life temporarily, building a workflow on abandoned software guarantees you will have to migrate your data later. You are left rebuilding broken sheets on someone else's schedule, rather than choosing a maintained alternative today.

How to Replace Geocode by Awesome Table with InstaMaps

Migrating your workflow from Geocode by Awesome Table to InstaMaps takes less than five minutes. You do not need to create a Google Cloud project, attach a billing account, or generate an API key.

Here is the exact step-by-step process to get your coordinates back without writing complex scripts:

1. Install the InstaMaps add-on from the Google Workspace Marketplace.

2. Open your sheet, click `Extensions` in the top menu, select `InstaMaps`, and click `Enable formulas` to open the sidebar.

3. Clean your address data to prevent geocoding failures. Raw CRM data often contains trailing spaces or incorrect formatting. If your addresses sit in cells A2 to A201, click cell B2 and type `=CLEAN_ADDRESS(A2:A201)`.

4. Run the geocoder on the newly cleaned data. In cell C2, type `=GEOCODE(B2:B201)`. Press Enter, and InstaMaps processes the range, returning the exact latitude and longitude for each row.

5. Generate your visual map. In cell D2, type `=INSTAMAP(C2:C201)`. This returns a live, hosted shareable map URL that updates automatically whenever you add or change addresses.

6. Automate the process without typing. Use the InstaMaps sidebar (Extensions > InstaMaps > Enable formulas). The AI detects your address columns automatically. Click the `Build-the-workflow` button, which writes the entire chain of formulas for you.

Worked Example: Geocoding a 200-Home Delivery Route

Consider a logistics manager responsible for a 200-home farm delivery route. You have a sheet containing all 200 addresses, but today you need to assign 47 specific stops to your 5 delivery crews, map the locations, and share the routes.

Here is how you execute this in InstaMaps without generating API keys:

1. Filter your master sheet to show only the 47 stops assigned for today. Copy those 47 rows into a new tab, ensuring the addresses sit in cells A2 through A48.

2. Standardise the text. Raw data exports inconsistently. In cell B2, enter `=CLEAN_ADDRESS(A2:A48)` to strip out errant commas, correct capitalisation, and standardise the address structure so the geocoder does not trip over formatting errors.

3. Get the coordinates to plot the stops. In cell C2, enter `=GEOCODE(B2:B48)`. InstaMaps processes the 47 rows and outputs the precise latitude and longitude. Because you are within the free tier limit of 100 lookups per day (1,000/day with a free email unlock), this batch processes without hitting paywalls.

4. Distribute the stops to the crews. Generate a live map directly in your sheet. In cell D2, enter `=INSTAMAP(C2:C48)`.

5. This formula returns a hosted URL. Clicking it opens an interactive map of all 47 locations. If a customer cancels and you delete row 25, the map updates automatically. Share this URL directly with your 5 drivers, giving them a live view of their stops without requiring them to log into Google Sheets.

The 5 Best Geocode by Awesome Table Alternatives

All five of these Google Sheets add-ons are actively maintained as of 2026. The primary differences lie in pricing structures, total install counts, and whether they force you to manage your own Google Maps API key. The old Geocode by Awesome Table add-on never required an API key, so that specific requirement is the biggest migration hurdle.

InstaMaps (Free, 0 API key required). InstaMaps is the closest like-for-like replacement for former Awesome Table users. It is entirely free and requests access only to the spreadsheet it is running in, rather than your entire Google Drive. You can access the tool via the sidebar (Extensions > InstaMaps > Enable formulas), which inserts custom functions without manual typing. You can clean messy text using =CLEAN_ADDRESS(A2) before running bulk coordinates with =GEOCODE(A2:A50). The built-in 'Build-the-workflow' button writes entire formula chains automatically. It does not offer cell-level recalculation control, operating strictly on column ranges rather than individual cells.

Maps for Sheets (Free + your Google API costs). This is the largest maintained add-on in the category with over 1 million installs. The catch is that you must create a Google Cloud project, enable the Geocoding API, attach a billing account, and paste your API key into the sheet before anything works. Setup takes roughly 15 minutes if you have a technical background, but it stalls non-technical teams. All usage bills directly against your own Google Maps quota.

Mapping Sheets (Freemium, from ~$25/year). With 960,000 installs, this is a long-running, dependable product. It uses a sidebar to configure maps rather than relying on in-sheet formulas. The free tier handles very small datasets, but paid plans are necessary for larger address lists and advanced marker customisation. It involves more manual configuration than InstaMaps.

Map My Sheet (Freemium, from ~$6/month). A smaller tool at 107,000 installs, but highly regarded for its responsive developer. Support replies actually happen-a trait former Awesome Table users suddenly value. Good marker customisation and filtering options are locked behind the paid tier.

Geosheets ($19.99/month). The only formula-native option on this list. If your workflow relies entirely on cell-level functions that recalculate automatically as data changes, Geosheets is built for this. The free tier is limited to 5 maps and 200 daily function requests. Serious use requires the monthly subscription.

Limits and Honest Alternatives

InstaMaps operates on strict daily quotas to manage server costs. The default free tier allows exactly 100 lookups per day. If you verify your account through the free email unlock, this limit increases to 1,000 lookups per day at no cost. Hitting the 1,000 daily cap will temporarily pause your processing until the quota resets.

If you have a massive, one-off batch of addresses-such as migrating a legacy sheet with 5,000 rows-do not use the add-on. Instead, use the free InstaMaps web geocoder at get-instamaps.com/tools/geocoder. You can paste up to 100 addresses at a time and copy the latitude and longitude coordinates directly back into your sheet. It requires no installation and no API key. Once the list is geocoded, the two follow-ups people ask for most: every ZIP code within a radius of a point, and one Google Maps link for up to 100 stops in the best visiting order.

When does a paid tool or API-driven option actually become necessary? If you process more than 1,000 rows on a daily, automated basis. For example, if a CRM feeds 500 new rows into your sheet every few hours, relying on InstaMaps will fail by the second batch of the day. In that specific scenario, Maps for Sheets is the correct choice. Because it bills directly against your own Google Maps API quota, it removes the 1,000-row daily ceiling entirely. You simply pay Google for your exact usage.

Keep in mind that bulk functions like =GEOCODE(A2:A500) count every single row evaluated against your daily quota. If you only need to map 200 homes across 5 delivery crews with 47 stops, the InstaMaps free tier easily covers the workload.

Who This Is For: Choosing Your Replacement

If you want a zero-setup, zero-cost replacement: Choose InstaMaps. It is built for the majority of users who just want to paste addresses, run =GEOCODE(A2:A100), and generate a shareable map link with =INSTAMAP(). You never have to touch the Google Cloud Console, and you can build templates directly from get-instamaps.com/templates.

If you are a heavy data controller with massive volume: Choose Maps for Sheets. This is strictly for users managing thousands of rows daily who already possess technical knowledge of Google Cloud Platform billing and API quotas. You trade setup friction for unmonitored scale.

If you are a formula-native builder: Choose Geosheets. If your workflow demands cell-level control where changing one address automatically recalculates downstream lookups, you need this structure. It requires a $19.99/month subscription but provides granular control that column-based tools do not offer.

Common Questions