What separator is used between a row's cells by default?

A single space by default, but the separator is configurable, so you can join cells with a different character like a pipe or a dash instead.

Is the header row included as a list item?

No, only the data rows are flattened; the header row is excluded from the output.

How is this different from CSV Rows to Array Converter?

This tool joins each row's cells into a single plain-text line with your chosen separator. CSV Rows to Array Converter instead keeps each row as its own JSON array, without merging cells together.

What happens to cells that themselves contain the separator character?

They're joined in as-is, without escaping, since the output is plain text rather than a re-delimited format; choose a separator unlikely to appear inside your data if that matters.

CSV Rows to List Converter

Overview

Introduction

Some tools and scripts expect one flattened line of text per record rather than a structured table. This tool takes every CSV data row and joins its cells into a single line, one line per row.

The separator between a row's cells is configurable, so you can match whatever downstream format you need.

What Is CSV Rows to List Converter?

A row-flattening converter: every data row's cells are joined together with a chosen separator (a single space by default) into one line of plain text, and the resulting lines are stacked one per row.

The header row is excluded, since the output reads as a plain list of records rather than a table with column labels.

How CSV Rows to List Converter Works

The CSV is parsed with the shared grid parser and split into a header row and data rows. The header is discarded, and each remaining row's cells are joined with the chosen separator using Array.prototype.join.

The resulting lines are stacked, one per original data row, in their original order.

When To Use CSV Rows to List Converter

Use it when a downstream tool expects space- or delimiter-joined lines of text rather than a structured table.

It's also a quick way to turn tabular data into something readable as a simple list.

Often used alongside CSV Rows to Array Converter and CSV Columns to List Converter.

Features

Advantages

The separator between a row's cells is configurable, adapting the output to whatever format you need next.
Preserves row order exactly, one output line per source data row.
Simple, predictable flattening with no quoting or escaping to reason about.

Limitations

There's no escaping if a cell's own content contains the chosen separator; cells are joined as-is.
The header row is always excluded, so column labels are lost in the flattened output.

Examples

Flattening rows with a space separator

Input

id,name,active
1,Ada,true
2,Alan,false

Output

1 Ada true
2 Alan false

Each data row's three cells are joined with a single space, producing one flattened line per row; the header is excluded.

Best Practices & Notes

Best Practices

Choose a separator that's unlikely to appear inside your actual cell values, to keep the flattened lines unambiguous.
Use CSV Rows to Array Converter instead if you need each row to stay a distinct, machine-readable JSON array.
Check for cells containing the chosen separator character beforehand if downstream parsing needs to split the line back apart reliably.

Developer Notes

Joining uses the native Array.prototype.join(separator) directly on each row's cell array, with no attempt at re-escaping, since the intended output is a human-readable flattened line rather than a re-parseable delimited format.