Skip to main content

Quotation marks added to values when exporting data to Excel

Understand why quotation marks may be included in some values when exporting data to Excel and which characters trigger this behaviour.

H
Written by Harry Ledger
Updated over a week ago

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).

Further manual formatting in Excel may be required to remove the appended quotation marks if they are not required.

Did this answer your question?