You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Virtual tables connect the Power Platform to business data stuck in silos, enriching it to use with workflows, AI tools and custom apps.