A different system data can be stored in CSV or TXT files.

You can open such files in MS Excel:

  • open empty book and select from menu Data -> From Text-> Import data from a text file;

  • select the file in TXT or CSV format to import;
  • using the Import wizard:
    • on step 1: set that it is file with delimiters, select appropriate encoding (UTF-8 is recommended);

    • on step 2: Select semicolon (';') as delimiter;

    • on step 3: Select the data type 'Text' for the first column;

on the last step: You should specify the list of the book that will be used for import.

Back on top