I have number of sql 2008 tables, some in English and some in Hebrew and some in both languages that I am trying to export to a spreadsheet (excel or google drive) and cannot seem to get them to display correctly. I am using the sql server import export tool. When I tried to export to excel directly, the Hebrew characters come out as question marks. When I try to export to a csv file using the unicode option and import that into excel, the Hebrew looks okay but many of the rows break into two or three rows. I can't figure out what the problem is. I've used different delimiters, but that doesn't seem to make a difference. Many of the rows have html tags and the columns are of varying lengths, some with large amounts of texts. I don't know if there are any limits with csv.
I've attached an example file and even without understanding Hebrew one can see where the rows are breaking in the middle of the item. Each item starts with an item number.
I would appreciate any insights.