Versions Compared

Key

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

...

📑 What is the difference between CSV and XLS file formats?

Read here https://kmlvision.atlassian.net/wiki/spaces/KB/pages/3369074732/in our article How-to + import + CSV + files +into+Excel#%F0%9F%93%91-What-is-the-difference-between-CSV-and-XLS-file-formats%3Finto Excel? (see the first section of an article)

📑 Downloading the results of your analysis

Read here https://kmlvision.atlassian.net/wiki/spaces/KB/pages/3369074732/in our article How-to + import + CSV + files +into+Excel#%F0%9F%93%91-Downloading-the-results-of-your-analysisinto Excel? (see in table of contents: Downloading the results of your analysis)

📑 Importing CSV files into Libre Office Calc

In order to obtain the data in the desired format, you have to open your CSV file in Libre Office Calc. To do this you have to perform the following steps:

  1. create a blank Libre Office Calc spreadsheet

  2. click “File” in the upper menu

  3. click “Open”

  4. choose the CSV file you want to open

  5. preview your data in the window that opened

    1. Checked separator options should be: tab, comma, semicolon and space

    2. your language should be set to English (if it is, for example, in German, your data might be imported incorrectly)

  6. click “OK” and review your data in the spreadsheet

Note

Important: In the video we show the importance of selecting the right language.

...