Importing data from giovanni to excel

Please enter here to ask a question about any NASA Science related topics!
Post Reply
aborb003
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?
https://www.youtube.com/watch?v=49NnxSr ... 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.

Tags:

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

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:
https://disc.sci.gsfc.nasa.gov/informat ... nd%20Excel

Post Reply