In this article we will go over how to convert a comma separated value (CSV) file to an Excel Workbook
All GuardTek excel files are in the CSV format. To convert to an excel Workbook format, follow these guidelines.
Select Column A on the file. Go to Data > Text To Columns
Choose Delimited and click Next
Tick box Semicolon and click Next
Click Finish on last screen
Information is now displayed on a Excel Workbook format
If saving file be sure to SAVE AS and change format to .xlsm. Otherwise it will not save any changes you made.
Please sign in to leave a comment.