Turns CSV- or TSV-formatted text into a table.
You can use this node to import data from a spreadsheet. In your spreadsheet application, export the data in CSV (Comma-Separated Values) or TSV (Tab-Separated Values) format. Use the Fetch Data node to get the content of the exported file and this node to convert it to a table.
Each line of the input text (except empty lines) becomes a row of the table. Within a line, each comma or tab marks the end of a column.
Spaces surrounding commas or tabs are ignored (unless enclosed in quotes).
If some rows have more columns than others, the output table has as many columns as the widest row. Columns that weren’t present for a row in the input text are populated with empty text in the output table.
If the text is formatted incorrectly, this node outputs an empty table. Check Console.app for details about the error.
Keywords: column, comma, convert, csv, grid, parse, read, row, separated, spreadsheet, structure, tab, tsv