How to open CSV files with third party tools
In case you would like to look through the data exported from your Act! database you can use the following tool for viewing CSV file. CSV files cannot be viewed in MS Excel properly. You’d need to use another tool for data viewing. CSV is the most common file format and is supported by most part of contact management systems where you can import exported from Act! data.
How to open files with help of DATASUITE addon
Alternatively, if you have a license for IMPORT|IT addon, you can upload the file to a new schema and view data source in the IMPORT|IT:
The data will be displayed like this: