Exporting from ACT!

 

>How can I export ACT! fields to an Excel spreadsheet?

Select File, Data Exchange, Export...

wpe19.gif (40384 bytes)

 

Name the Export file with a .CSV extension.  This stands for Comma Separated Values.  This format can easily be read by Excel.

wpe1D.gif (19688 bytes)

Select Contact Records only, as Excel is not relational and would not know what to do with the Groups.

wpe1F.gif (19908 bytes)

 

Select Comma separated, and include the export field names to help check the export.

wpe1E.gif (11153 bytes)

Select how many records should export

 

wpe20.gif (19215 bytes)

Chanage the field list appropriately.

wpe21.gif (20249 bytes)

Or you can select the Load Map button to bring in a pre-saved map.

wpe22.gif (9735 bytes)

 

You can now bring in the CSV file into Excel.

wpe23.gif (51941 bytes)

 

.