Microsoft Excel is free to use, with limitations. For the cost of a Microsoft 365 subscription, you get a whole lot of power.
Once that's done, it's important to ensure the data is in the form of an Excel table. We won't be able to create pivot tables without this, which are essential for creating a dashboard.