Is there a way to get data from Excel to Power Query?

You may already be familiar with the “Get Data” function in Excel. You can use this feature to send data from your worksheet to Power Query. But this only works for defined data ranges; in other words, tables and named ranges only.
For More Information Please Refer:

You May Also Like to Read: