Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers
Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers Winter Special Offers

How to Convert Excel Contacts to Multiple File Formats?


Approch to Export Excel Contacts Files into Six Different File Formats Such as PST/ vCard/ CSV/ PDF/ TXT/ HTML
Using SysTools Excel Contacts Converter

STEP 1

Launch SysTools Excel Contacts Converter from the installed location or Go to Start menu » All Programs» SysTools Excel Contacts Converter » click on the Excel Contacts Converter to launch the Software.

download


STEP 2

Once the tool is launched click on Browse button to add Excel file from its location.

browse

STEP 3

Once the Excel Contacts file scanning process completes, you can able to “Preview" your added CSV contacts file in the Excel File Preview section

preview




STEP 4

Convert Excel Contacts as PST Format

Select the "PST" radio button from the "Export Option"

pst2

STEP 5

Now, choose the following settings under Apply Setting:

  • Create New PST: This option will create the all new PST file for your Outlook.
  • Existing PST: This option will not create new PST in fact you will able to work on existing PST file.
  • MS Outlook Profile: By Chossing this option the converted directily goes to your configured MS Outlook profile.

  • Note: While using MS Outlook Profile option make sure that Microsoft Outlook is configured properly.

    pst-option

    STEP 6

    Click on the"Browse" button to provide destination path to save the resultant file(s).

    destination

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your file.

    allow empty

    STEP 8

    From Mapping window select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    excel fields

    STEP 9

    Users can also try the Auto Map option for automatically mapping

    mapping


    Users can save their fields map by clicking on the Save and they can also add the mapping by clicking on the Load button.

    save map

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Export Report go to the proposed destination location.

    pst2

    STEP 4

    Convert Excel Contacts as CSV Format

    Click on the "CSV" Radio button and to convert Excel contacts in CSV format.

    pst2

    STEP 5

    Under Apply Setting optio you will see two options such as

  • Standard CSV: By using this option you will create a standard CSV file that you can open in any CSV supported software.
  • Google CSV: In you want to import the Excel contacts in Google account, then choose this option. It will create the Google CSV file.
  • pst2

    STEP 6

    Click on the"Browse" button to provide destination path to save the resultant CSV.

    pst2

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your CSV file.

    pst2

    STEP 8

    Now, if you have selected the Standard CSV option from Apply Settings, then you no need to map your Excel contacts file

    pst2

    STEP 9

    But if you have selected the Google CSV option the you need to map your Excel contacts file and to map the fields, select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    pst2

    Users can also try the Auto Map option for automatically mapping

    pst2


    Users can save their fields map by clicking on the Save and they can also add the mapping by clicking on the Load button.

    pst2

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Exported CSV file go to the proposed destination location.

    pst2

    STEP 13

    You can open final CSV file in Excel to see the converted Excel Contacts file.

    pst2

    STEP 4

    Convert Excel Contacts as PDF

    To Convert Excel contacts to PDF select the"PDF" radio button.

    eml.1

    STEP 5

    To create single PDF file for all Excel contacts select Create single PDF file for all contacts option from Apply Settings

    pst2

    STEP 6

    Click on the"Browse" button to provide destination path to save the resultant PDF file.

    pst2

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your file.

    pst2

    STEP 8

    Under Mapping window select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    pst2

    STEP 9

    Users can also try the Auto Map option for automatically fields mapping

    pst2


    Also users can save their fields map by clicking on the Save and they can also add the mapping by clicking on the Load button.

    pst2

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Export Report PDF file go to the proposed destination location.

    pst2

    STEP 13

    You can open your PDF file in any PDF viewer to see the converted Excel Contacts file.

    pst2

    STEP 4

    Convert Excel Contacts as vCard Format

    Select the "vCard" radio button from the "Export Option"

    pst2

    STEP 5

    Under Apply Settings option you will get four option such as:

    • vCard 2.1: If you want to convert your Excel contacts to vCard version 2.0, then select this option.
    • vCard 3.0: By opting this option you will able to convert your Excel contacts to vCard version 3.0
    • vCard 4.0: vCard version 4.0 is the latest version of vCard and it is supported by iCloud so you can opt this option.
    • Create Singel vCard Files: This option helps to create sigle vCard files for all your Excel contacts.

    So choose the option as per your requirements

    pst2

    STEP 6

    Click on the"Browse" button to provide destination path to save the resultant vCard.

    pst2

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your vCard

    pst2

    STEP 8

    From Mapping window select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    pst2

    STEP 9

    Users can also try the Auto Map option for automatically mapping

    pst2


    Users can save their fields map by clicking on the Save and you can also add the mapping by clicking on the Load button.

    pst2

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Export vCard Report go to the proposed destination location.

    pst2

    STEP 13

    You can open the vCard file to see the contacts or you can transfer it to any devices that suport vCard.

    pst2

    STEP 4

    Convert Excel Contacts as HTML

    Click on the "HTML" radio button to choose the HTML format.

    MBOX.1

    STEP 5

    To create single HTML file select Create Single HTML file for all contacts option under Apply Settings.

    pst2

    STEP 6

    Click on the"Browse" button to provide destination path to save the resultant HTML.

    pst2

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your file.

    pst2

    STEP 8

    From Mapping window select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    pst2

    STEP 9

    Users can also try the Auto Map option for automatically mapping

    pst2


    Users can save their fields map by clicking on the Save and they can also add the mapping by clicking on the Load button.

    pst2

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Export Report go to the proposed destination location.

    pst2

    STEP 13

    You can open final HTML file with the help of anu browser to see the converted Excel Contacts file.

    pst2

    STEP 4

    Convert Excel Contacts as TXT Format

    Click on the "TXT" radio button to choose the TXT format.

    HTML.1

    STEP 5

    If you want to create single TXT file for all contacts, then select Create single TXT file for all contacts from Apply Settings option.

    HTML2

    STEP 6

    Click on the Browse button to choose the destination location for TXT file.

    pst2

    STEP 7

    Choose the Allow Empty Email Address to be Imported if you want to allow empty email address in your TXT file.

    pst2

    STEP 8

    From Mapping window select the Excel Fields and Export File Fields to map the Excel file fields, then click on the Add button to add the fields.

    pst2

    STEP 9

    Users can also try the Auto Map option for automatically fields mapping

    pst2


    Users can save their fields map by clicking on the Save and they can also add the mapping by clicking on the Load button.

    pst2

    STEP 10

    Once the mapping is completed click on the Export button to start the process.

    pst2

    STEP 11

    Once the export process is complete, then the following message would be prompted. Click on "Yes".

    This window will show the success as well as fail count as follows:

    pst2

    STEP 12

    Now, to preview the Export Report TXT file go to the proposed destination location.

    pst2

    STEP 13

    You can open final TXT file to see the converted Excel Contacts in TXT file format.

    pst2

    Free Download SysTools Excel Contacts Converter Software Download Now