At the time you follow this tutorial, your data file might be stored somewhere else. NOTE: The path mentioned here in the screenshot is the one where I have located the file. Click on the Browse… button and navigate towards the path where the data file is located. There, you have to browse the path on which the file is located. Step 3: As soon as you click on the From Folder option, a new window will pop up. This option we are using over From Text/CSV option because it has more versatility in it than the latter. We will navigate towards the option named From Folder, which is under From File dropdown. Step 2: As soon as you click on the Get Data dropdown, you get several options from where you actually can pull the data. Open an Excel file > Click Data tab in Excel ribbon > click Get Data dropdown under the Get & Transform Data section. We need to create a connection so that we can pull the data from a text file in Excel. We will use Power Query to import this file under Excel and try to manipulate the same using Power Query itself.

Suppose we have a text file in a folder that consists of 1000 rows of data. Ideally, it can be considered an ETL tool that allows you to Extract, Transform, and Load the data into Excel. Power Query can help you in automating the data import task in Excel with minimal effort, and it is so much easier than you can feel navigating through Excel itself. These sources include some relational databases such as Microsoft SQL Server, Microsoft Access, Azure, etc., as well as data files such as Excel, Text, CSV, XML, JSON, etc. Power Query is a powerful excel tool that allows a user to import data from various sources into Excel. Excel functions, formula, charts, formatting creating excel dashboard & others Power Query to Automate the Data Import Process

How to add power query to excel 2016