Opening CSV file(saved in unicode) in excel




If anyone can help me on this, I would really appreciate

I have a file that is saved in .csv extension (Unicode
format). Let's say for example, I have the data as follows:


When I save the above data in .csv (in Ascii format) and
open in excel file, I see that each value is placed in
adjacent columns.

When I save the same data in .csv (Unicode) I see the
whole information appears in the single cell(first cell

Is there a limitation to the CSV FILE opening in EXCEL,
with Unicode format?

Any inputs/suggestions on this would be much appreciated

Jim Rech

If the commas are still in the long strings perhaps you can do a Data, Text
to Columns. Indicate the data is Delimited and that the comma is the

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question