Help with Excel and Covid Data from OWD

Hello,

I’m fairly new to this and only became aware of the Github platform this week. I have a question that I think is very basic.

I want to export the data from Our World in Data to an Excel sheet and have it update automatically without the need to import the data manually every day.

The process I am following is:

  1. At this URL: covid-19-data/public/data/latest at master · owid/covid-19-data · GitHub I take the .csv file and click on Raw.

  2. I go to Excel. I click on Data; From Web and paste this URL. (https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/latest/owid-covid-latest.csv)

  3. I load the data.

The doubt that I have is if once I do these steps when I click on Refresh the information is going to be updated automatically once Our World in Data updates it? It seems that it does not happen.

Thank you very much to whoever can help me. The truth is that my knowledge in this area is practically null. Sorry if the message was too long

It’s hard for me to tell since I’m not sure if this Our World in Data which you mentioned is an application or something else. If it’s an application, exporting its data to an Excel sheet and then modifying that sheet shouldn’t have any impact on the application data, because exporting data is a one-way operation only.

To achieve your goal you would need to either import the updated data from your update Excel (if the application has an equivalent import option, and if it support importing data in Excel format), or alternatively edit the actual data used by the application, if this is possible AND safe to do.

There are many factors at play here which might affect this type of operation, and without knowing how this application works it’s hard to provide you with advise on how to achieve this in a safe manner.

Some applications store their data in open format files, e.g. as CSV files, whereas others use proprietary formats or even databases. You’ll have to consult the application manual to learn more about how it stores data, or peek around its installation folder and/or the folder(s) where it stores user data (e.g. in Users shared folders, maybe in a dedicated folder for this app) to see how the data is being stored.

My guess is that if your application allows you to import data from external files then it should support the CVS format, which is very common. Whether simply feeding it the raw CVS file from GitHub would result in updating the pre-existing dataset (on COVID), or creating a new dataset instead, largely depends on the application, and whether the import command can be associated to a specific dataset or not.

From my experience, if an application doesn’t clearly provide instructions on how to import data from external files and different formats, then that’s because it’s not a natively supported feature, which means that tampering with the application data files might result in data corruption (especially if trying to do so when the application is running).