How to create QR codes for vCards
A vCard (or Virtual Contact File) is a specially formatted text that is used to transfer contacts between phones. Because it's just text, it's possible to create a QR code that can be scanned as a contact.
Nearly all phones can export contacts as vCards, which makes them a useful format for sending contact information. QR codes are a universal format that allow users to easily import this information on their phone.
In the example above, we used a spreadsheet generate vCards that can be imported as QR codes:
How it works
Under the hood, vCards are just text. Here's an example vCard:
ADR:;;123 Sesame St;SomeCity;CA;12345;USA
If you encode the above into QR code text, you can use the QR code API to get the following:
This can be done by taking the base URL,
https://quickchart.io/qr?text=, and then adding a URL-encoded vCard:
To learn more about the API, check out the documentation.
For more information on customizing the vCard, the vCard Wikipedia article contains a useful reference table that summarizes potential vCard properties for your use.
Automatically generating the vCard and QR code
We can go one step further. Here's an example spreadsheet that shows how you can generate scannable vCard QR codes based on your data.
First, we use a formula to fill in the vCard column based on the First name, Last name, Company, Cell, and Email columns:
N:" & A2 & " " & B2 &"
ORG:" & C2 & "
TEL:" & D2 & "
EMAIL:" & E2 &"
Then, we use the
ENCODEURL function to encode the vCard value to get a working URL:
="https://quickchart.io/qr?text=" & ENCODEURL(F2)
The resulting URL is valid and can be downloaded or embedded anywhere.
Finally, use the
IMAGE function to render the QR code:
That's all there is to it! To further customize your QR code, refer to the documentation.
For questions, head to the community forum.