image thumbnail

Weather xls to TMY2

version (1.9 MB) by Muhammad Tauha Ali
This program converts data defined in a particular format in an excel file to TMY2 data format


Updated 24 Jun 2015

View License

The program converts measured data comprising of temperature, RH, GHI, DHI, DNI, wind speed and wind direction into TMY2 format. The TMY2 fields comprising of Illuminance components, atmospheric pressure, precipitable water and broad-band aerosol optical depth are modeled based on tested models available in open literature. Their references are provided in the m-file.
The zip file contains:
1. converter m-file
2. sample data excel files present in yearly and monthly folder
3. TMY2 output from the m-file for the yearly data

Details about TMY2 format can be found at:

The TMY2 data generated by the m-file can then be converted into .epw and .csv using energy plus weather utility and then to .bin using eQuest weather processor available at

I have tried to comment the m-file so that the user can understand and be able modify it.

Cite As

Muhammad Tauha Ali (2022). Weather xls to TMY2 (, MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2014b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!