This site requires JavaScript to be enabled

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

RPA: Using TDS to process mass data proviced in Excel

A lot of RPA use cases start with data stored in excel. TDS can be used to provide a scalable way to process excel data. 

Note: This is a variant of - the code is extended to support unattended use


RPA (Robotic Process Automation) is very useful to replace repetitive and tedious manual tasks like processing data provided in an excel sheet. A lot of times users are asked to run through hundreds of rows to enter e.g. data in an internal system.

Of course it can be done using the excel automation capabilities - however using TDS allows for more scalable and robust implementation of bots.

Note: The proposed solution can of course also be used to upload test data as part of the test execution


The attached Excel WorkBook "BulkExcel" contains a parameter worksheet which is used to parameterize the actual upload macro. This macro is an improved version of the original macro provided in

Note: The order of the parameter matters – there is no "intelligence" retrieval implemented yet.

You can still run the upload by clicking the button "Load Excel to TDS" but it also possible to use the SET "Run Excel Macro" to upload any excel sheet to TDS.

First of course you need open the Bulk Upload file and define the parameter range:

In the next step we will set the parameters:

For the sample I will always clean up the data category – in a real live scenario you would normally add data.

The parameter "Add Status Field" will automatically add a TDS attribute data_state to each record. This can be later used for processing purpose.

Finnally I am using "Run Excel Macro" to trigger the actual upload – the macro is called "Upload". At the end of course, I close the workbook.

Running this macro with an excel sheet containing 100 records results in a prepared TDS:



1 0

Marina Urosevic

Created: 2019-12-26 12:22:12

Thank you for clearly provided informations, this really help me to import Excel File in TDS. 

In attachemnts you have macros with comments in code, it's only important to adjust code where needed. 

0 0

Shahar Shiff

Created: 2020-01-23 22:25:37 , Updates: 1, Last Update: 2020-01-23 22:32:55

Note that depending on your setup you might need to update the server address in cell B4 (i.e. my TDS and Tosca Server are using port 90 and not 81). 


0 0

Pradeep Chauhan

Created: 2020-03-24 06:35:53 , Updates: 2, Last Update: 2020-03-24 06:38:46

With ref. to 4th snap shot fom top: Why is the Workbook Name given as BulkUpload ? The name does not match with your attachment I guess.


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial