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 cell or a cell range (Rate at which tax deducted (423) )
On the Home tab, select Number from the drop-down.
Right-click the cell or cell range, select Format Cells… , and select Number.
Hope This Helps