Wolfram Computation Meets Knowledge

Wolfram Knowledge about Stars in Microsoft Excel

Star entities include a large collection of stellar objects from a variety of catalogs, including subsets of the Yale Bright Star Catalog, the Hipparcos Catalogue, the Henry Draper Catalogue and the Gliese Catalogue.

A few example entities...

α Muscae
β Indi
HIP 44511
N Velorum
HIP 72220
HIP 91935
Kaus Australis

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

  • name
  • alphanumeric name
  • distance from Earth
  • distance from Sun
  • heliocentric XYZ coordinates
  • absolute magnitude
  • absolute magnitude bolometric
  • age
  • angular diameter from earth
  • angular radius from earth
  • apparent magnitude
  • BV color index
  • color
  • mean density
  • average diameter
  • effective temperature
  • escape velocity
  • gravitational constant mass product
  • gravity
  • lifetime entropy
  • luminosity
  • main sequence lifetime
  • mass
  • metallicity
  • rotational moment of inertia
  • object type
  • oblateness
  • obliquity
  • average radius
  • rotational angular momentum
  • rotation period
  • known satellites
  • shape
  • spectral class
  • stellar end state
  • star type
  • stationary orbit radius
  • stationary orbit speed
  • surface area
  • volume
  • maximum absolute magnitude
  • maximum apparent magnitude
  • minimum absolute magnitude
  • minimum apparent magnitude
  • variability period
  • variable star type
  • component
  • member of a multiple star system
  • system members
  • image
  • alternate names
  • Bayer name
  • Durchmusterung name
  • Flamsteed name
  • Gliese catalog designation
  • astrological symbol
  • HD catalog name
  • HD catalog number
  • Hipparcos name
  • Hipparcos number
  • HR catalog name
  • HR catalog number
  • SAO catalog name
  • SAO catalog number
  • Tycho number
  • variable star name
  • WDS identifier
  • 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
  • parallax
  • position angle
  • proper motion
  • proper motion declination
  • proper motion right ascension
  • radial velocity
  • right ascension
  • next rise
  • separation
  • next set
  • elongation from the Sun
  • next transit time
  • orbit center
  • + 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.


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.

Compute with Star data in the Wolfram Language