TDS filing made simple!

  • Expert assisted help
  • Rated premium services
  • Dedicated Relationship manager
Get Started

Get Expert Assistance

Thank You for sharing your details. Our experts will get in touch with you shortly

How to import data from Excel into ClearTDS e-TDS software?

Updated on: Oct 12th, 2021


4 min read

social iconssocial iconssocial iconssocial icons

Are you looking for preparing TDS return within a short time? ClearTDS can save your time and avoid typing mistakes. You can just copy your data into our Excel Template. You can add the deductees and challans by uploading this filled Excel Template. Here are the steps to upload Data by using Excel template into ClearTDS.

Step 1: Login to ClearTDS. Choose your deductor and click on “Import from Excel”.

today 8

Step 2: Select Form Type, Financial year and Quarter to which you want to import your data and click on Done then there is Excel Template with the name of “Tax deductions”, now you can download the template with one click on “Download”.

Excel Template of “Tax deductions (Annexure I)” contains 3 parts:

A. Deductees details:

  1. PAN of the deductee
  2. Deductee Name
  3. Deductee reference No. (optional)

B. Deduction details :

  1. Section Code
  2. Total Amount credited/paid
  3. Date of credit and date of deduction                                          
  4. Amount of TDS, Surcharge, and Cess.  

C. Challan details: 

  1. Challan No.
  2. BSR Code
  3. Challan deposit date
  4. TDS amount, Interest and Late filing fee.
today 9

Step 3: Once you fill “Excel Template”, you can upload with the option of “Choose file”. After data is imported successfully, you can see the data by clicking on “View Imported details”.

ClearTDS upload excel
today 9

That’s it! You have added the data into ClearTDS and you can file the TDS return. To validate and prepare the return you can read this guide There is aguide, it helps you.

inline CTA
File your returns in just 3 minutes
100% pre-fill. No manual data entry

Clear offers taxation & financial solutions to individuals, businesses, organizations & chartered accountants in India. Clear serves 1.5+ Million happy customers, 20000+ CAs & tax experts & 10000+ businesses across India.

Efiling Income Tax Returns(ITR) is made easy with Clear platform. Just upload your form 16, claim your deductions and get your acknowledgment number online. You can efile income tax return on your income from salary, house property, capital gains, business & profession and income from other sources. Further you can also file TDS returns, generate Form-16, use our Tax Calculator software, claim HRA, check refund status and generate rent receipts for Income Tax Filing.

CAs, experts and businesses can get GST ready with Clear GST software & certification course. Our GST Software helps CAs, tax experts & business to manage returns & invoices in an easy manner. Our Goods & Services Tax course includes tutorial videos, guides and expert assistance to help you in mastering Goods and Services Tax. Clear can also help you in getting your business registered for Goods & Services Tax Law.

Save taxes with Clear by investing in tax saving mutual funds (ELSS) online. Our experts suggest the best funds and you can get high returns by investing directly or through SIP. Download Black by ClearTax App to file returns from your mobile phone.

Cleartax is a product by Defmacro Software Pvt. Ltd.

Company PolicyTerms of use


ISO 27001

Data Center


SSL Certified Site

128-bit encryption