CyberSecBulletin

Improper Neutralization of Formula Elements in a CSV File

CWE-1236

The product saves user-provided information into a Comma-Separated Value (CSV) file, but it does not neutralize or incorrectly neutralizes special elements that could be interpreted as a command when the file is opened by a spreadsheet product.

We track 107 vulnerabilities of this type. 100% are rated high or critical, and the average CVSS score is 8.5.

How this weakness is prevented

  • Implementation: When generating CSV output, ensure that formula-sensitive metacharacters are effectively escaped or removed from all data before storage in the resultant CSV. Risky characters include '=' (equal), '+' (plus), '-' (minus), and '@' (at).
  • Implementation: If a field starts with a formula character, prepend it with a ' (single apostrophe), which prevents Excel from executing the formula.
  • Architecture and Design: Certain implementations of spreadsheet software might disallow formulas from executing if the file is untrusted, or if the file is not authored by the current user.

Latest Improper Neutralization of Formula Elements in a CSV File vulnerabilities