CSV export & import

Having issues with export/import of CSV files.
In excel it cannot handle utf8 characters and Numbers wont use columns correctly.

Operating system: OSX 10.10
Tools: Excel 14.4.6 and Numbers 3.5


Excel

1.) I2Localization tool export csv file
A file is created with the delimiter ,

2.) Open a new Excel document, choose File -> Import
Select CSV file and import
Note here that I've looked at all import format options,
also tried import (treat consecutive delimiter as one = ")

What happens:
* File is imported correctly into Rows and Columns
* Any utf-8 characters is wrong (example åäö)
* Any multiline gets own row, no linebreak in cell

Try to fix
* Open the exported CSV file in text editor (example Coda)
* Convert tile to utf16
* Import CSV to Excel and choose format "Unicode 6.3 UTF-8"

This will show characters as åäö correctly but still has issues with multilines


Numbers

1.) I2Localization tool export csv file
A file is created with the delimiter ,

2.) Right click on the file and choose Open with -> Numbers

What happens:
* File is imported only as rows, it doesn't handle columns
* Any utf-8 characters is correct

Try to fix
In some way the only csv delimiter that works in Numbers is ;
Edit the file /I2/Localizations/Scripts/Google/LanguageSource_Export_CSV.cs
Set all delimiters to ;

Export a new csv file and load into Numbers. All works as it should with åäö and multiline


Wishlist for plugin
I'm guessing that for Windows and Excel it works as it should but for us Mac users we need a solution.
Maybe when exporting a csv file you can choose the delimiter, or default set ; because Excel can change import settings.
Else have export buttons Export Excel, Export Numbers

I havn't tried to change anything and then import. Hoping that everything works