How to filter your data using Power Query?

You can filter the data using Power Query from excel and choose only the countries you need. 

Here is an example where I loaded the World Cities Database CSV file to Power Query and chose only cities in Iran: 


1. Go to the "data" tab in excel. Select get data from text/CSV. 

1.png

2. Import the CSV file. 

3.png

2. Select transform data. 

4.png

3. Go to the country column. Click load more and select only the countries you need. 

9.png
5.png

4. Click "Close and Load" to import the data to excel. 

6.png