parse csv

This block is part of the files group and was last modified in core v15.0.2.

parse csv v10.3.11 Updated v15.0.2

Parse a CSV file into an array of objects.

In pins 6 + flow
  • flow
  • file file required

    File to parse as CSV.

  • separator value

    The separator used to split values on a row.

    Default ,

  • detect separator condition v11.5.13

    If set to true the action will try to detect the separator based on the first few lines. If it fails to do so it will fall back to the given or default separator

    Default false

  • Has headers condition

    Indicates if the CSV has headers or not, we will use the headers to create objects using these keys if true is given.

  • Custom headers array<value>

    Array of headers to be used in case has_headers is set to false.

  • trim values condition v15.0.2

    Remove whitespace and invisible characters from the start and end of every row value. Characters inside a value and the headers are left alone. Off by default: a value that a blueprint matches on will no longer equal what an earlier import stored untrimmed.

    Default false

Out pins 3 + flow
  • flow
  • array array
  • Headers array
  • error value

An uploaded file becomes rows: get takes the file from the form, parse CSV turns it into an array of objects, and filter by geo distance keeps only the rows whose location lies within their own radius of from city (here Breda). array length counts what survived.

Studio canvas example for the parse CSV block: upload, parse, filter by city.

Used in these guides

These documentation pages use or explain this block:

Version history

Introduced in v10.3.11.

Last modified in v15.0.2.

v11.5.13 This block or one of its pins was updated in v11.5.13, click here to see the release notes.
Back to files Return to the main group to view all sub-groups Back to file parsing Return to the group to view all blocks within this group