Definition and Usage
This command imports data from a CSV file into a data table. It allows you to convert CSV file content into a structured data table that can be used for further processing in your RPA workflow.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
File path | Select the CSV file to import | File path string | Yes | Click the "Select file" button to browse for the CSV file |
Encoding | Select the encoding used by the CSV file | System default, Utf8, Ascii, Utf8WithBom, Unicode, GBK, GB2312 | Yes | Choose the appropriate encoding to ensure proper character interpretation |
Use custom delimiter | Check to enable the Delimiter field and specify your own separator | Boolean | No | When checked, allows you to specify a custom delimiter |
Delimiter | Enter a character or escape sequence to use as the field separator | Character or escape sequence | Required if "Use custom delimiter" is checked | Common values include comma, tab, or semicolon |
Use first row as headers | Check to use the first row of the sheet as data table column headers | Boolean | No | When checked, the first row will be treated as column names |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
Store data sheet into: Store the imported spreadsheet in a new variable. This creates a data table variable that contains all the imported CSV data.
Using Variables in Conditions
Parameters with the {x} icon indicate that you can insert variables created earlier in your workflow. This allows for dynamic file paths or delimiter values based on previous operations. When using variables, ensure that the variable type matches what the parameter expects (e.g., use string variables for file paths).
Notes
Before using this command, ensure that the CSV file exists at the specified location and is accessible.
The encoding selection is critical for files containing special characters or non-English text.
If "Use custom delimiter" is not checked, the system will attempt to automatically detect the delimiter (typically a comma).
When "Use first row as headers" is checked, the column names in your data table will match the values in the first row of your CSV file; otherwise, generic column names will be assigned.
Large CSV files may require additional processing time to import.