Page History

Problem

Info

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

1. Download the CSV file from Kiuwan to your computer. 
2. Open a new (empty) spreadsheet in Google. 
3. Go to File > Import... and import the CSV file.
   
   Image Modified
   

1. 
   
2. In the Import file dialog, select Comma in the Separator character section. 
   
   Image Added
   
   
3. The data will appear when the import is finished.
   
   Image Added
   
   
4. Kiuwan's exported data use an English locale.

1. To change it to another language, go to File > Spreadsheet settings

Image Modified

4

. The file is now ready to be downloaded in CSV format. To do so, go to File > Download as > Microsoft Excel (.xslx)

Image Modified

Related articles