You need to configure the csv export from .xls.
The configuration method depends on the office suite you are using.
For example:
https://www.ablebits.com/office-addins- ... not-parsedConvert CSV to Excel: problems and solutions
The CSV format has been around for over 30 years, but notwithstanding its long history it has never been officially documented. The name CSV (comma-separated values) implies the use of comma to separate data fields. But this is in theory. De facto, many so-called "CSV" files use other characters to separate data, such as:
Tabs - TSV files (tab-separated values)
Semicolon - SCSV files (semicolon separated values)
Some implementations of CSV files wrap data fields in single or double quotation marks, while others require a Unicode byte order mark (BOM), e.g. UTF-8, for correct Unicode interpretation.
This lack of standard spawns various problems you may be faced with when trying to convert an Excel file to CSV and especially when importing a .csv file to Excel. Let's investigate these issues beginning with the most common one.
CSV file is incorrectly displayed in Excel (all data is displayed in the 1st column)
Symptoms. You are trying to open a .csv file in Excel and all of the data is displayed in the first column.
Cause. The root of the problem is different separators set in your Windows regional and language settings and the csv file. In North America and some other countries, the default List Separator is a comma. While in European countries the comma (,) is reserved as the Decimal Symbol and the List Separator is set to semicolon (;).
Solutions. There are several possible solutions for this problem, you can quickly look through the recommendations below and choose the one most suited for your particular task.
Specify the right separator directly in the CSV file. Open the CSV file with any text editor (even the usual Notepad will do) and add the below text in the first line. Note, it should be a separate line before any data:
To separate with comma: sep=,
To separate with semicolon: sep=;
As you can guess, you can set any other custom separator in the same way, simply type it after the equality sign.
Choose the needed separator in Excel. In Excel 2016, 2013 or 2010, go to the Data tab > Data Tools group > Text To Columns.
Run the Text To Columns wizard in Excel.
The Convert Text to Column wizard, choose the Delimited file type ad click Next. Then select the needed separator in the next step and click Finish.
Select the needed separator for the CSV file.
Change the .csv extension to .txt. Opening a .txt file in Excel will start the Text Import Wizard and you can choose any delimiter as discussed in importing a csv file to Excel.
Open a semicolon delimited CSV file with VBA.
Here is a sample VBA code to open a semicolon delimited CSV file in Excel. Though the code was written a few years ago for older Excel versions (2000 and 2003), if you are pretty comfortable with VBA, you won't have problems with updating it or modifying for comma delimited CSV files.
Note. All of the solutions above change the separator for a given CSV file only. If you'd rather change the default separator once and for all, proceed with solution 5.
Change separators in Region and Language settings.
Click the Start button and open the Control Panel, then click Region and Language > Additional Settings. The customize Format dialog window will open and you choose a dot (.) as the Decimal symbol and a comma (,) as the List separator.
Change separators in Windows Region and Language settings.
Click OK twice to close two dialog windows and you are finished. From now Microsoft Excel will open and display all CSV (comma separated) files correctly.
Note. Setting new decimal and list separators in Control Panel changes the default separator characters for all programs on your computer, not only Microsoft Excel.