How I made global.1751_2021.ems9.* __________________________________ Start with: https://zenodo.org/record/7215364/files/GCB2022v27_MtCO2_flat.csv?download=1 Find it at https://zenodo.org/record/7215364 That page is linked-to from https://www.globalcarbonproject.org/ Delete everything (except the header line) which doesn't start with: "Global","WLD", Copy the comments at the top from a previous version; I used the first 15 lines of: w:\html\sealevel\carbon\ICOS_and_GCP\GCB2021v34_MtCO2_flat_global-only.tab Fix the URLs, the date & the version number in the comments. The "Country" and "ISO 3166-1 alpha-3" columns (the first two) must be deleted, the "Coal","Oil","Gas" columns must be rearranged to Gas,Oil,Coal, and the units must be converted from GtCO2 to GtC. So this: "Country","ISO 3166-1 alpha-3","Year","Total","Coal","Oil","Gas","Cement","Flaring","Other","Per Capita" ... "Global","WLD",1938,4201.279796,3228.046168,796.989445,135.493153,38.550531,,,1.854686 Becomes this: Year,Total,Gas,Oil,Coal,Cement,Flaring,Other,Per_Capita ... 1938,1144.930122,36.973142,217.577171,879.273899,10.505368,,,0.505982 Delete the first two columns manually, in any editor; this is SlickEdit c/"Global","WLD",// Delete all quote marks from the header line and all subsequent data lines (leave them in the comment block at the top). Then use this program to make the other changes: w:\html\sealevel\carbon\ICOS_and_GCP\cvt_MtCO2_to_MtC.pl But first you've got to change the format to tab-delimited. There are no tabs in the original file, and the only quote marks are around fields, so it's easy to do it in SlickEdit. Then save it as: GCB2022v27_MtCO2_flat_global_only_temp1.tab Now run the program: perl cvt_MtCO2_to_MtC.pl global.1751_2021.ems9.tab Finally, copy the comments at the bottom from a previous version to the bottom of global.1751_2021.ems9.tab I used: W:\html\sealevel\carbon\temp_work_files\global.1751_2020.ems8.csv (and then I tweaked the comments) I created the .txt version in SlickEdit via: tabs 7 21 35 49 62 75 87 99 save +E w:\html\sealevel\carbon\ICOS_and_GCP\global.1751_2021.ems9.txt Then load the .tab version into Excel and save the .csv and .xlsx versions.