'convert xls to csv without any data changes
I have xls file, in him is very unicode data, also data like this 0004 and etc.
I need convert this file to csv format, but if simple save as csv from ms excel, data are changed, unicode symbols converted to - ???, data like this 0004, converted to 4
There are possible to convert xls to csv without any data changes ?
Solution 1:[1]
Convert the column to text in following way and then save as csv. Solves the problem for me.
- Select the column with such data
- Open Data >> Text to Columns
- Select Delimited >> Next >> Deselect all delimiters >> Next >> Select Text as Column Data Format and Finish.
- Save as csv
Solution 2:[2]
There is a fourth solution: http://xls2csv.genxcrowd.com/features
I used this program to convert a lot of files as a "one shot".
There is a lot of advantages:
- The export is fully customziable : encoding, delimiter, quote, etc..
- You can execute it on a folder and define a destination folder for the results
- You can execute it with command lines
Some screenshots:
Execution panel:
Configuration panel:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | |
| Solution 2 |