Automate Academy Tasks
Automate Desktop

CSV to Excel

Chapter 11 | Automate Tasks

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.

 
Still Have Questions?

Browse our Knowledge Base or Forum in the HelpSystems Community Portal.