CSV export & import

More
5 years 3 weeks ago #321 by roady
CSV export & import was created by roady
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 :S

Please Log in or Create an account to join the conversation.

More
5 years 3 weeks ago - 5 years 3 weeks ago #325 by Frank
Replied by Frank on topic CSV export & import
Hi,
I tested a CSV with the following characters (åäö) in Excel on windows and it worked fine.

I don't have a mac with me at the moment but will test it tomorrow in Numbers.

Although, searching the web it seems that Numbers have a issue with how they implemented the CSV parser. In the following links you can find a way to solve it. They suggest changing the encoding or using one of the programs listed there.

Nonetheless tomorrow I will check if a different enconding works and if so I will add an option to export with that enconding instead of UTF-8 or using ; instead of ,

rothmanshore.com/2013/10/29/solved-editi...8-encoding-on-a-mac/
answers.microsoft.com/en-us/mac/forum/ma...a2-8482-554ae235227b

Thanks,
Frank

Are you :-) Give I2L 5 stars!
Are you :-( Please lets us know how to improve it!
To get the betas as soon as they are ready, check this out
Last edit: 5 years 3 weeks ago by Frank.

Please Log in or Create an account to join the conversation.

Time to create page: 0.207 seconds
Template by JoomlaShine