Support .tsv because excel is a terrible program that gets confused with comma

esrg-knights / Squire

A re-introduction of the WebApp for ESRG Knights of the Kitchen Table.

https://www.kotkt.nl/

GNU General Public License v3.0

10 stars 8 forks source link

Support .tsv because excel is a terrible program that gets confused with comma #301

Closed LenaWil closed 1 year ago

LenaWil commented 1 year ago

Originally reported by Denise.

If you export the members using .csv and import it to excel on a Dutch system, excel gets confused because numbers are divided by , and not . in the Netherlands.

Therefore I propose we support .tsv as export target too.

LenaWil commented 1 year ago

Also, @VincentvRoosmalen complained about mojibake with accented names and emoji in member exports. And that the member names aren’t properly sorted when they have accent. (That last one should prolly be a separate issue, but I am lazy)

Maybe we should also include UTF-8 BOM markers?