By SC
Using Get data function in excel data can be imported form Text ,CSV,Table range ,web etc. many other file formats.It is very useful feature in excel below we will discuss how to get data from different format of files in excel.Â
Import data from Web using excel:
1 From Excel Bar Click On Data Option and Then Select Get Data From Web A Window Will Pop Up. Enter Site Details from which The Table You Want To Import and Press GO.
Then Click On Import and Data will Be Imported. Thus By Using This You Can Import Tables From Web Instead of Copy and Paste. As Shown Below
Excel get data from Text/csv:
To get data from excel file first we have to click on Data then on “from text/CSV”.A window will be opened up and you have to import text or CSV file where it is located.
Excel will establish connection to this file and power query window will pop up.You have to click on Load.Data will be loaded in excel sheet.