TDS Correction Excel Import "Error converting data type varchar to numeric"

TDS Correction Excel Import "Error converting data type varchar to numeric"

TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric



















Possible Resolution


To solve this excel import issue, here are some suggestions are given below. 

1. In the Excel template, it is to be checked that the Section Code is selected from the drop-down (pre-specified in software template ) or not.



2. In the Excel template, it is to be checked that the Deductee Code is selected from the drop-down (company/non-company ) or not.




3.  In the Excel template, it is to be checked that the Challan Serial No. is selected from the drop-down or not.


4. Deductee name should not be greater than 75 characters.

5. Pan Number should not be greater than 10 characters and pan number should be as per pan number format.

6.Tds correction  Excel template should be TDS software only

Hope This Helps




    • Related Articles

    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...

    • 15G/15H - Data not importing through excel

      15G/15H - Data not importing through excel  When importing 15G/15H data from excel, the message of import succesfully comes but the data is not imported. Possible Solution : -  If the UIN number entered in the excel sheet is more than 10 digits, then ...

    • TDS > Error 13 - Type Mismatch

      Solution: This issue is related to particular Client's database or Conso file issue. To resolve this please follow the steps below: Step 1: Please re-import the consolidate file through Export/Import – Import from Text/FVU/TDS file option and import ...

    • Express TDS- Correction process for TDS return

      Express TDS- Correction process for TDS return Process for offline correction for 24Q, 26Q, 27Q & 27EQ from TDS software >> The Correction from TDS software can be processed once you have the Consolidate file (.tds File). Select Respective Deductor , ...

    • Profile || The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

      Error while click on Profile Button -- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. Solution -For this issue you are requested to change the Date format of the system. Process : Change Date Format ...