Problem
CSV files are used as a way to import Kiuwan's data into Excel.
Microsoft® Excel opens .csv files, but depending on the system's regional settings, it may expect a semicolon as a separator instead of a comma. This may cause problems when importing into Excel data including multiline columns.
To avoid this problem, converting the CSV file with Google Sheets. See the following steps:
Solution
- Download the CSV file from Kiuwan to your computer.
- Open a new (empty) spreadsheet in Google.
- Go to File > Import... and import the CSV file.
![](/docs/download/attachments/14844679/CSV1.png?version=1&modificationDate=1516350811000&api=v2)
- In the Import file dialog, select Comma in the Separator character section.
![](/docs/download/attachments/14844679/CSV2.png?version=1&modificationDate=1516350837000&api=v2)
- The data will appear when the import is finished.
![](/docs/download/attachments/14844679/step1.png?version=1&modificationDate=1516350891000&api=v2)
- Kiuwan's exported data use an English locale. To change it to another language, go to File > Spreadsheet settings
![](/docs/download/attachments/14844679/image2017-5-31%2015_31_31.png?version=1&modificationDate=1516350925000&api=v2)
4. The file is now ready to be downloaded in CSV format. To do so, go to File > Download as > Microsoft Excel (.xslx)
![](/docs/download/attachments/14844679/step3.png?version=1&modificationDate=1516350967000&api=v2)
Related articles
-
Page:
-
Page:
-
Page:
-
Page:
-
Page: