Excel Time-Zone Generator
Excel Time-Zone Generator
The Excel Time Zone Generator is an Excel-Based Tool that allows YOU as the user to Generate Time Zones from a list of Addresses, Zip Codes or Cities directly in your Excel Spreadsheet.Â
Couldn't load pickup availability
Our Software is Used by:
Generate Timezones from an Address or Postal Code List in Excel
A quick Demo Video of how the Excel Time Zone Generator works!
The Excel Time Zone Generator is an Excel-Based tool that converts addresses, zip codes or cities and even geocodes to time zones. It allows the user to generate time zones for a large list of addresses with a click of a button! It will save you hours of individually searching for the time zones of various locations. No coding necessary.
Why the "Excel Time Zone Generator" is the tool you need to generate the time zones of 1000's of addresses at once?
My goal here at ExcelDistanceCalculators.com is to provide the easiest-to-use and most affordable tool of its kinds.
Nothing to Install
As the Tool is built in Excel, there is nothing to install. Just open the file, paste your data.
One Click Gets you Results
Once you paste the data, you click "Generate" and the Time Zones Results will show on your page. It's that easy.
No Ongoing Charges
Once you purchase my Excel Time Zone Generator...you own it for life. No monthly or annual charges. Consider the Multi-User license for Unlimited Users.
World Class Support
If you have any questions...just Call me @ 801-243-8350 or Chat with me via the Chat Window. If needed, I will Zoom with you to make sure the product is setup correctly and you get all the help you need...in real time.
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!
Oh just So Easy to Use!!
It will be the easiest to use tool of its kind. Just "Paste" the "List of Addresses" into the spreadsheet...click "Generate" and the corresponding Time Zones will appear as if by Magic. No Coding Necessary!!!!!
How Does It Work?
The Excel Time Zone Generator 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 Generator?
The Purpose of the Excel Time Zone Generator is to enable the user to generate the Time Zone for a list of addresses directly into Excel
Who is the "Excel Time Zone Generator" for?
The Time Zone Generator 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 Generator, 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 Generator 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
This tool was so helful and worked like a charm
Bob Phillips - Thanks for making such a great Product
No Issues with the Software
Vinnie - Thanks for making such a great product.
Bob
Milan Stamenkovic - It's a great program
Everything is working great so far. It's a great program.
Travis Robey - The Product Is Amazing
The product is amazing!
Matthew Smith - It's amazing, love it!
It's amazing, love it! Saved me weeks of analysis!
Hanna Ferguson - Software works perfectly
This excel sheet is going to make a massive difference to how much time we spend on mileage calculations! Thank you for creating this.
Steve Whenman - Really pleased with the Software
Mandy Miller - I absolutely Love the Tool
Bob Phillips - Thanks for making such a great Product
Milan Stamenkovic - It's a great program
Travis Robey - The Product Is Amazing
Matthew Smith - It's amazing, love it!
Hanna Ferguson - Software works perfectly
Frequently Asked Questions (FAQs)
-
Does this software work on Mac, or just PC?
While the Excel Time Zone Generator 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 Generator uses the Google Maps Platform to give you extremely accurate data. 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 Time Zone Generator 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 Generator be used for non-US addresses? Can I enter, say Canadian or British Addresses?
Absolutely. The Excel Time Zone Generator works with addresses from all over the world.
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 time zone results and fast data. I have included some instructions on how to get a google maps API and what services to enable. Click on this video 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.
