You might find it easier for your to handle data in a CSV file rather than in a GRIB file. This how-to shows you how to do that using ECMWF's ecCodes. You are expected to have it installed on a Linux machine before you continue. You should also add ecCodes' "bin" directory to your PATH.
Step-by-step guide
- Download 2m temperature from the Copernicus Climate Change Service (C3S)'s Climate Data Store (CDS) and save the data as file t2m_20000801.grib. In this example, selections are set as below:
- Dataset: ERA5 hourly data on single levels from 2000 to 2017 (you may see different years as new data is released)
- Parameter: 2m temperature
- Product type: Reanalysis
- Year: 2000
- Month: August
- Day: 01
- Time: 06:00, 12:00 and 18:00
- Format: GRIB
- Check the GRIB file by issuing the "grib_ls -P time t2m_20000801.grib", you should see three GRIB messages in the file at three different times: 600, 1200, 1800. Remember three time values were selected in step 1.
Say I want to extract lat, lon, 2t (2m temperature) at time = 12:00 from the GRIB file. Run "grib_get_data -w time=1200 t2m_20000801.grib > t2m_20000801.csv" and you will get a file containing data like below:
Latitude, Longitude, Value 90.000 0.000 2.7346786499e+02 90.000 0.250 2.7346786499e+02 90.000 0.500 2.7346786499e+02 90.000 0.750 2.7346786499e+02 ...
- Remove two commas in the header line of the CSV file, you will be ready to import it in Excel.
If you have CDS API and ecCodes (with its Python interface) installed, you can do the above by writing up a Python script.
