Download TDS Justification Report Excel Generation Utility v2.0

Recently TRACES has updated Justification Report text file format and also Excel Generation Utility (v2.0) also to convert the same into readable Excel format. To Download the v2.0 Utility Click here.

Steps to Downlaod the Justification report and convert the Justification Report text file into excel:

• Loging to https://www.tdscpc.gov.in from your User id and password.

• Then Download the zip file from 'Requested Downloads' screen and save to your Computer or Laptop.

• Unzip the file using Winzip. Password to unzip is 'JR_<TAN>_<Form Type>_<Quarter>_<FY>', e.g., JR_DELAA1235A_24Q_Q3_2012-13. This will save the Justification Report as a text file.

• Download the macro utility for Justification Report from the above mentinoed link.

• Double-click the utility, excel sheet will open

• Click on 'Enable Content' in the warning message to enable macros

• Select the Justification Report text file and the folder to save the output excel file and click on button 'Generate TDS CPC Justification Report'

• The text file will be converted into excel spreadsheet and saved in the selected folder

• Open the Justification Report excel file from the folder in which it has been saved