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