excel Auto generate tem's id from excel source for windows requirements Python 2.7 (install go here) libs: xlwt, xlrd (install via pip) install install python 2.7 from source copy auto_temp.py to C:\Python27\Scripts\ place auto_temp.bat wherever you want