New Excel Data Types

Ian SantillanIan Santillan
4 min read

Microsoft has partnered with Wolfram to intelligently add meaning to your data. Identify and auto-fill thousands of data points from hundreds of data types directly in Microsoft Excel. Expertly curated data provides instant interactivity and immediate answers.

View expertly curated data from within Excel

Clicking on a Wolfram|Alpha data type displays a card with associated facts, providing all the information you need without leaving Excel.

Auto-fill thousands of types of data, automatically

Copying a formula by dragging the fill handle auto-populates cells with Wolfram|Alpha’s curated data so you can focus on your project, not data entry.

Generate rich content and sophisticated spreadsheets

Automatically fetching data at scale means you can build interactive, highly customizable spreadsheets.

Featured Examples:

Food Data

Counting calories doesn’t have to be complicated. Wolfram|Alpha has data for thousands of foods and can retrieve nutrition information and daily recommended values.

View All Food & Nutrition Data Types »

Space & Astronomy Data

Wolfram|Alpha’s space data is out of this world! Explore planets, moons, satellites and more with integrated space data.

View All Space & Astronomy Data Types

City Data

City research has never been easier — your city research spreadsheet can now auto-fill values such as demographic and geographic information and produce maps.

View All Political Geography Data Types »

Art & Media

  • Famous Artwork

  • Books (Notable Texts)

  • Digimon

  • Pokémon

  • Fictional Characters

  • Movies

  • Music Acts

  • Music Albums

  • Musical Instruments

  • Musical Works

Institutions & Organizations

  • US Libraries

  • US Private Schools

  • US Public Schools

  • Universities

Political Geography

  • Administrative Divisions

  • Cities

  • Countries

  • US District Courts

  • US Neighborhoods

  • US School Districts

  • US Congressional Districts

  • Zip Codes

Points of Interest

  • Amusement Parks

  • Amusement Park Rides

  • Airports

  • Bridges

  • Buildings

  • Canals

  • Castles

  • Cemeteries

  • Dams

  • Historical Sites

  • US Mines

  • Museums

  • Nuclear Reactors

  • Nuclear Test Sites

  • Oil Fields

  • Parks

  • Reserve Lands

  • Shipwrecks

  • Tunnels

Food & Nutrition

  • Food

  • Branded Food

  • Food Comparisons & Combinations

  • Food Preparation

Animals

  • Cat Breeds

  • Cattle Breeds

  • Dog Breeds

  • Goat Breeds

  • Pig Breeds

  • Pigeon Breeds

  • Poultry Breeds

  • Sheep Breeds

Life Sciences

  • Anatomical Functions

  • Anatomical Temporal Concepts

  • Animal Anatomical Structures

  • Cognitive Tasks

  • Dinosaurs

  • Neurons

  • Plants

  • Species

Health & Medicine

  • Anatomical Structures

  • Diseases

  • ICD-9 Codes

  • ICD-10 Codes

  • Medical Tests

  • Physical Activities

  • Pilates Exercises

  • Yoga Poses

  • Yoga Positions

  • Yoga Props

  • Yoga Sequences

Space & Astronomy

  • Observatories & Telescopes

  • Astronomical Radio Sources

  • Comets

  • Constellations

  • Space Probes

  • Exoplanets

  • Galaxies

  • Crewed Space Missions

  • Meteor Showers

  • Minor Planets

  • Neblae

  • Planets

  • Planetary Moons

  • Pulsars

  • Rockets

  • Satellites

  • Solar System Features

  • Stars

  • Star Clusters

  • Supernovae

Earth Sciences

  • Atmospheric Layers

  • Impact Craters on Earth

  • Minerals and Materials

Physical Geography

  • Beaches

  • Caves

  • Deserts

  • Forests

  • Glaciers

  • Islands

  • Lakes

  • Mountains

  • Oceans

  • Reefs

  • Rivers

  • Undersea Features

  • Volcanoes

  • Waterfalls

Chemistry

  • Chemicals

  • Elements

Physics

  • Isotopes

  • Particle Accelerators

Weather & Meterology

  • Clouds

  • Tropical Storms

Technological World

  • Nuclear Explosions

How to Use Wolfram|Alpha Data in Excel

1 — Highlight data and click the Automatic button

Select cells (or columns) and then click the Automatic button accessible via the Data tab in the ribbon. Wolfram|Alpha’s natural language understanding capabilities will recognize your data type and prepare associated content.

2 — Browse associated data

Scroll through the menu of available fields and select one to have Wolfram|Alpha automatically insert the associated data into your spreadsheet. Wolfram|Alpha has thousands of expertly curated data types encompassing the sciences, art, culture and more.

3 — Automatically get data

Once a cell is Wolfram|Alpha enabled, you can use Excel formulas to retrieve Wolfram|Alpha-generated content.

4 — Browse more information

Clicking on a Wolfram|Alpha-enhanced cell reveals a card with information relevant to that cell, so you don’t need to go outside of Excel to accomplish your project.


References

0
Subscribe to my newsletter

Read articles from Ian Santillan directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Ian Santillan
Ian Santillan

Data Architect ACE - Analytics | Leading Data Consultant for North America 2022 | Global Power Platform Bootcamp 2023 Speaker | Toronto CDAO Inner Circle 2023