Exporting CSV file with hebrew

[Omer Zak]

On Sat, 2010-07-31 at 00:20 +0300, Ori Idan wrote:
> 
> 
> On Sat, Jul 31, 2010 at 12:17 AM, Omer Zak <w1 at zak.co.il> wrote:
>         My experience is limited to whatever my CPA is using (I think
>         he uses
>         Excel).  By experimenting with utf-8, cp862, iso_8859-8 and
>         windows-1255
>         encodings, we found that windows-1255 worked for him.
>         
>         If you find that Google Docs and Excel have contradictory
>         expectations,
>         then I suggest that you allow people to export the CSV file in
>         either
>         "Google Docs compatible" encoding or "Excel compatible"
>         encoding.
> 
> What is google docs compatible format?

By trial, I found that utf-8 is the Google Docs compatible encoding:
1. Create in Google Docs a spreadsheet with Hebrew text.
2. Export it in CSV format to a file in your PC.
3. Open the file in gedit and modify some cells.
4. Import the file into Google Docs and demonstrate that it displays
correctly the modified values.
5. By means of xxd -g 1 (or other means), confirm that the file is in
utf-8 encoding.

By the way, I expect Excel to be configurable to accept also other
encodings - but you'll have to find how to do it, and to write clear
instructions for the users.

--- Omer


-- 
Bottom posters are filthy heretics and infidels and ought to be burned
on the stake after having been tarred, feathered and having rotten eggs
thrown at their faces!
My own blog is at http://www.zak.co.il/tddpirate/

My opinions, as expressed in this E-mail message, are mine alone.
They do not represent the official policy of any organization with which
I may be affiliated in any way.
WARNING TO SPAMMERS:  at http://www.zak.co.il/spamwarning.html