A customer note belongs in a report as text. When an exported CSV is opened in a spreadsheet, however, a value beginning with a formula marker may be interpreted as a calculation. An export can therefore change the meaning of data that looked harmless in the business application.

Find the exports that include customer-entered text

Review reports that include names, addresses, support notes or supplier references entered outside the organisation. Follow each value from its original form through any integration and into the final spreadsheet. Ask which applications staff use to open the file and whether they save and reopen it. The risk depends on how the spreadsheet interprets the exported cells. OWASP describes this behaviour in its CSV injection guidance.

Define what the receiving application should treat as text

Have the developer review formula-triggering prefixes, separators, quotes and control characters in untrusted fields. Ordinary CSV quoting handles the file structure. A spreadsheet may still interpret a quoted cell as a formula. Use an export policy tested against the spreadsheet applications staff actually use. For a workbook export, explicitly writing untrusted cells as text can be part of that design, with the spreadsheet library configured to avoid converting those values into formulas.

Keep legitimate amounts and identifiers usable. An international phone number can start with a plus sign, while a negative amount has a minus sign. The export needs a rule for each field’s intended type. Keep the source record intact and apply any display protection at the export boundary. For identifier formatting, see the leading-zero CSV guide.

Test the file through the staff workflow

  1. Use an isolated test dataset with a harmless expression such as =1+1 in a note field. Check whether it appears literally or calculates after export.
  2. Add a legitimate phone prefix, negative amount, leading-zero code, quote and line break. Confirm that each column retains its intended meaning.
  3. Open the file using each supported application, then save and reopen it. Inspect the raw export as well as the visible cells.

ITZ’s software maintenance service can review the export boundary and reporting libraries. Describe the report and the spreadsheet applications your staff use.

Review your spreadsheet export safety

Bring a redacted export, the source field definitions and a list of supported spreadsheet tools. Review Your Spreadsheet Export Safety