Spectral Calculator Spreadsheets

I have created three Excel spreadsheets that perform various spectral calculations on your data. Each spreadsheet is designed for different sample intervals across the visible spectrum: 5 nm, 10 nm and 20 nm. You should use the spreadsheet that corresponds to the measuring interval of your spectrophotometer.

The spreadsheets cover the range of 340 nm to 830 nm. You simply paste your spectral data into the proper rows, leaving unused rows at zero. The spectral results are instantly calculated and displayed. You may also paste in a custom illuminant, if you wish. The spreadsheet provides values resulting from all combinations of:

Standard Observers Reference Illuminants Colorimetry Density Working Space RGB
  • 10°
  • A
  • B
  • C
  • D (any temperature)
  • E
  • Blackbody radiator (any temperature)
  • User defined
  • XYZ
  • xyY
  • Lab
  • LCHab
  • Luv
  • LCHuv
  • Status A
  • Status E
  • Status M
  • Status T
  • Visual
  • Type 1
  • Type 2
  • Adobe RGB (1998)
  • Apple RGB
  • Best RGB
  • Beta RGB
  • Bruce RGB
  • ColorMatch RGB
  • Don RGB 4
  • ECI RGB v2
  • Ekta Space PS5 RGB
  • ProPhoto RGB
  • sRGB
  • Wide gamut RGB

Place values into the yellow cells. Calculated results are displayed in the blue cells.

Note: For emissive measurements (e.g. from a monitor), the values corresponding to Illuminant E should be used.


Sample Interval ZIP Format
5 nm Download
10 nm Download
20 nm Download