Automating the Task of Transferring Data from Spreadsheet to Database using Robotic Process Automation

Abstract

In today's world, the emergence of repetitive tasks becomes common in all the fields of business. Repetitive tasks like sorting emails, group emailing, recording entries, etc. has become common in business. Robotic Process Automation (RPA) helps you to perform these repetitive tasks in an easy manner and also saves lot of money and time. It reduces the involvement of programming in solving such tasks. In handling large amount of data Spreadsheet plays an important role in storing the data. But in order to process or query the data in spreadsheet, it's a tedious task. There is a requirement to transfer the data available in spreadsheet into any database like MS Access in order to query the data in the required formats. RPA plays a major role in executing such tasks in a simple and efficient manner. This paper throws a light on the steps in transferring the values from a spreadsheet sheet to a database table through the use of Automation Anywhere cloud. Bots are created to automate such a task. There is no necessity of programming language knowledge to create bots.