CSV formula safety and preserving leading zeros

CSV is text, not a typed workbook

A CSV value beginning with =, +, - or @ can be interpreted as a formula by spreadsheet software. Neatbo never executes it; the risk concerns what happens when you later open the file in another application.

Leave safety escaping enabled

Relevant exports prefix potentially active cells with an apostrophe by default. This intentionally changes the exported cell text to reduce formula interpretation. Only turn it off after reviewing the data and the receiving application.

Use XLSX when literal text matters

CSV-to-XLSX writes literal string cells, keeping values such as 00123 and =1+1 as text. The XLSX-to-CSV reader does not recalculate formulas and explains missing cached values.

Test the receiving spreadsheet, not only the export

Use fictional identifiers and harmless formula-like strings to test an import. Check the actual cell value as well as its display: a column can look correct while a leading zero, long identifier or date-like string has already been converted.

Safety escaping intentionally changes selected cell text. This is suitable for some spreadsheet handoffs but may be wrong for an API that expects exact values. Decide who will consume the file before choosing the export mode, and document that choice with the handoff.

id,note
00123,=1+1
00456,plain text

Before you finish

• Do not assume surrounding double quotes neutralize a formula.
• Review the destination application’s import settings.
• Check a long ID, a leading-zero ID and a formula-like cell.
• Retain the original data when a safety transformation changes text.