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");