Skip to product information
1 of 1

Convert Addresses to Timezones in Excel – How to Generate Timezones from a list of Addresses, Zip Codes or Cities

Convert Addresses to Timezones in Excel – How to Generate Timezones from a list of Addresses, Zip Codes or Cities

Regular price $87.00 USD
Regular price Sale price $87.00 USD
Sale Sold out
View full details

Our Software is Used by:

Generate Timezones from an Address List in Excel

Check out how the "Excel Time Zone Generator - Generate Timezone Result from a List of Addresses in Excel" works in the video below:

The Timezone Excel Generator is an Excel - Based tool that allows the user to generate the Timezone from a list of addresses or zip codes. It allows the User to generate the Timezone for a large list of addresses, cities or Country Postal Codes all within Microsoft Excel.

Benefits of generating Timezones for Addresses Directly in Excel

What can the Excel Timezone Generator do for  you?

Easiest to use tool of its kind

Using the Excel TimeZone Generator is as easy as pasting your addresses and clicking "Generate". 

Nothing to Install

As the Excel TimeZone Generator is built 100% in Microsoft Excel, there is nothing to install. All you need is Excel Installed in your computer. 

24 Hour Support

How about you talk to me, the developer of the tool? Just Click on "Chat Now" button on the bottom left and I will answer any questions you have. 

No Coding Necessary

You do not need to write a single line of code, or copy and paste or even mess with ChatGPT! Just paste the addresses like you do in Excel and Click on "Generate" button!

100% Money Back Guaranteed!

If for any reason you are unhappy with the product...just drop me a line...I will refund your purchase in full! NO QUESTIONS ASKED!

ONE TIME CHARGE!

You buy the tool once, and you own it for life! No monthly fees!


How Does It Work?

The Excel Time Zone Calculator is an Excel Based Tool that allows the user to generate the time zone for a list of addresses. 

You can generate the time zone for a list of addresses, cities, zip or postal codes or even geolocations/geocodes in three easy steps. 

Step 1

 Enter or paste a list of Addresses, Postal Codes, Cities or Lat/Long you want to generate Timezones for. 

Step 2

Click the conveniently located  "Generate" Button!!

Step 3

That's it - The Tool will automatically generate the Timezones for the Locations in your Spreadsheet.  

What is the Purpose of the Excel Time Zone Locator?

The Purpose of the Excel Time Zone Locator is to enable the user to generate the Time Zone for a list of addresses. 



Who is the "Time Zone Locator - How to generate a Time Zones for a List of Addresses" for?

The Time Zone Locator is a quick tool to find the time zones for a list of addresses, cities or postal codes directly in Excel. It gives the user the TimeZone API functionality directly in your Excel Spreadsheet. 


Example 1 - "Company A" needs to make their sales calls for the day. In order to do that they need to group their customers and their addresses based on their timezone so that they can call them in the appropriate time. Company A uses the Time Zone Locator, to assist them to group clients based on their time zones. 


Example 2 - "Company B" has employees all over the world, needs to group their 300 employees based on their timezone location to be able to have calls with them based on their local time. "Company B" uses the Time Zone Locator for Excel and with a click of a button is able to group their employees based on their time zone. 

What do our Customers say to us

Steve Whenman - Really pleased with the Software

The Software Installed perfectly...the API setup was no problem

Really pleased with the results. 

Mandy Miller - I absolutely Love the Tool

I absolutely Love the Tool

Bob Phillips - Thanks for making such a great Product

No Issues with the Software

Vinnie - Thanks for making such a great product.

Bob

Steve Whenman - Really pleased with the Software
Mandy Miller - I absolutely Love the Tool
Bob Phillips - Thanks for making such a great Product

Frequently Asked Questions (FAQs)

  • Does this software work on Mac, or just PC?

    While the Excel Time Zone Locator  works on some version of Mac Computers, I currently do not offer support for Macs. As Macs use different VBA libraries, that can cause some conflicts with some of the functions in this tool.

  • Is this a one time fee, or ongoing?

    You will only pay once for this software. In addition, I will provide upgrades and live support via zoom if needed for one full year. The software should serve your automation needs for years to come.

  • Do I need a Google Maps API Key? What is a Google Maps API key?

    The Excel Time Zone Locator uses the Google Maps Platform to give you extremely accurate (to the 1/100th of a mile). As such you will need to setup a google maps account. It takes 5 minutes to setup and it is free of charge. You can view the instructions on how to setup the google maps api key in this page. I have also created a video where it shows step by step how to setup the api key by clicking in this youtube video.

  • Is the Google Maps API key free? Do I have to pay for my calculations?

    The Google Maps API key is free to get. However, keep in mind Google does require you to setup an account. You can run up to 40,000 calculations every calendar month free of charge. If you go over the 40,000 calculations Google charges an a-la-carte fee of 5 USD/1000 queries/calculations. More information on Google Maps API Pricing can be fond in this link.

  • Can I use Addresses or Zip codes? What format should my input data be?

    The Excel Zip Time Zone Locator  is extremely forgiving when it comes to what data you can use/enter as your central address. You may enter a combination of full addresses, zip codes, City/State or even Geocodes (Long/latitude).

    So “84122”, “ 123 Main, Park City, UT, 84101” or “Park City, UT” are all acceptable addresses.

  • Can the Excel Time Zone Locator be used for non-US addresses? Can I enter, say Canadian or British Zip Codes?

    Currently The Excel Time Zone Locator  works only with US addresses and Zip Codes. If you need a similar tool for another country you can request it here.

You will need a Google Maps API to use this tool!

All of our tools use the Google Maps API to generate results. This allows for accurate driving distance and time results and fast data. I have included some instructions on how to get a google maps API and what services to enable. Click here for more information on how to setup the Google Maps API Key.

A few more things regarding the Google Maps API Key.

You don't need to be a developer to setup a google maps api key. It takes about 5 minutes, and it is a simple as setting up an account with Google.

  • The Google Maps API Key is free to setup. It doesn't cost anything.
  • You will get up to 40,000 calculations free of charge. (Google allows for a 200 dollar credit for every calendar month).
  • If you need more than 40,000 calculations in a calendar month, google charges an a-la-carte fee of 5 USD/1000 calculations.
  • For most of my clients that use this tool, 40,000 calculations are more than enough.
  • You will need to setup a billing account with Google, although you will not be charged unless you go over the 40,000 calculations per month.
  • If you have a large number of calculations, (more than 40,000) contact me. I might be able to help.