Exporting your contacts from ACT!


NOTE: The following instructions are for exporting your contacts (contacts only)


ACT! 2000 - export contact-only data

The instructions shown below are for ACT! 2000. If the steps provided do not match the version you are using, please refer to the Help menu that is provided with ACT!

  1. From the main menu in ACT!, click File -> Data Exchange -> Export.

The Export wizard opens.

  1. In the File type field, select Text - Delimited.
  2. Specify a file location and file name with  a . CSV extension. For example, the file name and location may be similar to, C:ActDatabaseExport.csv.
  3. Click Next.
  4. Since it is assumed that you are importing the name and address details of the contact records stored in the ACT!  database , select Contact records  only ,  and then click Options.
  5. Complete the following:
  •  Select the Comma option button in the Select field separator section.
  • Select the Yes, export field names  check box  in the Do you want to export field names section.
  • Click OK to return to the wizard.
  • Click Next.
  • Select All records and click Finish.


Exporting contacts from ACT!


NOTE: This tutorial was created using ACT! by Sage 2009, version 11.0. If you have a different version of ACT! your process for exporting contacts may be slightly different. View your ACT! help notes if you have questions.

  1. Launch ACT! and open your database.
  2. Select the File menu and click Export to open the Export Wizard.
  3. Click Next to get to the Specify Destination step.
  4. Select Text Delimited file type.
  5. Choose Filename and location for exported data.
  6. Select Comma Separated Values (*.csv) in the "Files of type" dropdown menu and click Open.
  7. Click Next.
  8. Select Contact Records as the type of records you want to export.
  9. Select All records and click Next.
  10. Select Comma for field separator character.
  11. Select the checkbox for Yes, export field names and click Next.
  12. Leave the export field order list alone and click Next.
  13. Click Finish.
    NOTE: ACT! does not actually export the data as a .csv so you have to re-open the file and resave it as a .csv file.
  • Open the file you saved.
  • Select the File menu and click Save As
  • Change "Save as type" to CSV (Comma delimited) (*.csv) and click Save.
  • Click Yes to replace the existing file.
  • Click Yes to change the form.

NOTE: If you want to import contacts from multiple users, follow the additional steps below. If you are only importing contacts for one user, proceed to the next section.

  1. Repeat Steps 1-8 to export the contacts for all users whose contacts you want to import into your account.
  2. Merge all files into a single CSV file using Excel or a similar application.
  3. Review your data for accuracy.
  4. Add a column titled "Assigned To" and add the User ID to this field in the format "128565". This step ensures that each user's data is correctly owned by that user in their account.  You can locate the User ID in the User Table in  the Admin  Tab.


NOTE: All users named in the CSV file must be created in your account before importing. 
On step 2 click on Browse and select the tab-Delimited file that is saved on your computer. Then click on Continue to Next Step.


© 2005 - 2024 ProProfs
add chat to your website