← Back to Tools

Degrees Spreadsheet

Bulk-calculate planetary positions in Tropical and/or Sidereal degrees for any set of birth data. Ideal for astrological research, dataset preparation, and machine learning projects.

How to use

  1. Download the spreadsheet template from the tool below.
  2. Fill in birth dates, times, and places — one person per row. No commas. Save the file.
  3. Upload the saved file.
  4. Within seconds, you'll receive a download link with all calculated values.

Included by default: Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Uranus, Neptune, Pluto, Rahu (north node), Chiron, Ascendant, Midheaven, Lahiri ayanamsha. Additional asteroids (Pallas, Ceres, Juno, etc.) can be added.

To get Sidereal placements: subtract the ayanamsha column from the other columns.
Whole sign house: 1 + Floor[x/30]  ·  Degrees in sign: Mod[x, 30]

Combine the raw positional data with machine learning for a powerful combination. Retrograde status and additional point types may be added in future updates — let Renay know if that would be useful to you.