← 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.

    ↓ template_for_entry.csv

  2. Fill in birth dates, times, and places — one person per row. No commas. Save the file.
  3. Upload the saved file to the tool below.
  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.