Wolfram Knowledge about Exoplanets in Microsoft Excel
Exoplanet entities include a large collection of confirmed planets beyond the solar system.
A few example entities...
| 51 Pegasi b | ||||
| CoRoT-7 b | ||||
| GJ 86 b | ||||
| 55 Cancri e | ||||
| HD 139357 b | ||||
| HD 290327 b | ||||
| HD 5319 b | ||||
| HD 6434 b | ||||
| HD 82886 b | ||||
| Kepler-9 d |
You can access the following properties for each entity...
- name
- component
- mean density
- average diameter
- diameter interval
- escape velocity
- gravitational constant mass product
- gravity
- mass
- mass interval
- rotational moment of inertia
- object type
- planetary equilibrium temperature
- planetary equilibrium temperature interval
- average radius
- average radius interval
- Roche limit
- surface area
- volume
- average orbit distance
- distance from Earth
- distance from Sun
- distance interval
- transit duration
- orbital eccentricity
- heliocentric XYZ coordinates
- orbital inclination
- orbital inclination interval
- orbit center
- orbit circumference
- orbital period
- orbital period interval
- longitude of periapsis ϖ
- longitude of periapsis interval
- primary star K semiamplitude
- orbital semimajor axis
- orbital semimajor axis interval
- orbital semiminor axis
- transit depth
- next transit time
- alphanumeric name
- alternate names
- wikipedia summary text
- altitude
- next transit altitude
- apparent altitude
- azimuth
- azimuth at rise
- azimuth at set
- above the horizon
- constellation
- daily time above horizon
- declination
- next maximum altitude time
- right ascension
- next rise
- next set
- discovery method
- discovery year
- + more
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.
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.
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.
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.
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.
