Description
CSV Injection, also known as Formula Injection, occurs when websites embed untrusted input inside CSV files. When a spreadsheet program opens a CSV, any cell starting with = is interpreted by the software as a formula and could be abused by an attacker.
In Symfony 4.1, we've added the opt-in csv_escape_formulas option in CsvEncoder, to prefix all cells starting by =, +, - or @ by a tab \t.
Since then, OWASP added 2 chars in that list:
- Tab (0x09)
- Carriage return (0x0D)
This makes our previous prefix char (Tab \t) part of the vulnerable characters, and OWASP suggests using the single quote ' for prefixing the value.
Resolution
Symfony now follows the OWASP recommendations and use the single quote ' to prefix formulas and adds the prefix to cells starting by \t, \r as well as =, +, - and @.
The patch for this issue is available here for branch 4.4.
Credits
We would like to thank Jake Barwell for reporting the issue and Jérémy Derussé for fixing the issue.
Sponsor the Symfony project.Login to add comment
Other posts in this group
Nous sommes heureux de vous annoncer le retour des meetups Symfony à Tunis !🎉 Rejoignez dès maintenant le groupe "Symfony User group Tunis" pour suivre les actualités et futurs meetup de la communauté
This week, Symfony 6.4.20 and 7.2.5 maintenance versions were released. In addition, Symfony successfully celebrated the SymfonyLive Paris 2025 conference and continued preparations for next week's Sy
Symfony 6.4.20 has just been released. Here is the list of the most important changes since 6.4.19:
bug #60054 [Form] Use duplicate_preferred_choices to set value of ChoiceType (@aleho)bug #5985
Symfony 7.2.5 has just been released. Here is the list of the most important changes since 7.2.4:
bug #60054 [Form] Use duplicate_preferred_choices to set value of ChoiceType (@aleho)bug #60026
SymfonyLive Berlin 2025 is almost here! Join us next week for an exciting event filled with fresh talks, inspiring speakers, and everything you need to make the most of this incredible gatheri
After announcing the Symfony UX Core Team and adding more core team members earlier this year, I'm back again with a great addition to the Symfony Core Team. I'm very excited to announce that Tugdual
This week, the upcoming Symfony 7.3 version updated its default configuration to exclude container extensions, entities and messenger messages when registering services, and made some changes related
