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,20Scope 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.