Wolfram Computation Meets Knowledge

Wolfram Knowledge about Nebulae in Microsoft Excel

Nebula entities include the majority of nebulae from the Revised New General Catalogue and Index Catalogue, as well as members of the Messier Catalog.

A few example entities...

IC 1396B
IC 143
IC 1851
IC 2003
NGC 2086
IC 2605
IC 3551
IC 3668
IC 424
NGC 1736
NGC 1788
NGC 1970
NGC 2040
NGC 2246
NGC 2452
NGC 2899
NGC 2905
NGC 3181
NGC 4399
NGC 5447
NGC 5844
NGC 604
NGC 6072
NGC 6445
NGC 6537
NGC 6772
NGC 6886
NGC 7662

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

  • name
  • apparent magnitude
  • blue band magnitude
  • average diameter
  • distance from Earth
  • distance from Sun
  • heliocentric XYZ coordinates
  • object type
  • radial velocity
  • average radius
  • redshift
  • visual band magnitude
  • wikipedia summary text
  • alphanumeric name
  • alternate names
  • IC number
  • NGC number
  • image
  • 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
  • position angle
  • right ascension
  • next rise
  • next set
  • next transit time
  • + 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 Nebula data in the Wolfram Language