Importing data from giovanni to excel

Use this Forum to find information on, or ask a question about, NASA Earth Science data.
Post Reply
Posts: 5
Joined: Mon Jan 25, 2021 1:40 am America/New_York
Answers: 0

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: 310
Joined: Mon Sep 30, 2019 1:57 pm America/New_York
Answers: 3
Has thanked: 2 times
Been thanked: 4 times

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:
[url] (/information/howto?keywords=excel&title=How%20to%20Create%20Maps%20with%20Giovanni%20and%20Panoply:%20Creating%20Quantified%20ASCII%20Text%20Map%20Output%20with%20Giovanni,%20Panoply,%20and%20Excel)[/url]

Post Reply