Formula-Safe CSV Export
Spreadsheet tools may interpret CSV values beginning with certain characters as formulas. That can be risky when a file came from a marketplace export, public form, customer list, CRM, payment report, or any source you do not fully control.
Values that need attention
| Original value | Formula-safe value | Reason |
|---|---|---|
=SUM(A1:A2) | '=SUM(A1:A2) | Prevents formula execution. |
+cmd | '+cmd | Keeps the value as text. |
@risk | '@risk | Avoids spreadsheet formula interpretation. |
-DANGER | '-DANGER | Text beginning with minus is protected. |
-42 | -42 | Negative numbers stay numeric. |
When to enable formula-safe export
- Before opening unknown CSV files in Excel or Google Sheets.
- Before cleaning exports that contain user-submitted names, notes, comments, or IDs.
- Before sharing a CSV with someone who will open it in a spreadsheet.
Formula-safe export is optional because some users need exact raw values. Turn it on when safety matters more than preserving the original first character exactly.
What the cleaner changes
When formula-safe export is enabled, text values that begin with risky spreadsheet characters receive a leading apostrophe in the exported CSV. The preview keeps the change visible so you can decide whether the safer export fits your workflow.
What to check after export
Open a small copy of the cleaned file first. Confirm that IDs, names, notes, and comments stayed as text, and that intentional negative numbers still behave like numbers where you expect calculations.
Create a formula-safe CSV