My company uses the French version of MS Office and after upgrading, I can't quite get it to generate CSV files in the right encoding needed to work with the company's proprietary software. So I need to go through the hassle of manually generating the CSV files in the correct format. An easy way to work with different encodings and formats will be especially useful for collaboration.

One thing that would be simple and useful is the ability to generate or convert between different CSV file formats. For example, French CSV files use semicolons instead of commas to separate values, and use commas as decimal points.

Yeah, probably. A closely related problem is cleaning up data. Something that can detect unclosed quotes and/or unclosed HTML tags. Something that can figure out when a word should be capitalized or lowercase.

Here's another problem: how do you make a field in a CSV that when you convert the document into JSON, the field becomes an array?