Follow

How to add columns to a.CSV file with Excel

1) In the Admin tab of ExorLive, click "Download all users as .CSV"

english_pic_1.png

 

2) Open the file in Excel and click on the "A" to select the entire column.

english_pic_2.png

 

3) Click on the "Data" tab and select "Text to columns".

english_pic_3.png

 

4) Choose "Next" (make sure "Deliminated" is selected)

english_pic_4.PNG

 

5) Choose delimiter "Comma" and click "Finish"

english_pic_5.png

 

6) The file should now be arranged into columns.

english_pic_6.PNG