Page 1 of 1
Importing data from giovanni to excel
Posted: 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.
Re: Importing data from giovanni to excel
Posted: 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: