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

    • ExpressTDS || Download TDS Return Data in Excel

      Steps to Download TDS Return Data in Excel Format via ExpressTDS You can download TDS return data for both regular and correction returns in Excel format. Ensure transactions have been created in the return before proceeding. Here’s how: Download TDS ...

    • Correction Return → Excel Import Procedure (Steps to Avoid Errors)

      When importing a correction return Excel file, errors may arise due to incorrect or missing data. Follow these steps to correct and import the file accurately: Step-by-Step Guide for Correcting and Importing the Excel File Step 1: Import the Latest ...

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