Convert xls to csv without any data changes

0 votes
I have an xls file with a lot of Unicode data, including information like this: 0004 and others.

I need to export this file in CSV format, however when I do so from Microsoft Excel, the data are altered. Unicode symbols are transformed to "???," and values like "0004" are changed to "4".

Is it feasible to convert xls to CSV without modifying the data?
Dec 16, 2022 in Others by Kithuzzz
• 28,900 points
86 views

1 answer to this question.

0 votes

Here are the 3 solutions I have got:


I) With OpenOffice you can convert any ms excel format to any excel format (CSV too) and you can choose the character encoding, delimiter characters, etc for example utf-8 too.

  • Open xls file in openoffice
  • File/Save as
  • Choose the output format (CSV)
  • Click on save
  • A dialog appears, choose character encoding, delimiter character, and the other.

II) You can do it with ms office >= 2010 too:

http://www.excelforum.com/excel-general/400043-csv-and-unicode-or-utf-8-problem.html

III) Or if you have notepad++ you can convert the character encoding of the 'wrong' character encoded CSV file. Character Encoding, UTF or ANSI?

answered Dec 16, 2022 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
7,631 views
0 votes
0 answers
0 votes
0 answers

How to convert a data frame column to numeric type?

How can we convert a data frame ...READ MORE

Jun 13, 2022 in Others by Avinash
• 1,260 points
75 views
0 votes
1 answer

How to convert Ods file to Data Set C#

You can see the answer here: Refer: stackoverflow.com/que ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 53,520 points
193 views
0 votes
1 answer

Xls to csv converter

Use xlrd - it's faster, cross-platform, and ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 53,520 points
139 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

answered Sep 15, 2022 in Database by narikkadan
• 53,520 points
444 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 53,520 points
224 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 53,520 points
434 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP