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 option 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