Wolfram Computation Meets Knowledge

Wolfram Knowledge about Pulsars in Microsoft Excel

Pulsar entities include a large collection of supernovae from the ATNF Pulsar Catalogue.

A few example entities...

Crab Pulsar
PSR J0056+4756
PSR J0358+5413
PSR J0751+1807
PSR J0946+0951
PSR J1320-3512
PSR J1730-2304
PSR J2015+2524
PSR J2019+2425

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

  • name
  • alphanumeric name
  • discovery year
  • object type
  • pulsar type
  • surveys
  • wikipedia summary text
  • alternate names
  • distance from Earth
  • distance from Sun
  • heliocentric XYZ coordinates
  • parallax
  • proper motion
  • proper motion declination
  • proper motion right ascension
  • transverse velocity
  • rotation period derivative
  • barycentric rotation frequency
  • barycentric rotation frequency derivative
  • barycentric rotation frequency second derivative
  • corrected period derivative
  • equatorial angular velocity
  • equatorial frequency
  • glitch count
  • rotation measure
  • rotation period
  • spin down age
  • spin down age corrected for proper motion
  • spin down energy loss rate
  • dispersion measure
  • dispersion measure derivative
  • dispersion measure times sin(b)
  • energy flux measured at Earth
  • magnetic field at light cylinder
  • mean flux density at 400 MHz
  • mean flux density at 1400 MHz
  • measured spectral index
  • pulse width at 50% peak
  • pulse width at 10% peak
  • radio luminosity at 400 MHz
  • radio luminosity at 1400 MHz
  • surface magnetic flux density corrected for proper motion
  • surface magnetic flux density
  • temporal broadening
  • binary period
  • orbital eccentricity
  • eccentricity times cos(periastron longitude)
  • eccentricity times sin(periastron longitude)
  • median companion mass
  • minimum companion mass
  • periastron longitude
  • projected semimajor axis
  • 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
  • right ascension
  • next rise
  • next set
  • elongation from the Sun
  • 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 Pulsar data in the Wolfram Language