Two quick improvements that would help with CSV exporting and importing into spreadsheet programs:
- Quote Text Columns – Any commas in the text fields currently break the CSV imports and have to be manually corrected. This can be (mostly) fixed by either quoting text columns in double-quotes and/or escaping commas in text fields (,). Double-quotes in text fields can be similarly escaped by double-quotes.
- Remove ‘$’ Prefixes – This causes issues with some spreadsheet imports which considers the column as text instead of number. A simple 2-decimal floating point number like “25.00” would work fine.