Excel export and Import Procedure

TDS || Excel export and Import Procedure

To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel.

The process below explains Data import and export through excel in TDS software.

Excel Export :
Exporting a Blank Excel Template:
  1. Go to the "Tools" section within the TDS software.
  2. Look for the option labeled "Download Excel Template" and click on it.
  3. A menu will appear where you need to select the appropriate form for which you want to export the data. Choose the relevant form and proceed.
      
  1. After selecting the form, the software will prompt you to specify the location where you want to save the Excel template. Navigate to your desired location and click on the "Save" button.

Exporting a Filled Excel Template:
  1. Navigate to the "Export/Import" section in the software.
  2. Look for the option labeled "Export in Excel" and click on it.
  3. Similar to exporting a blank template, select the appropriate form you want to export.
      
  1. Proceed to specify the location where you want to save the filled Excel template and click on the "Save" button.

Excel Import :
  1. First, ensure that you have filled in the necessary details within the Excel template you wish to import.
  2. Navigate to the "Export/Import" section within the TDS software.
  3. Look for the option labeled "Import From Excel" and click on it.
      
  1. You will be prompted to select the proper form for the data you are importing. Choose the relevant form.
  2. Next, you'll need to browse your computer to locate the Excel template file you wish to import. When browsing, you may be asked whether you're dealing with a new client code or an existing one. Select the appropriate option.
  3. Enter the Deductor Code as required by the software.
  4. Finally, proceed with the import process as guided by the software.
This detailed explanation should help users better understand and execute the import and export processes within the TDS software using Excel.

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

    • eXBace || Data import and export through excel

      To reduce complications of data entry In eXBace software, a facility has been provided where the user can import data through excel and can export data in excel. The User can also validate every sheet where the data is entered at the same time. The ...

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

    • TDS || Import Text or Consolidate(TDS) file

      The purpose of importing a text/Conso file is that all your old filed data gets into the software. You do not have to enter the master and transactions information of the Deductor and the Deductee again. To import the Text/TDS file into TDS software, ...

    • Excel Import Error "challan is not getting mapped"

      Excel Import Error "challan is not getting mapped" Possible Resolution To solve this excel import issue, here are some suggestions are given below. 1. All mandatory details should be filled in the "Challan Details" Sheet. * Challan number * Deposit ...