Importing data from giovanni to excel

Please enter here to ask a question about any NASA Science related topics!
Post Reply
Posts: 5
Joined: Mon Jan 25, 2021 1:40 am America/New_York

Importing data from giovanni to excel

by aborb003 » Fri Feb 26, 2021 1:54 am America/New_York

Hi, is there still a way to import data from Giovanni to excel like in this video? ... ASAGESDISC
Or are there other ways where I can access the data points so I can import them to a spreadsheet from a time series area-averaged.


GES DISC - jimacker
User Services
User Services
Posts: 149
Joined: Mon Sep 30, 2019 1:57 pm America/New_York
Answers: 2

Re: Importing data from giovanni to excel

by GES DISC - jimacker » Fri Feb 26, 2021 2:10 pm America/New_York

Yes, this can still be done. For area-averaged time-series data, the output is still available as CSV, consisting of time/date and the value of the area average for each time increment.

If you are seeking the values from the grid of a time-averaged map, we have a How-To document describing how this is done. Basically, the NetCDF download is opened in NASA Panoply, exported as a CSV file from Panoply, and then transformed with an Excel spreadsheet macro into lat/lon/value for each grid point. This would still have to be done for individual time-averaged maps in time consecutive order if you wanted data over a region.

Here is the link to the How-To document for the latter: ... nd%20Excel

Post Reply