Learn how to create a task that reads a CSV file and quickly imports the contents and saves the output to an Excel file. Automation expert Richard Schoen gives a guided tutorial and explains the actions required to set up this task. In this video you’ll learn how to:
- Locate the CSV file to import
- Create a dataset object to hold the contents of the CSV file
- Use the loop action to show how the CSV dataset can be imported one line at a time for data validation or database lookups
Watch this chapter now to learn how to get started.