Overview
Introduction
When you specifically want each CSV record as its own machine-readable array, but don't want the header row mixed in with the data, this tool gives you exactly that shape.
It's a close sibling of CSV to Array of Arrays Converter, differing only in that the header row is deliberately left out.
What Is CSV Rows to Array Converter?
A data-rows-only JSON converter: every row beneath the header becomes its own JSON array of string cells, and all of those row-arrays are wrapped together in one outer array.
The header row itself never appears in the output.
How CSV Rows to Array Converter Works
The CSV is parsed with the shared grid parser and split into a header row and data rows. The header is discarded entirely, and the remaining `string[][]` of data rows is passed straight to JSON.stringify with indentation.
No reshaping happens beyond that split: each row keeps its original cell order and values.
When To Use CSV Rows to Array Converter
Use it when a script needs each CSV record as its own array but should never see the header row mixed in as if it were data.
It's a good fit for feeding rows one at a time into a processing function that expects `string[]` records.
Often used alongside CSV to Array of Arrays Converter and CSV Rows to List Converter.
Features
Advantages
- Cleanly separates header from data, so downstream code never mistakes the header row for a real record.
- Preserves each row's original cell order and values with no restructuring.
- Correctly handles RFC 4180 quoting from the shared CSV parser.
Limitations
- The header is discarded entirely, so column names aren't available anywhere in this output; use CSV to JSON Converter instead if you need header-keyed objects.
- All values stay strings, with no automatic type inference.
Examples
Best Practices & Notes
Best Practices
- Use CSV to Array of Arrays Converter instead if you want the header row included as the first array.
- Keep a separate note of the column order if you'll need to reconstruct header-keyed access later.
- Pair with Array of Arrays to CSV Converter (re-adding a header row) to round-trip this data back to CSV.
Developer Notes
This tool exists as a distinct sibling to CSV to Array of Arrays Converter specifically for callers who never want to accidentally treat the header row as a data record: a subtle bug class that's easy to introduce when a single 'grid including header' array is used both for iteration and for column lookup.
CSV Rows to Array Converter Use Cases
- Feeding CSV data rows one at a time into a processing function that expects plain string arrays
- Preparing a clean array of records with no risk of the header row being mistaken for data
- Building a nested JSON array for a script that only needs positional cell access, not column names
Common Mistakes
- Expecting the header row to appear at the start of the output; it's always excluded here.
- Assuming values are type-converted to numbers or booleans; every cell stays a string.
Tips
- If you need the header included as data, use CSV to Array of Arrays Converter instead.
- Keep track of column order separately if later code needs to map an index back to a column name.