Wolfram Knowledge about Galaxies in Microsoft Excel

Galaxy entities include the majority of galaxies from the Revised New General Catalogue and Index Catalogue, including members of the Messier Catalog.

A few example entities...

Milky Way
M31
IC 4548
IC 4912
NGC 4094
NGC 4109
NGC 4816
NGC 5507
NGC 5721
NGC 6597

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

name
apparent magnitude
blue band magnitude
average diameter
distance from Earth
distance from the Milky Way center
distance from Sun
galaxy type
gravitational constant mass product
heliocentric XYZ coordinates
Hubble type
object type
radial velocity
average radius
redshift
shape
surface brightness
visual band magnitude
wikipedia summary text
alphanumeric name
alternate names
IC number
NGC number
PGC number
image
altitude
next transit altitude
apparent altitude
azimuth
azimuth at rise
azimuth at set
above the horizon
constellation
daily time above horizon
declination
major axis
next maximum altitude time
minor axis
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.