Discover Talent™

Country Flags and Data in Excel Automatically  Tired of manually searching for country flags, GDP, and other details for your Excel spreadsheets? Many users waste time copying and pasting information from different websites. In this tutorial, you will learn a faster and smarter method using Excel’s built-in Geography Data Type. This feature allows you to instantly access important country data such as: Country flags GDP Largest city Population Area Currency And more How to Automatically Get Country Information in Excel Enter your list of country names in an Excel worksheet (Optional) Click on Insert and choose Table to convert your list into a table for easier data management With the country names selected, go to the Data tab Click on Geography under the Data Types section Excel will recognize each country and display a small icon to confirm the data type Use the Add Column button that appears to select the fields you want to retrieve, ...