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