What was the temperature on a date?

It is often useful to know what the temperature was on a specific date in the past at a location. This article will show you how to get the answer to your question in just a few seconds. There are several easy ways to do this, and we’ll start with the most simple.

Using the Weather History Dashboard to find the temperature on a date

The weather history dashboard is completely free to use and can give you historical temperature information in just a few seconds. Here are the steps:

  1. Visit https://www.visualcrossing.com/weather-history
  2. Enter your location and your date or date range
  3. Click the View data button
  4. The Weather History Dashboard will show you the temperature

If you prefer to follow screenshots, here is what you will see.

Type your own location or select from one of the list of major world cities.
Also, you can select any date or date range back to 1970.
You will instantly see the maximum and minimum temperature as well as other weather measures for your required location.

Downloading the temperature on a date as a CSV or Excel file

It is also very easy to download the temperature on a date as a CSV or Excel file. You can then import your file into Excel or virtually any other data analysis tool.

  1. Sign up for a free account at https://www.visualcrossing.com/weather-query-builder/
  2. Log into your new account
  3. Enter your location (or select the option to use your current location)
  4. Select the Historical Data button at the top (unless you want Forecast temperatures instead)
  5. Use the calendar to select your date or date range. (You can also change the radio button from Day to Hourly data if you prefer.)
  6. Click the Request Weather Data button
  7. You can now see your weather data. Click the Download all data as CSV button to download a CSV file or Download all data as Excel button if you prefer native Excel format.

Again, if you prefer to follow screenshots, here is what you will see.

First sign up for your free weather account
Then enter your location or click the Use your location link to automatically enter your current location.
Select the Historical Data button (unless you are looking for forecast data).
Use the pop-up calendar to select your Date Range.
Then press the Request Weather Data button.
You can see your weather information on a calendar view or grid by clicking the top buttons.
Press the Download all data as CSV button or Download all data as Excel button to download the data for analysis in Excel or any other analysis tool.

If you need more details on how to sign up for your free account and download data, please take a look at these detailed tutorials.

How to sign up for a Weather Data & Weather API Account
How can I download weather history data as a CSV file?
How to load weather forecast data as a Microsoft Excel XLSX file

Getting the temperature on a date via an API for use in your app or code

If you are writing code or script and need to get the temperature for a date, you can get CSV or JSON data directly via the weather API. This allows you to automate the temperature retrieval process and use the resulting data in your business processes, database ETL, or custom app.

  1. Sign up for a free account at https://www.visualcrossing.com/weather-query-builder/
  2. Log into your new account
  3. Press the orange Account button in the upper right to obtain your API Key.
  4. Either use the web-base query builder to create your query URL or create the query via your code or script.
The Account dialog shows your API key in the area blurred out in this screenshot.

If you need more details on how to build and run an API query, take a look at the documentation or follow the detailed tutorials below.

Building and Running your first weather API query
How to use the Timeline Weather API to retrieve historical weather data and weather forecast data in Java

Questions or need help?

If you have a question or need help, please post on our actively monitored forum for the fastest replies. You can also contact us via our support site or drop us an email at support@visualcrossing.com.

Scroll to Top
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.