Parse CSV


The 'Parse CSV' action parses the contents of a CSV file and returns it as JSON data.

Example Flow

Please refer to the following article showcasing the 'Parse CSV' Power Automate action: Parse a CSV File and Add Content to a SharePoint List

Default Parameters

The default 'Parse CSV' flow action parameters are detailed below:

  • File Content: A Base64 encoded representation of the CSV document

Advanced Parameters

The advanced 'Parse CSV' flow action parameters are detailed below:

  • Delimiter: Override the character used to delimit the CSV file. The default value is a comma.  For a tab delimiter enter \t
  • Column Headers: Optional - Manually override the columns headers for the CSV file as a comma-separated string e.g. Col1, Col2, Col3. Column headers will be automatically determined if a value is not provided.
  • Skip First Line: If 'Yes', the first line of data is pulled from the 2nd line.

Return Parameters

The 'Parse CSV' flow action returns the following data. 

Action Specific Return Values

  • CSV Data - The contents of CSV file parsed as JSON.

Standard Return Values

  • Filename - The filename provided
  • FileContent - A base64 string representation of the archive (.zip) file
  • OperationId - The unique ID assigned to this operation
  • HttpStatusCode - The HTTP Status code for the response
  • HttpStatusMessage - The HTTP Status message for the response
  • Errors - An array of error messages should an error occur
  • Operation Status - Indicates whether the operation has been completed, has been queued or has failed


Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk