Wolfram Knowledge about Minor Planets in Microsoft Excel
Minor Planet entities include a subset of the minor planets that have been issued an official number by the International Astronomical Union.
A few example entities...
Pluto | ||||
2267 Agassiz (1977 RF) | ||||
1827 Atkinson (1962 RK) | ||||
640 Brambilla (1907 ZW) | ||||
1 Ceres | ||||
136199 Eris (2003 UB313) | ||||
1224 Fantasia (1927 SD) | ||||
136108 Haumea (2003 EL61) | ||||
136472 Makemake (2005 FY9) | ||||
735 Marghanna (1912 PY) | ||||
4641 (1990 QT3) | ||||
1809 Prometheus (2522 P-L) | ||||
559 Nanon (1905 QD) | ||||
3095 Omarkhayyam (1980 RT2) | ||||
3426 Seki (1932 CQ) |
You can access the following properties for each entity...
- name
- absolute magnitude H
- age
- albedo
- apparent magnitude
- color
- mean density
- average diameter
- dimensions
- equatorial angular velocity
- equatorial diameter
- equatorial frequency
- equatorial radius
- escape velocity
- gravitational constant mass product
- gravity
- Hill radius
- mass
- maximum temperature
- minimum temperature
- rotational moment of inertia
- number of moons
- object type
- oblateness
- obliquity
- polar diameter
- polar radius
- average radius
- Roche limit
- rotation period
- known satellites
- shape
- slope parameter
- SMASS spectral type
- solar day
- sphere of influence radius
- stationary orbit radius
- stationary orbit speed
- surface area
- Tholen spectral type
- volume
- largest distance from the Sun
- next apoapsis time
- last apoapsis time
- longitude of ascending node Ω
- average distance from Earth
- average orbit distance
- average orbit velocity
- average heliocentric velocity
- distance from Earth
- distance from Sun
- Earth minimum orbit intersection distance
- eccentric anomaly
- orbital eccentricity
- heliocentric XYZ coordinates
- orbital inclination
- mean anomaly
- mean motion
- orbital angular momentum
- orbital kinetic energy
- orbital moment of inertia
- orbit center
- orbit circumference
- orbital period
- argument of periapsis ω
- longitude of periapsis ϖ
- next periapsis time
- last periapsis time
- nearest distance from the Sun
- orbital semimajor axis
- orbital semiminor axis
- true anomaly
- instantaneous heliocentric velocity
- atmospheric pressure
- atmospheric scale height
- average temperature
- effective temperature
- alphanumeric name
- alternate names
- astrological symbol
- IAU name
- IAU number
- provisional designation
- wikipedia summary text
- image
- altitude
- next maximum 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
- apparent direction
- right ascension
- next rise
- next set
- elongation from the Sun
- next transit time
- discoverers
- 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.