{"id":14285,"date":"2017-10-08T00:52:30","date_gmt":"2017-10-08T00:52:30","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14285"},"modified":"2022-08-09T20:08:26","modified_gmt":"2022-08-09T20:08:26","slug":"excel-to-vcard-converter-tool","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","title":{"rendered":"VBA to Convert Contact Data in Excel to VCF format"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.17.6″ hover_enabled=”0″ da_disable_devices=”off|off|off” global_colors_info=”{}” custom_padding=”0px||||false|false” sticky_enabled=”0″ da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.17.6″ custom_padding=”||||false|false” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” custom_padding=”0px||||false|false” sticky_enabled=”0″]<\/p>\n

\n

Dear Friends,<\/p>\n

As you have learned about interacting with Text files through Excel VBA<\/a>, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.<\/a>
In this article, I am going to teach you how to Export contacts stored in an Excel table as the vcf file format. This is also called a vCard file. In other words, VBA to convert Contact details from Excel to Mobile Contact format.
Before we go on discussing the technical implementation of it, let’s understand – What is the VCF file format? What is its use of it? How are this article and code going to help you?<\/p>\n<\/div>\n

<\/i> What is VCF or vCard File ?<\/h1>\n

Don’t worry… this is nothing new. You have always been using this file indirectly.
It is an abbreviation of V<\/strong>irtual C<\/strong>ontact F<\/strong>ile. Basically, this is Text type file which stores the contacts which you use in Outlook, mobile etc. That is why, I said.. you have always been using this file directly or inderectly.
It is also known as vCard (Virtual Card) file. Extension for this file type is .vcf or .vcard
As I mentioned above, this is simple text file but all the details of a contacts are written in a specific format.<\/p>\n

Sample Structure of vCard or VCF file<\/strong><\/p>\n

Here is a sample vCard file. Each contact details are stored within
BEGIN:VCARD<\/code> and END:VCARD<\/code> tags as shown below:<\/p>\n

BEGIN:VCARD
\nVERSION:3.0
\nN:FirstName;LastName;;;
\nFN:FullName
\nORG:OrganizationName
\nTITLE:PostNameInOrganization
\nTEL;TYPE=WORK,VOICE:031-11223344
\nTEL;TYPE=HOME,VOICE:031-11223345
\nEMAIL:forrestgump@example.com
\nEND:VCARD<\/code><\/p>\n

You can refer Wiki page<\/a> to know more about all the tags used in this file format. It is explained in detail there.
For now, a number of fields, etc. does not matter, because we are going to learn the method to convert excel data to this format. The addition of fields or changes in syntax can be altered once you understand the base code with an example file.<\/p>\n

<\/i> VBA Code to Save contact details as VCARD<\/h1>\n

With a very basic vCard format, I have created a VBA code that can convert all the contacts stored in an excel sheet into a VCF File.[\/fusion_text][fusion_text]<\/p>\n

\nSub excelTovcf()\n    Dim FileNum As Integer\n    Dim iRow As Integer\n    Dim FirstName As String\n    Dim LastName As String\n    Dim FullName As String\n    Dim EmailAddress As String\n    Dim PhoneHome As String\n    Dim PhoneWork As String\n    Dim Organization As String\n    Dim JobTitle As String\n    \n    iRow = 7\n    ' set a unique integer for the new\n    ' text file\n    FileNum = FreeFile\n    ' Save this vcf file on desktop\n    OutFilePath = VBA.Environ$(\"UserProfile\") & \"\\Desktop\\MyContacts.VCF\"\n    Open OutFilePath For Output As FileNum\n\n    With Sheets(\"contacts\")\n    While VBA.Trim(.Cells(iRow, 1)) <> \"\"\n        FirstName = VBA.Trim(.Cells(iRow, 1))\n        LastName = VBA.Trim(.Cells(iRow, 2))\n        FullName = VBA.Trim(.Cells(iRow, 3))\n        EmailAddress = VBA.Trim(.Cells(iRow, 4))\n        PhoneHome = VBA.Trim(.Cells(iRow, 5))\n        PhoneWork = VBA.Trim(.Cells(iRow, 6))\n        Organization = VBA.Trim(.Cells(iRow, 7))\n        JobTitle = VBA.Trim(.Cells(iRow, 8))\n    ' Start printing the data in above specified\n    ' format of VCF file format\n        Print #FileNum, \"BEGIN:VCARD\"\n        Print #FileNum, \"VERSION:3.0\"\n        Print #FileNum, \"N:\" & FirstName & \";\" & LastName & \";;;\"\n        Print #FileNum, \"FN:\" & FullName\n        Print #FileNum, \"ORG:\" & Organization\n        Print #FileNum, \"TITLE:\" & JobTitle\n        Print #FileNum, \"TEL;TYPE=HOME,VOICE:\" & PhoneHome\n        Print #FileNum, \"TEL;TYPE=WORK,VOICE:\" & PhoneWork\n        Print #FileNum, \"EMAIL:\" & EmailAddress\n        Print #FileNum, \"END:VCARD\"\n        iRow = iRow + 1\n    Wend\n End With\n    'Close The File\n    MsgBox \"Total \" & iRow - 7 & \" Contacts are exported to VCF File. It is saved on your Desktop\"\n    Close #FileNum\nEnd Sub\n<\/code><\/pre>\n

 <\/p>\n

Note:<\/strong>
In the above code, I have used the most commonly used data for a contact. vCards are growing with a lot of information that can be stored for a contact. There are vCards, which even store profile pictures as well.
In this example, I have used Version 3.0. You can see there are more versions available on the wiki page.<\/div>\n

[\/et_pb_text][et_pb_cta title=”FREE DOWNLOAD: Excel To VCF File Converter” button_url=”\/excel\/wp-content\/downloads\/ExcelContactsToVCFConverter.xlsm” button_text=”Download Now” _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” global_colors_info=”{}”]<\/p>\n

I have created a sample excel workbook, using which you can simply convert contact details stored in an Excel Sheet to a VCF File format which can be imported to your outlook or phone contacts.<\/p>\n

\"Excel<\/a>

Excel To VCF File Converter<\/p><\/div>\n

[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.In this article, I am going to teach you how to Export contacts stored […]<\/p>\n","protected":false},"author":45,"featured_media":14357,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"

[fusion_text]Dear Friends,<\/p>

As you have learnt about interacting with Text files through Excel VBA<\/a>, it is time to see the usage of those methods you learnt. One usage, you have already seen here, in how to export excel data in CSV format.<\/a>
In this article, I am going to teach you how to Export contacts stored in Excel table as vcf file format. This is also called vCard file. In other words, VBA to convert Contact details from Excel to Mobile Contact format.
Before we go on discussing the technical implementation of it, lets understand - What is VCF file format? What is the use of it? How is this article and code going to help you?<\/p>

<\/i> What is VCF or vCard File ?<\/h1>

Don't worry... this is nothing new. You have always been using this file indirectly.
It is an abbreviation of V<\/strong>irtual C<\/strong>ontact F<\/strong>ile. Basically, this is Text type file which stores the contacts which you use in Outlook, mobile etc. That is why, I said.. you have always been using this file directly or inderectly.
It is also known as vCard (Virtual Card) file. Extension for this file type is .vcf or .vcard
As I mentioned above, this is simple text file but all the details of a contacts are written in a specific format.<\/p>

Sample Structure of vCard or VCF file<\/strong><\/p>

Here is a sample vCard file. Each contact details are stored within
BEGIN:VCARD<\/code> and END:VCARD<\/code> tags as shown below[\/fusion_text][one_full last=\"yes\" spacing=\"yes\" center_content=\"no\" hide_on_mobile=\"no\" background_color=\"#f4f4f4\" background_image=\"\" background_repeat=\"no-repeat\" background_position=\"left top\" hover_type=\"none\" link=\"\" border_position=\"all\" border_size=\"1px\" border_color=\"#f9c195\" border_style=\"solid\" padding=\"20px\" margin_top=\"\" margin_bottom=\"\" animation_type=\"0\" animation_direction=\"down\" animation_speed=\"0.1\" animation_offset=\"\" class=\"\" id=\"\"][fusion_text]BEGIN:VCARD
\r\nVERSION:3.0
\r\nN:FirstName;LastName;;;
\r\nFN:FullName
\r\nORG:OrganizationName
\r\nTITLE:PostNameInOrganization
\r\nTEL;TYPE=WORK,VOICE:031-11223344
\r\nTEL;TYPE=HOME,VOICE:031-11223345
\r\nEMAIL:forrestgump@example.com
\r\nEND:VCARD<\/code>[\/fusion_text][\/one_full][fusion_text]You can refer
Wiki page<\/a> to know more about all the tags used in this file format. It is explained in detail there.
For now, number of fields etc. does not matter, because we are going to learn the method to convert excel data to this format. Addition of fields or change in syntax can be altered once you understand the base code with example file.<\/p>

<\/i> VBA Code to Save contact details as VCARD<\/h1>

With a very basic vCard format, I have created a VBA code which can convert all the contacts stored in an excel sheet in a VCF File.[\/fusion_text][fusion_text]<\/p>

\r\nSub excelTovcf()\r\n    Dim FileNum As Integer\r\n    Dim iRow As Integer\r\n    Dim FirstName As String\r\n    Dim LastName As String\r\n    Dim FullName As String\r\n    Dim EmailAddress As String\r\n    Dim PhoneHome As String\r\n    Dim PhoneWork As String\r\n    Dim Organization As String\r\n    Dim JobTitle As String\r\n    \r\n    iRow = 7\r\n    ' set a unique integer for the new\r\n    ' text file\r\n    FileNum = FreeFile\r\n    ' Save this vcf file on desktop\r\n    OutFilePath = VBA.Environ$(\"UserProfile\") & \"\\Desktop\\MyContacts.VCF\"\r\n    Open OutFilePath For Output As FileNum\r\n\r\n    With Sheets(\"contacts\")\r\n    While VBA.Trim(.Cells(iRow, 1)) <> \"\"\r\n        FirstName = VBA.Trim(.Cells(iRow, 1))\r\n        LastName = VBA.Trim(.Cells(iRow, 2))\r\n        FullName = VBA.Trim(.Cells(iRow, 3))\r\n        EmailAddress = VBA.Trim(.Cells(iRow, 4))\r\n        PhoneHome = VBA.Trim(.Cells(iRow, 5))\r\n        PhoneWork = VBA.Trim(.Cells(iRow, 6))\r\n        Organization = VBA.Trim(.Cells(iRow, 7))\r\n        JobTitle = VBA.Trim(.Cells(iRow, 8))\r\n    ' Start printing the data in above specified\r\n    ' format of VCF file format\r\n        Print #FileNum, \"BEGIN:VCARD\"\r\n        Print #FileNum, \"VERSION:3.0\"\r\n        Print #FileNum, \"N:\" & FirstName & \";\" & LastName & \";;;\"\r\n        Print #FileNum, \"FN:\" & FullName\r\n        Print #FileNum, \"ORG:\" & Organization\r\n        Print #FileNum, \"TITLE:\" & JobTitle\r\n        Print #FileNum, \"TEL;TYPE=HOME,VOICE:\" & PhoneHome\r\n        Print #FileNum, \"TEL;TYPE=WORK,VOICE:\" & PhoneWork\r\n        Print #FileNum, \"EMAIL:\" & EmailAddress\r\n        Print #FileNum, \"END:VCARD\"\r\n        iRow = iRow + 1\r\n    Wend\r\n End With\r\n    'Close The File\r\n    MsgBox \"Total \" & iRow - 7 & \" Contacts are exported to VCF File. It is saved on your Desktop\"\r\n    Close #FileNum\r\nEnd Sub\r\n<\/code><\/pre>

[\/fusion_text][fusion_text]<\/p>

Note:<\/strong>
In the above code, I have used most commonly used data for a contact. vCards are growing with lot of information which can be stored for a contact. There are are vCards, which even stores profile pictures as well.
In this example, I have used Version 3.0. You can see there are more versions available on wiki page.<\/div>

<\/i> FREE DOWNLOAD : Excel To VCF File Converter<\/h1>

I have created a sample excel workbook, using which you can simply convert contact details stored in an Excel Sheet to a VCF File format which can be imported to your outlook or phone contacts.<\/p>[caption id=\"attachment_14345\" align=\"aligncenter\" width=\"981\"]\"Excel<\/a> Excel To VCF File Converter[\/caption]

[button link=\"https:\/\/vmlogger.com\/excel\/wp-content\/downloads\/ExcelContactsToVCFConverter.xlsm\" color=\"default\" size=\"xlarge\" stretch=\"\" type=\"\" shape=\"\" target=\"_blank\" title=\"\" gradient_colors=\"|\" gradient_hover_colors=\"|\" accent_color=\"\" accent_hover_color=\"\" bevel_color=\"\" border_width=\"1px\" icon=\"fa-download\" icon_divider=\"yes\" icon_position=\"left\" modal=\"\" animation_type=\"0\" animation_direction=\"down\" animation_speed=\"0.1\" animation_offset=\"\" alignment=\"center\" class=\"\" id=\"\"]DOWNLOAD EXCEL TO VCF FILE CONVERTER[\/button][\/fusion_text]<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[2077,2056],"tags":[],"class_list":["post-14285","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tools","category-udf"],"yoast_head":"\nVBA to Convert Contact Data in Excel to VCF format - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA to Convert Contact Data in Excel to VCF format\" \/>\n<meta property=\"og:description\" content=\"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-08T00:52:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-09T20:08:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"VBA to Convert Contact Data in Excel to VCF format\",\"datePublished\":\"2017-10-08T00:52:30+00:00\",\"dateModified\":\"2022-08-09T20:08:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\"},\"wordCount\":652,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg\",\"articleSection\":[\"Excel Tools\",\"User Defined Function\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\",\"name\":\"VBA to Convert Contact Data in Excel to VCF format - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg\",\"datePublished\":\"2017-10-08T00:52:30+00:00\",\"dateModified\":\"2022-08-09T20:08:26+00:00\",\"description\":\"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg\",\"width\":800,\"height\":538,\"caption\":\"Excel to VCF File Converter\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tools\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-tools\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VBA to Convert Contact Data in Excel to VCF format\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"VBA to Convert Contact Data in Excel to VCF format - Let's excel in Excel","description":"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","og_locale":"en_US","og_type":"article","og_title":"VBA to Convert Contact Data in Excel to VCF format","og_description":"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool","og_url":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2017-10-08T00:52:30+00:00","article_modified_time":"2022-08-09T20:08:26+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"VBA to Convert Contact Data in Excel to VCF format","datePublished":"2017-10-08T00:52:30+00:00","dateModified":"2022-08-09T20:08:26+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/"},"wordCount":652,"commentCount":5,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg","articleSection":["Excel Tools","User Defined Function"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","url":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","name":"VBA to Convert Contact Data in Excel to VCF format - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg","datePublished":"2017-10-08T00:52:30+00:00","dateModified":"2022-08-09T20:08:26+00:00","description":"Download FREE: Excel to VCF File converter. VBA to export contact to VCF file format. VBA to create vCard from Excel Contacts. Excel to VCARD Converter Tool","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/10\/VCF-File-Converter.jpg","width":800,"height":538,"caption":"Excel to VCF File Converter"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Tools","item":"https:\/\/vmlogger.com\/excel\/excel-tools\/"},{"@type":"ListItem","position":3,"name":"VBA to Convert Contact Data in Excel to VCF format"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14285"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=14285"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14285\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/14357"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=14285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=14285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=14285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}