Option escape_formulas

Escape values that start with =, +, -, @, \t, or \r with ' and defend against CSV injection attacks.

• Type: Boolean
• Optional
• Default: false
• Since: 6.3.0
• Related: quote, escape — see Available Options

Example

In the escape formulas example, every field wich starts with the values = and @ is escaped by prefixing its value with '.

import { stringify } from 'csv-stringify/sync';
import assert from 'node:assert';

const records = stringify([
  ['=1', '@2', '3'],
  ['=4', '@5', '6']
], {escape_formulas: true});

assert.equal(records, "'=1,'@2,3\n'=4,'@5,6\n");