Using the Open action for CSV/TXT file
- Updated: 2025/07/15
The Open action lets you choose the delimiter that you must use in the file, remove the spaces from the file, and set the correct encoding for the file.
Note:
- If a double quotation mark (") is the last element of the last line of the CSV/TXT file, the bot encounters an error during runtime.
- When you use the action to open a CSV file, read it, and assign it to a table, then write it to a file using the action, the automation interprets any commas in the header or cell data as delimiters. For instance, if three consecutive cells contain data like "abc", "bcd", "efd", the final output will enclose each in triple double quotes, resulting in """abc""", """bcd""", """efd""".
Procedure
Next steps
Use the Read action to retrieve the data from CSV/TXT file and assign them to a table variable. You can use the loop action to retrieve each row of data from the file or table variable and assign them to the record variable for further operations.