Importing a Contact List Using PL/SQL
Navigate to Administration Marketing, Import, and then Job Setup and create a new Import Job for Contact Import.
Set the following values to enable the Database Import button:
Main Object: Contact
Source Type: Text File
Import Mode: Import new records
File Selection: Use exact file name
Data Type: Comma Separated OR Other Delimiter like (|)
File Name: Click on the file browser and select the file that you uploaded to the database directory.
Navigate to Data Mapping, and specify the mapping, required fields, and exact match fields.
Click the Database Import button to import the contacts.
Navigate to Sitemap > Contacts > All Contacts, query for the imported contacts, and verify that they display.