You can substitute the absorbance data in the excel file which contains conversion function already and correspondingly you will get the the data of tauc plot in other two columns. if you have already got then it is fine otherwise i can provide you if you needs.just intimate me
Tauc used an equation in 1968 to calculate the absorption edges (bandgaps) of amorphous Ge and Si from their absorption data.
(αhν)γ=A(hν-Eg)
In this equation, α is the absorption coefficient, h is Planck’s constant, υ is the frequency of the incident photon, A is a proportionality constant (which is determined by the index of refraction, electron, and hole effective masses; however, it is usually taken as 1 for amorphous materials), and Eg is the bandgap energy. The important term is the exponent γ, which denotes the nature of the electronic transition, that is, when γ=2 it is a direct allowed transition, and when it is equal to 1/2, it is an indirect allowed transition. For γ=2/3 it is a direct forbidden transition, and for γ=1/3 an indirect forbidden transition. Typically, the allowed transitions dominate the basic absorption processes, giving either direct or indirect transitions.
Thus, the basic procedure for a Tauc analysis is to acquire optical absorbance data for a sample in question that spans a range of energies from below the bandgap transition to above it.
Plotting the (αhν)γ versus (hν) is a matter of testing γ=2 or γ=1/2 to compare which provides the better fit and thus identifies the correct transition type.
I have provided the Template file (Origin file) in the video description. Thanks