I’m trying to create a robot that will take a text file, input the data into an Excel template, filter data, then output the filtered data to a new text file.
I know I need to start with building a data table. The data is in a text file, separated by commas. It will need to go into column A and B in the Excel template.
Could someone assist with building this data table and getting the data to Excel?
I tried to upload a sample of my data in the text file, but I’m unable to since I’m a new user.