Writing a transaction CSV that Google Sheets imports correctly: locale, decimals and formula injection

To write a transaction CSV that Google Sheets imports cleanly, follow four rules: quote per RFC 4180, write amounts as plain numbers with two decimals and no thousands separator, use one documented date format, and neutralise text cells that start with a formula character. Break any of them and Sheets silently reinterprets the file. If your app... Weiterlesen: Writing a transaction CSV that Google Sheets imports correctly: local…