CSV formula injection: check data with KrobClick before sharing

CSV files containing product names and customer messages may look like ordinary data, but spreadsheet applications can interpret some text as formulas. This guide helps inspect and reduce that risk, separately from corrupted Thai text.

A shield and magnifier inspect table fields, representing CSV checks before sharing

CSV is text, but spreadsheet programs may interpret some values as formulas

CSV (Comma-Separated Values) is a text data format separated into fields. When opened with a table program like Excel, values that start with certain characters, such as =, +, - or @ may be interpreted as a formula rather than the text intended by the file creator. This risk is called CSV Formula Injection (OWASP)

A harmless example: if the Notes column contains text =1+1 Some spreadsheet programs may display it as 2 instead of the original text. The risk comes from treating untrusted information as instructions, even though this calculation example is harmless.

Which CSV values can be read as formulas?

Do not assume every negative value is an attack, for example -10 may be an ordinary amount. Inspection requires knowing whether the cell should be text or a number and what the destination does with it.

Use KrobClick CSV Editor to inspect and export carefully

  1. Open KrobClick CSV Editor to open CSV/TSV as a table in the browser
  2. Choose a file or paste CSV, then inspect the preview, especially third-party columns
  3. Check text that begins with formula characters and make sure that the delimiter doesn't cause the data to switch fields.
  4. Open Settings → Download files and choose “Prefix values that may be read as formulas with an apostrophe.” This changes exported text without changing displayed table values.
  5. Download a new copy and open it in the application the recipient actually uses. Check that values remain data and columns stay aligned.

The tool stores values as text and does not evaluate formulas. Processing stays on-device. If remembering is enabled, tables and settings are saved in this browser profile, so take care on shared devices. Verify exported files in Excel separately from the website table.

This option adds apostrophes to detected values, including: -10 which may already be valid numbers. Displayed table values stay unchanged, but downloaded text changes; recipients doing further calculations must know this.

The current check covers the characters =, +, - and @ after whitespace, including tabs or newlines at the start of a value, but does not yet check full-width symbols such as = and @ , which OWASP notes may trigger formulas in some environments. The tool’s warning is not a comprehensive security scan.

Why checks are still needed after adding an apostrophe

OWASP cautions that there is no single method of protecting against CSV Formula Injection that is guaranteed to work for every program and workflow. Especially when files are opened, saved, and re-opened in Excel, adding apostrophes is a way to reduce risk in some cases. It is not a guarantee of safety throughout the cycle (OWASP WSTG)

If the receiving system processes CSV automatically, a prefixed character may change the data value. Agree on the format with the recipient and test the entire import process. Check the source’s trustworthiness as well, even after modifying the file before sending it.

A more secure CSV forwarding process

Keep source files separate from viewing copies. Inspect unfamiliar data before export, use a program that can set columns as text when needed, and tell recipients the file is data rather than a document intended to execute formulas. Avoid unnecessary publication or sharing of personal data.

If Thai characters are corrupted or leading zeros disappear, read Import CSV into Excel while checking encoding and data types . Encoding and data-type fixes do not remove the need to check formula risks separately.

Open toolCSV editorCheck for values that might be interpreted as formulas before forwarding the file.

Sources

OWASP documentation and CSV Editor code reviewed October 16, 2026. No Excel version was tested for open/save/reopen behavior. Apostrophes alter exported data and do not guarantee protection in every program.