Example of transferring data from CSV file to Excel worksheet
In this example, you build a bot to update the product inventory in an Excel worksheet with new product names from a CSV file. Use actions from the CSV/TXT, Excel advanced, IF/ELSE, and Loop packages.
Prerequisites
Before you start building the bot, create the following data sets on your desktop in the specified file formats:
Data set 1: ProductInventory.xlsx
Item number | Name | Count | Category | Unit price | Taxable |
---|---|---|---|---|---|
A0001 | Milk | 15 | Grocery | 3 | N |
A0002 | Eggs | 6 | Grocery | 4 | N |
A0003 | Flower | 3 | Garden | 10 | Y |
A0004 | Table | 1 | Home | 50 | Y |
A0005 | Towel | 4 | Home | 10 | Y |
A0006 | Dog Food | 16 | Pet | 22 | N |
A0007 | Paint | 43 | Home | 12 | Y |
Data set 2: NewProductNames.csv
Item number | Name |
---|---|
A0005 | Hand Towel |
A0002 | Chicken Eggs |
A0003 | Sunflower |
A0004 | Coffee Table |
A0006 | Dog Food - Small Dogs |
A0007 | Paint - Dark Blue |
A0001 | 2% Milk |