CSV

Read and Write to CSV files.
​ Read File
Import columns from a CSV as WayScript variables.
​ Select or Upload CSV
CSV files on your account will appear as options. Use the 'Upload File' button to add a new file.
​ Create Variables
Once a file is selected to read, a table with the file's contents will appear in the Outputs section.
​ Ignore Headers
Specify whether or not to ignore the first line of the file when assigning variables.
​ Assigning Variables
Naming a column in the table creates a List variable with that name containing all entries in that column.
Note that first row is ignored in creating variables
​ Write File
​ Select File
Use the file dropdown to select an existing file on your account or create a new one.
​ Include Headers
If checked, the variable name will be written as the first row of each column.
​ Write Mode
Add to File: Every time the program runs, new rows of data will be added to the bottom of the CSV file.
Replace File: Every time the program runs, the file will be cleared before writing new data.
Headers will only be written when the file is blank.
If 'Include Headers' is selected, changing a variable name when adding to an existing and non-empty file will not replace the header row.
​ Adding Variables
Each time the CSV Module executes in Write Mode, one row of data is added.
To write each entry of list to a new row, use a Loop.
​ Preview
As variables are added and removed, the Outputs section displays a preview of what will be written.