This page provides examples of public Coronavirus data you could download to Excel withPower Query.
The attached Excel workbooks include a working query, and each query returns data to anExcel Table.
you’re free to refresh the data by right-clicking in the table and selecting “Refresh”.
When data has changed, you will see more recent data appear.
If you’re new to Power Query,this articleexplains how to build a single query in more detail.
I can’t vouch for the quality of the data.
The links below provide more information about each website.
The COVID Tracking Project provides a grade for each state.
Excel workbooks are attached below the descriptions.
To download fresh data, right-click inside the table and select “Refresh”.
It contains current totals only, not historical data.This pagedescribes in detail how the query was created.
Each row in the data has a date.
Note: you’ll get an expression error if you make a run at refresh on a Mac.
Power Query on Mac does not support web sources yet.
Data Europa has a JSON api as well.
Data is by country by day, and would be a good candidate for aPivot Tableto provide totals.
