In many cases, you might want to view and edit the data, which you recently exported from Vigilant, in Excel.  To bring the file into Excel properly you must follow these steps, exactly.

1. Open Excel.
2. Click on 'File' and choose 'Open'.
3. Find the name of the file you just exported.  It will end in “.ASC”
4. The text import wizard should launch.
5. Change the file type to delimited and then click on 'Next'.
6. Change the delimiter to comma instead of tab, then click 'Next'.
7. Click on each field on the data preview box and change the column data format to Text.
8. Click finish.

If you click on the file from My Computer and Excel launches, it will import the file using the default setting, which is what the above steps change.