Disclaimer: MashTips is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission at no extra cost to you.

Home Mobile Android Free 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.

8 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?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Free Newsletter

Read More...

10 Best Personal Finance Software for Mac

The best Finance manager apps can send notifications to any unusual bank and credit card activity in real-time. These best budgeting software also notify...

How to Repair Windows 8 Apps.

The windows 8 enables the users to install apps from the Windows Store like iTunes. Sometime you notice that your installed apps not working...

How to Recover Deleted Files in Ubuntu Linux

Did you accidentally delete any file on Ubuntu? In this tutorial, we'll show you how you can recover deleted files in Ubuntu Linux. We've all...

18 Best Samsung Galaxy S20, Plus & Ultra Cases

The Samsung Galaxy S20 lineup is the first popular flagship smartphone lineup of the year. It brings with it some new and...

Best 3 iOS apps to Test your iPhone Sensors & Functions

All of us are fond of the Apple products. Whether we are talking about the iPhone, iPad or the MacBook, Apple has always surprised...

10 Best USB C Headphones for Google Pixel, iPad& Huawei Phones

The USB C earphones are double sided connector with 24 pins, unlike an audio jack. This may not fit with your regular phones. However,...
%d bloggers like this: