Skip to main content

CSV line reader

Read a CSV file line by line. Each line is emitted as one object whose keys are the spreadsheet column letters (A, B, C…), in file order. For example:

A CSV file
header1,header2,header3
data1A,data1B,data1C
data2A,data2B,data2C
data3A,data3B,data3C
Reader configuration
Delimiter: ,
Start line: 2

// First emitted row:
// { "A": "data1A", "B": "data1B", "C": "data1C" }

The reader never consumes a header row by itself: line 1 is emitted like any other line. To skip a header row, set Start line to 2.

Files that are not valid UTF-8 are decoded through a fallback chain of legacy encodings (Windows-1252, ISO-8859-15, ISO-8859-2, Windows-1250).

Parameters​

Delimiter

The delimiter used in the CSV file (for example: ;). Optional; the default is ,. It must be exactly one character — a value of any other length is silently ignored and the default is used instead.

Start linerequired

The line number to start reading from, counted from 1. Both 0 and 1 read the whole file; 2 skips the first line (typically the header row).

Output​

CSV Row

The current row being read from the CSV file, as an object keyed by column letter (A, B, C…) with each cell as text.