On the right side, we have a window called “Queries & Connections,” which suggests that data is imported through a Power Query. Click “Load” at the bottom, which will load data to an Excel file in Excel table format.
It looks like this.Īs you can see above, it has automatically detected the delimiter as a “Comma” and segregated the data into multiple columns. It will display the data preview before it loads to the Power Query model.Now, it will ask you to choose the file you would like to import, so choose the file and click on “OK.”.Go to the “Data” tab, and under “Get Data,” click on “From File.” Under this, click on “From Text / CSV.”.We will use a Power Query to import this data and transform it into a format that Excel loves working with.
0 kommentar(er)
