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 |
...
...
, which defines the format for the "text/ |
...
...
...
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.
Image Modified
2. Be sure to check "Comma" Separator Character
Image Removed
...
- In the Import file dialog, select Comma in the Separator character section.
Image Added - The data will appear when the import is finished.
Image Added - Kiuwan's exported data use an English locale.
...
- 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
Content by Label | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
|
Page properties | ||
---|---|---|
| ||
|