Can a CSV treat a form response as a formula even though the file is plain text?
TechnologyWhile checking our equipment-request export, I used the harmless note “=2+2” as a sample response. Excel displayed 4 when I opened the CSV. A colleague had told me that a plain-text export meant every field would stay ordinary text.
OWASP describes CSV or formula injection when spreadsheet software interprets untrusted exported input as formulas. OWASP's CSV guidance
How should we handle the export so a person's note remains a note? I haven't asked anyone to use the real response file yet, and I don't want “it's only CSV” to substitute for checking the receiving application.