For the security and integrity of your data, some values are automatically prefixed with a single or double quotation mark when exported if they contain certain special characters. This prevents spreadsheet applications such as Microsoft Excel from interpreting the values as formulas. The following characters will trigger this sanitisation.
The following characters will trigger this sanitisation.
Special character name | Special character |
Equals to | = |
Plus | + |
Minus | - |
At | @ |
Tab | 0x09 |
Carriage return | 0x0D |
Comma | , |
This change aligns with security recommendations from the Open Web Application Security Project (OWASP).
For more information, see: https://owasp.org/www-community/attacks/CSV_Injection
Further manual formatting in Excel may be required to remove the appended quotation marks if they are not required.
