This page provides examples of public Coronavirus data you can download to Excel with Power Query. Each example has a link, a screenshot to show what the data looks like in Excel after being imported, and an Excel workbook.
The attached Excel workbooks include a working query, and each query returns data to an Excel Table. You can 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 article explains how to build a single query in more detail.
This project depends on Power Query, so you'll need Excel 2013 or later on Windows. On a Mac, you can refresh queries with Office 365 Excel, but you can't yet edit or create queries.
Sample Coronavirus Data
The purpose of this article is to show examples of how to get Coronavirus testing data into Excel. 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".
To inspect or edit a query, click Queries and Connections on the Data tab of the ribbon, then double-click on the query. This article explains how to build a single query in more detail.
This data contains the latest snapshot of Coronavirus testing data for the United States at the state level. It contains current totals only, not historical data. This page describes in detail how the query was created.