- Documentation
- Activities
- Excel
- Read CSV
Import data from a comma-separated values file
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
File Path filePath | file | Required | — | — |
Delimiter delimiter | string | Optional | , | — |
Has Headers hasHeaders | boolean | Optional | true | — |
Encoding encoding | enum | Optional | utf8 | —utf8utf16asciilatin1 |
Output Variable outputVariable | variable | Optional | CsvData | — |
Output
CsvDataDataTableCSV data as table
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Read Excel
Get data from cells or ranges in a spreadsheet
Read Excel Cell
Read the value from a specific cell in an Excel worksheet, or the formula behind it
Read Password-Protected Excel
Open an Excel file that needs a password and read it into a table
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today