Excel translates into VCF full raiders

VCF is the business card storage format for Outlook software in Windows systems, typically for Outlook business cards and mobile phone contacts. In many cases, we'll record user communications in Excel tables, but it's more cumbersome to store them in mobile phones and outlook. So at this point, we need to convert the Excel table into a VCF format. Search on the internet for a long time did not find the relevant software and conversion methods, here Word Alliance to personally share the ideas and methods, hoping to help everyone!

The first method of Excel VCF:

Directly in the Excel midpoint "file"--> Save As, "Save Type" select "CSV (Comma Delimited) (*.csv)", the file name, click "OK." Import the file into Outlook, enter the Outlook Address Book, click "File"--> export--> business card, the default extension is VCF, any file name can be.

The second method of Excel VCF:

1, first of all, excel in the format of the Address Book into the Outlook Experss identified by the. txt document format, and import the Outlook Experss phone book. Adjust the contents of the Excel table as follows:

2, copy the contents of the table to the TXT document;

3, and then copy the contents of TXT document to Word;

4. Export the format identified by Outlook Express to produce the TXT format (Outlook Express is located as shown below);

5, build a record, and export it into TXT format text;

6, the Export step poly, select "Text file (Comma separated)", export;

7, choose TXT document format to save;

8. Copy the separator symbol in the exported file ",";

9, the use of Word in bulk substitution function, the content into the required format and character;

10, the word address book content, copied to the TXT document, and save! (Note: TXT document first line, for the import of the recognition field, do not change!)

11, the contents of the Outlook Express address book empty;

12, open the Address Book "File"-"import"-"other Address book";

13, select the "text file (separated by commas)" option to import the saved TXT document;

14, in the import;

15, after the successful import to close Outlook Express;

16, and then import the phone Book of Outlook Express to the contacts in Outlook 2007. And from this, export the. vcf format File Open outlook2007, open the Import and Export Wizard, and select "Import from another program or file";

17, select "Outlook Express ...", and always choose "Next";

18, until the choice of "yes";

19, waiting for the import;

20, after the successful introduction of the picture;

21, the conversion of the form of business cards to guide the VCF format in the contact content, Ctr+a All selected data, right-click, and select "Send As a business card";

22, the effect is as follows:

23. Copy all the attachments:

24, paste into the folder can!

At this point, the Excel has been converted into VCF format, although the steps a bit more, more trouble, but always more than you a manual input better!