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