up vote 0 down vote favorite
share [g+] share [fb]

I have a handheld scanner which can read vCards. To use it with Excel, I connect the scanner, open Excel and scan vCards with no configuration. When I do this, Excel puts the data all over the place (spread across columns and rows) in plain text format, like this:

BEGIN:VCARD;VERSION:3.0;N:doe;john;ORG:company;TITLE:Sir;TEL;TYPE=HOME,VOICE:111111;EMAIL;TYPE=PREF,INTERNET:l@xx.com;REV:20080424T195243Z;END:VCARD.

How can I get Excel to interpret the vCard properties and put them into columns?

link|improve this question
1. is that all one line or really wrapped before "EMAIL" as it displays here? 2. does the above all appear in one cell or are bits of it already parsed into multiple cells? and 3? if you scan multiple cards, does the data end up in Excel in a consistent way? Perhaps you could post a screenshot showing exactly what Excel is doing to/for your data. – StevenV Sep 1 '11 at 16:49
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.