GuardTek Help Center

How to Convert CVS Excel Files (.csv) to Excel Workbook format (.xlsm)

All GuardTek excel files are on a CSV format. To convert to an excel Workbook format, follow these guidelines.

Select Column A on the file. Go to Data > Text To Columns

1.JPG

Choose Delimited and click Next 

2.JPG

Tick box Semicolon and click Next

3.JPG

Click Finish on last screen

4.JPG

Information is now displayed on a Excel Workbook format

5.JPG

If saving file be sure to SAVE AS and change format to .xlsm. Otherwise it will not save any changes you made.

6.JPG

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.