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.