Add to Favourites

Exclude Rows in Excel for Importing Data into TallyPrime

You can specify the conditions based on which data from one or more rows should be excluded while importing the data. Let’s say you have entered transaction details with parties in an Excel worksheet in the following manner:

Now, let’s say you want to exclude rows that contain the entries for Sunday. 

In the Mapping Template Creation screen,

1. Set the option Exclude Rows in Excel to Yes.
   In case you do not see this option, press F12 (Configure) > set the option Exclude rows in Excel while importing Data as Yes. 
2. Select the Column Header where the data in the row is to be excluded. 
3. Select the Condition from the List of Conditions.
4. Enter the value based on which you want to exclude the row while importing.
   The screen for setting the Conditions for Excluding Rows appears, as shown below:
   
5. Accept the screen and proceed with the importing your transactions into TallyPrime.

You can select more than one Column Header or more conditions for the same Column Header for excluding rows in the Excel worksheet. 

By using this option, you can easily set conditions to filter out unwanted data during the import process. Whether you need to exclude rows based on dates, specific values, or other criteria, TallyPrime empowers you to tailor your data for importing.