HomeMobileAndroidFree QR Code Generator Template for Multiple Contact List

Free QR Code Generator Template for Multiple Contact List

This article is describing an easy workout using Google Sheet to create QR Code to share contact lists. You can use this contact list template by updating First Name, Last Name, Cell Phone and Email ID. The end user can scan the QR Code associated from the next column to scan and add the contact to their phone contact.

This is an easy solution if you want to create and share a couple of contact details within a group. This is very useful while you share your classmates’ contact details or teams contact list within your entire team.

How to use Contact List QR Code Template?

We created this template that can be used to generate your contact list. Simply click on the link Google Template Gallery and download templates and modify with required contact details. The QR Code will automatically update when you change the values in the field for First Name, Last name, Cell Phone and Email. Once you update the template with desired data, you can distribute these QR Code printouts to your friends or family and let them scan the QR Code to add contacts.

contact-qr-generator

Please see the sample in the above screenshot. You can download the template file from Google Template Gallery and change the data as per your choice. In each row, there is a sample of A4 (FirstName), B4(LastName), C4(5554441234), D4([email protected]).

How to create your own QR Code for Contact List?

Please replace these values in the cells, and you will see the QR Code is updating automatically. For more data, you can duplicate any rows and replace with your data. For your info, here is the QR Cell code to get the QR image based on these four cell values.

=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=BEGIN:VCARD%0AN:" & A3 & "%20" & B3 & "%0ATEL;CELL:" & C3 & "%0AEMAIL:" & D3 & "%0AEND:VCARD")

How to Scan QR Code to Add Contacts into Phone?

You can use any QR Code scanner app to scan the QR Code with your smartphone. Android and iPhone camera support QR code scanning with latest OS. If you don’t have any QR Scanner in your phone, we listed a couple of QR Code Scanner Apps for your iPhone and Android phones.

qr-scan

To test the QR Code, we attached a screenshot that scanned the QR Code from the Google Spread Sheet with iPhone. Depends on the app you use on iPhone, it may ask your permission to access your contact list to add a contact on the phone.

add-qr-contact

Once you tap yes to access your contact list, the QR Code Scanner will scan the QR Code and open with your Contact App on iPhone or Android. Please tap on ‘Create New Contact’ to add this contact into your phone list.

If you are interested in adding QR Code for the URL (website) address or with some other data, please see the article for creating QR Codes.

This Contact list QR code template will come handy when you want to share a bunch of contacts in a group. The group only need to scan this code and add to their list. This will save a lot of time and effort. You can create your business card with this code to help others to add your contact details to their phone by a simple scan.

Disclosure: Mashtips is supported by its audience. As an Amazon Associate I earn from qualifying purchases.

13 COMMENTS

  1. Is there a way to utilize more of the vcard options like nickname, organization, etc to incorporate in the qr code??

    • Yes, you can extend the list by adding more columns and update the code. However, QR code data limits to a few thousand bytes based on the size.

  2. Is there a way to have spaces in the text? I want to use full name or Desig as “Senior Manager”. For some reason the QR code doesnt get generated when a space is included in the colum text

  3. hi so I tried to change the code to accommodate company and title, and it just didn’t produce a QR code.
    This is simple code, what is my issue?

  4. This isn’t working for me. I entered all of my info and no QR code was generated. I saw Sander Fase’s tip about fixing the formula and it still didn’t work. Has anyone had success using this? If so, what’s the trick?

    • you cannot enter a space. Otherwise the QR code would be blank. I have 2 words for my last name, so I just joined it with a dot(.) instead of putting a space

    • you cannot enter a space. Otherwise the QR code would be blank. I have 2 words for my last name, so I just joined it with a dot(.) instead of putting a space

  5. Thanks for this. I have the information completed correctly, the QR updates, but it will not open the contacts app on my iPhone. the QR is captured, and I get the Contacts icon showing but then it freezes. any ideas?

LEAVE A REPLY

Please enter your comment!
Please enter your name here

You May Like

More From Author