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

    • TDS || Correction → Excel export and Import Procedure

      The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...

    • 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 ...

    • ZenTds || Offline Correction process for TDS return

      Process for offline correction for 24Q, 26Q, 27Q & 27EQ from TDS software: The correction from the TDS software can be processed once you have the consolidated file (.tds file). How to request and download the consolidated file through the software: ...

    • Zen IT || Excel Import → Type Mismatch, Error in excel import

      Root Cause of the Error: The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file. Solution → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...

    • 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 ...