Wolfram Computation Meets Knowledge

Wolfram Knowledge about Countries in Microsoft Excel

Country entities include countries, dependent territories and other special areas defined by the ISO 3166-1 standard.

A few example entities...

United States
Chile
China
France
Nigeria
Norway
Japan
Indonesia
Liechtenstein
New Zealand

You can access the following properties for each entity...

  • name
  • full name
  • alternate names
  • nationality name
  • ISO name
  • country code
  • internet code
  • UN code
  • UN number
  • calling code
  • license plate code
  • capital city
  • bordering countries/regions
  • dependencies
  • regions
  • total area
  • land area
  • annual‐crop land fraction
  • natural resources
  • coastline length
  • time zones
  • wikipedia summary text
  • population
  • population density
  • population growth
  • life expectancy
  • annual births
  • annual deaths
  • median age
  • GDP
  • GDP at parity
  • real GDP
  • GDP per capita
  • GDP real growth
  • Gini index
  • consumer price inflation
  • unemployment rate
  • long‐term unemployment rate
  • labor force
  • employment in agriculture
  • employment in industry
  • employment in services
  • employment
  • language fractions
  • ethnic mix
  • religions
  • literacy rate
  • internet usage
  • mobile cellular subscriptions
  • telephone lines
  • fixed broadband internet subscribers
  • average broadband upload rate
  • average broadband download rate
  • secure internet servers
  • IP addresses
  • total vehicles in use
  • total road length
  • primary school students
  • secondary school students
  • tertiary school students
  • total students
  • total teachers
  • primary school student-teacher ratio
  • secondary school student-teacher ratio
  • public education spending, percent of GDP
  • health spending per capita
  • physicians per capita
  • hospital beds
  • Human Development Index, health
  • Human Development Index, education
  • Human Development Index, living standards
  • Human Development Index, total
  • flag
  • shared border lengths
  • + more
  • - less

Note: Wolfram entities represent physical entities as well as mathematical and other scientific concepts. Each entity type has a unique set of properties. Wolfram entity types and properties correspond to "data types" and "fields" in Excel.

How to Use Wolfram Data in Excel

Note: This is now available with a Microsoft 365 Family or Personal subscription.

1

Highlight data and click the Automatic button

Select cells or columns in a table with the text to convert, then select the Automatic button in the Data Types gallery of the Data tab. Wolfram's natural language understanding will recognize the entities and convert them.

2

Browse associated data

Select the Insert Data button that appears to browse a list of all available properties. Select one to insert data into your workbook. When you have data in a table, Excel will automatically fill the table for you. Wolfram has hundreds of expertly curated entities in Excel, encompassing the sciences, arts, culture, and more.

3

Automatically get data

Once converted to an entity, you can use key Excel features to work with data pulled from Wolfram. Sort and Filter data, or create formulas that reference an entity's properties and values.

4

Browse more information

Selecting the icon of a converted cell opens a card where you can find detailed data from Wolfram. This means you don't need to leave Excel to accomplish your goals.

Compute with Country data in the Wolfram Language