WORKED CASE · SYNTHETIC TEST DATA

Export two flat records with a quoted comma

A comma inside a value must stay in one CSV cell rather than create a new column.

Input and settings

[{"name":"Ada, Jr","age":30},{"name":"Bo","age":20}]

Run and interpret

Convert the sample with formula protection left on. The name containing a comma must be quoted; age remains the second column in both records.

Expected output

name,age
"Ada, Jr",30
Bo,20

Scope and possible misuse

Only flat records are supported. Null, missing and empty-string values can become indistinguishable empty cells. Formula protection changes risky strings intentionally; check them in your spreadsheet.

Unexpected result? Report a minimal example