Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

If it isn’t, Power Query will prompt you to convert the data range. SEE: Here’s how to create and populate a table in Microsoft Excel’s Power Query.

Power Query is a powerful tool that simplifies this process, allowing you to import and transform data from various sources into a single table. Use Power Query to connect to CSV, text, or Excel files ...

How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.