Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Problem

 

Info

...

Many informal documents

...

exist that describe the CSV format

...

. One of which is the IETF RFC 4180

...

, which defines the format for the "text/

...

CSVMIME type registered with the IANA.

Kiuwan's CSV exported files are compliant with the RFC-4180 standard.

 

...

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

 

      2. Be sure to check "Comma" Separator Character

Image Removed

      3. After import, you will see the imported data 
Image Removed

...


  1. In the Import file dialog, select Comma in the Separator character section. 

    Image Added

  2. The data will appear when the import is finished.

    Image Added

  3. 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

 

...

bgColor#fff

 

Content by Label
showLabelsfalse
max5
spacesK5
showSpacefalse
sortmodified

...

reversetrue
typepage
labelskb-troubleshooting-article

Page properties
hiddentrue
Related issues