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

    • TDS || Excel Import → Import of already in progress

      Root Cause of the Error → This issue occurs when Excel is importing data and encounters a malfunction, causing it to get stuck midway through the process. Solution → To resolve the error, click the "Clear Excel Import Flag" button. After that, click ...

    • TDS || Excel export issue → MACRO Enabled Process

      Unblock a single file → In most cases, you can unblock macros by modifying the properties of the file as follows: Open Windows File Explorer and navigate to the folder "C:\Program Files (x86)\K.D.K. Software\Spectrum\Zen TDS\e-TDStcsfvu". Right-click ...

    • TDS || Deductee/Employee Master → Import from Excel

      To import the Deductee/Employee Master through an Excel sheet, follow these steps: Download the "Deductee/Employee Master Excel Template": Navigate to "Master" → "Deductee/Employee Master". In the "Excel Import" dropdown menu, click on "Template ...