In this article:

Import Weather Data into Google Sheets (Easiest Way in 2024)

May 8, 2024

Google Sheets Weather

There are a number of methods to import weather data into Google Sheets that are suitable for different needs and technical abilities. This guide focuses on utilizing Google Sheets' built-in functions like IMPORTDATA, which offers a straightforward way to integrate weather information directly into your sheets without the need for complex scripting or API management.

How to Import Weather Data into Google Sheets

Follow the steps below to easily import weather data into Google Sheets. 

1. Create or Log Into Your Visual Crossing Account

To start, navigate to the Visual Crossing website. If you're new, sign up for a free account to access up to 1000 weather forecasts per day. Existing users can simply log in.

google sheets weather

2. Navigate to the Query Builder on Visual Crossing

Once logged in, find the Query Builder tool on the website. This feature allows you to create detailed weather data queries based on your needs.

import weather data into google sheets

3. Specify Your Weather Forecast Location

In the Query Builder, input the specific location you're interested in. You can use a city name, ZIP code, or even latitude and longitude coordinates. The system will use this to pinpoint the exact weather forecast for your area.

4. Choose Your Weather Forecast Duration

Decide on the length of the forecast you require. For instance, selecting "Next 15 days" will generate a two-week weather forecast. The Query Builder provides various options to suit your needs.

5. Review Your Weather Data Preview

After setting your parameters, the Query Builder will offer a preview of your weather forecast. This helps you verify the data before importing it into Google Sheets.

6. Copy the Weather Data Query URL

Look for the API button in the Query Builder to reveal the query URL. Ensure the output format is set to CSV for Google Sheets compatibility.

Copy this URL, which includes your API key if you're logged in.

7. Insert Weather Data into Google Sheets with IMPORTDATA

Open Google Sheets and select a cell to start. Use the formula =IMPORTDATA("Your Copied URL"), replacing "Your Copied URL" with the one you obtained. This imports your weather data directly into the spreadsheet.

8. Format Your Imported Weather Data in Sheets

Once your data is imported, you might need to adjust its format for clarity and usability. For example, you can format the date columns to match your regional settings and split data into separate columns for better analysis.

We hope that you now have a better understanding of how to import weather data into Google Sheets. If you enjoyed this article, you might also like our article on how to repeat header row in Google Sheets or our article on fixing the error “Your access has expired” in Google Sheets. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->