How does the CSV injection checker inspect formulas?
It parses commas, semicolons or tabs, including correctly quoted and multiline cells. Known formula prefixes, control characters and normalized Unicode variants are assessed. Legitimate calculations can also be flagged.
How to use the check
- Choose the CSV before opening it in a spreadsheet application.
- Review formula findings and the detected separator. Preview shows at most 40 rows.
- If complete export is available, save the .clean.csv and import it deliberately as text in the destination application. Also test save and reopen before production use.
Exact limits
CSV input is limited to 4,000,000 UTF-8 bytes and characters, and 500,000 cells. The fully quoted export must also fit the output budget. Errors or budget violations block export rather than producing a partial CSV. An apostrophe before detected formula prefixes is not universal protection in Excel, LibreOffice or after saving again.
Reproducible synthetic example
The cell =1+1 triggers csv.formula. It contains only harmless arithmetic, but it is still a formula prefix that a spreadsheet may interpret.
The findings come from an actual local scan of this test file. Download it and choose it in the scanner. No real personal data or malware.
Download test file: formula-demo.csvExample inspection coverage: complete.
Interpret the result
Risk and inspection coverage are separate statements. complete means analyzed within the defined inspection scope. Green does not establish the absence of malware. partial, unavailable or failed mean inspection is limited, unsupported or unsuccessful.
- CSV formula injection: detect formulas and import deliberately
- Inspection method and next steps
- More guides
Responsible operator: Tom Silas Helmke, operator of ScanBeforeOpen. Content revised: .