How do I use a CSV to bulk-upload QR Codes in my account?

Create great numbers of QR Code in one go with the help of a CSV.

book reader icon
1 Minute
facebook logo gray
linkedin logo gray
mail logo gray

Introduction

Want to generate and upload a large number of QR Codes in one go? Whether you need to create dynamic QR Codes for marketing campaigns, bulk-generate codes for product packaging, or import a batch of contact details into your account: bulk uploading can save both time and effort. In this article, we’ll explore how bulk QR Code generation works and how to do it in your account.

What is a bulk upload?

Bulk-uploading refers to the process of uploading multiple files or data records at once, instead of doing it one by one. This is commonly used for tasks like adding many products or importing contacts by using a CSV-file containing the relevant information.

How to prepare your CSV-file for bulk-uploading QR Codes

1. Create a CSV-file with any appropriate program

Create a CSV-file (with MS Excel, Notepad, TextEdit, ...) to bulk-upload your QR Codes. The following example shows you how the data must be organised. Download the CSV-file and upload it into your account to see how it works.

csv qr code bulk
Download a sample CSV for bulk-uploading QR Codes.
Please remember not to use any headers in your CSV-file.

2. Fill your CSV-file with the available information

After you created your CSV, it is time to fill it with the desired parameters for your bulk QR Code upload.

Necessary Information

Column A: URL

In the CSV-file, Column A is the Target-URL your QR Code should forward to. If you create static QR Codes, the text in this field will be displayed when scanned.

Column B: Name
Use Column B in the CSV-file to enter the QR Codes' chosen names (can also be displayed as labels).
You can name your QR Codes in an identifiable way, for example consecutively (0001, 0002, ...).

Optional information in the row creating a QR Code

The following columns (C, D, E, F and J) are basic pieces of information that go into the same row that first creates a QR Code. After the QR Code has been created with the first row, the other parameters (Redirection Date, Multi-Country and Multi-Language) must follow in dedicated rows below.

Screenshot of Row 1 of the CSV
Rows 1 and 6 in this picture create the basic QR Codes (that will later become a Multi-Country and a Multi-Language QR Code) and include the available information for columns C, D, E, F and J.
Column C: Vanity URL
Set an optional vanity URL encoded in the QR Code in column C. The vanity URL must be 3 to 50 characters long. If left blank, a random alphanumeric value with 6 to 20 characters length is generated. You can set the length in the import options.
Column D: Description

Include a description for your internal convenience. This has no bearing on the QR Code or its functionality.

Column E&F: Location

Enter Longitude (E) and Latitude (F) into your CSV if you know where you want to use your QR Code. This has no bearing on the QR Code or its functionality.

Column J: Tags
You may also assign tags to your QR Codes. Download a sample file here.

Optional information demanding dedicated rows

These parameters can only be added after the QR Code has already been created by a row above within the same CSV. Use column C (Vanity URL) to determine to which QR Code a row's information should be added.

Column G: Redirection date

To add a redirection date (from when on the QR Code should point to the Target URL in column A), add it to column G and enter the Vanity URL in column C to determine which QR Code it will be added to. The required format is YYYY-MM-DD hh:mm. Use a dedicated row that comes after the one creating the QR Code.

Screenshot of Row 2 in the CSV
After Row 1 has generated the QR Code, Row 2 can now be used to issue a redirection date.
Column H: Country
To add different targets according to country, use column H to enter the corresponding countries' shortcuts, while using column C to set the QR Code they should be added to. Download our complete country list here in your account.
Screenshot of Rowa 3 to 5 in the CSV
Now, the aforementioned QR Code created by Row 1 will be transformed into a Multi-Country QR Code by Rows 3 to 5.
Column I: Language
To add language-specific URLs, use column I, while keep column C to set the QR Code they should be added to. Download our complete language list here in your account.
Screenshot of Rowa 7 to 9 in the CSV
The QR Code created by Row 6 will now be transformed into a Muli-Language QR Code by Rows 7 to 9.

3. Save your CSV-file

Before uploading your file, you need to save it.

Please remember to save your table in the correct format (.csv)!

How to bulk-create QR Codes using a CSV-file

1. Log into your account

First, head to our website and log into your account.

Login

Login
Login Form

2. Go to the Import Page and click "Import QR Codes"

To get to your Import Page, please click Import in the left hand menu. Then, choose Import QR Codes.

Screenshot of Import Page and Button "Import QR Codes"
Go to your Import Page and click "Import QR Codes"

3. Choose your CSV-file

Next, hit Choose File and select the CSV on your device. 

Screenshot of Button "Choose File" on Import QR Codes Page
Click this button to choose your CSV.

4. Set optional parameters for your QR Codes

You can set additional options for your bulk-created QR Codes.

Screenshot of QR Code import options
Set additional parameters for your QR Codes

Delimiter

Set which delimiter your uploaded CSV file uses: Semicolon or Comma (or let the platform detect it).

Screenshot of dropdown "Delimiter" when importing QR Codes
Choose your delimiter
It is best to decide for one delimiter - do not mix them in your CSV.

Dynamic QR Code

Determine whether you want your QR Codes bulk-generated as dynamic or static QR Codes.

Lowercase only

You can activate Lowercase only if you don't want any uppercase letters in your Short URL.

Screenshot of option "Lowercase only" when importing QR Codes
If you activate this, your Short URLs will not include any uppercase letters.

Vanity URL length

Determine how long your Vanity URLs should be by entering a number (6-20) or by using the right-hand arrows. This only takes effect if your Short URLs are randomly generated (and have not been entered into the CSV).

Screenshot of option "Lowercase only" when importing QR Codes
Choose the lenght for randomly generated Short URLs.

Overwrite existing QR Codes with new target URL

Activate this option to bulk-change target URLs of already existing QR Codes in your account.

Screenshot of option "Overwrite existing QR Codes" when importing QR Codes
You can change existing QR Codes in bulk by using this option.
Remember to use the same Short URLs in your CSV as the already existing QR Codes you want to change, so the platform knows which QR Codes to update.

Extract the title automatically from target URL

You may use the target websites' titles as the names for your QR Codes. Importing will take longer with this option enabled, as each URL must be crawled individually.

Screenshot of option "Extract title automatically from target URL" when importing QR Codes
Activate this option to extract the target URLs´ titles to be used as the QR Codes´ names.
Even when extracting the names from the titles, your CSV needs to include names in column B, else your QR Codes will be generated incorrectly.

5. Click "Import QR Codes"

After everything has been set up, please click Import QR Codes to begin the importing process.

Screenshot of button "Import QR Codes" when importing QR Codes
Click "Import QR Codes" to begin the bulk QR Code generation.

6. After importing your QR Codes

Screenshot of success-message after bulk-uploading QR Codes
Congratulations! Your QR Codes have been generated. The number of rows equals the number of rows in your CSV-file.

Now that your QR Codes have been generated, you can find the whole bulk below the Import button.

Screenshot of uploaded bulk on Import Page
Find your new QR Codes on the bottom of the Import Page.

Bulk actions

Next to your bulks you will find a number of buttons targeted at the respective bulk.

Screenshot of bulk actions on Import Page
Use the buttons to the right of your bulks.
Get a notification E-Mail for each scan

Activate this option to get notification E-Mails for each scan of any QR Code within the bulk.

Screenshot of activated E-Mail Notification Button
Use this button to receive scan notification E-Mails.
Get the GPS location of your scans

Use this option to get the GPS position of your scans for this bulk.

Screenshot of bulk actions on Import Page
Use the buttons to the right of your bulks of QR Codes.
Reset the QR Code bulk's statistics

Click Reset to set back all statistics to zero for the QR Codes within this bulk.

Screenshot of button "Reset" on Import Page
Use "Reset" to reset all statistics of this bulk of QR Codes.
Delete the bulk of QR Codes

To delete the whole bulk of QR Codes, click Delete and confirm.

Screenshot of button "Delete" on Import Page
Use "Delete" to delete the whole bulk of QR Codes.
View the QR Code bulk's statistics

View the summarized statistics of the whole bulk of QR Codes by hitting Statistics.

Screenshot of button "Statistics" on Import Page
Click "Statistics" to view the summarized statistics of all QR Codes within a bulk.

Download a single QR Code from your bulk

Now that your QR Codes are all set up and have been created, you can access them listed in your QR Code overview by clicking View

Screenshot of button "View" on Import Page
Use this button to access your bulk-created QR Codes in list view.

Once there, you can click on a QR Code to apply a design to and/or download this single QR Code.

Screenshot of QR Code list overview
Click the QR Code to download your QR Code.

Download the whole bulk of QR Codes

You can directly download the whole bulk of imported QR Codes by clicking the Download button. You will then be able to apply a design to all QR Codes and/or download them.

Screenshot of button "Download" on Import Page
Hit "Download" to bulkd-download all your previously imported QR Codes.

How to bulk-update existing QR Codes using a CSV-file

You can set new target URLs for already existing QR Codes in your account by taking the following steps when bulk-uploading:

1. When creating your CSV-file

The process of updating your QR Codes is oriented at column C (Short URL). The Short URLs will remain the same, the target URLs (column A) will be updated. 

Please remember to use the correct Short URLs in your CSV so the platform knows which QR Codes to update.

2. When uploading your CSV-file

Before hitting the Import button, activate the option Overwrite existing QR Codes with new target URL.

Screenshot of option "Overwrite existing QR Codes" when importing QR Codes
Activate this option to bulk-change your existing QR Codes.

3. Enjoy your updated QR Codes!

After uploading your CSV-file, your existing QR Codes will have their new target URLs.

Last update 2 weeks ago