QR Factory
Unlimited Batch QR Codes using CSV Files
Don't have the app yet to follow along? Download QR Factory for free now.
How to create multiple codes:
- Create a file in Numbers or Excel.
- In the first row, fill in the column name (one name per column).
- In the rows below, fill in the appropriate values for each column.
- Export to a CSV file.
- Open up QR Factory, click the "Create Multiple Codes…" button, choose the file to use, the export folder, and optionally the icons folder.
- Click the "Create QR Codes" button, and soon all your QR codes will be available in the export folder you chose.
Tips:
- If you need a comma in one of the values (ex: "Company Name, Inc."), use a back slash before the comma. So the example would become "Company Name\,Inc.". This is called escaping the comma.
- If a column is key based, then use the format key=value separated by a semicolon ";". Ex: latitude=-30;longitude=40
- New Feature in v2.7: All keys for vCards can be used in columns instead of key/value pairs. See Example Exported CSV File (with vCard Columns) for an example.
- New Feature in v2.7.3: The IconSize column now requires a value between 1-100 which is the percent size to use for the icon. For example, 35 will scale the icon to 35% of its original size.
- New Feature in v2.9.6: The IconBorderPercent column is now available with a value between 0-100 for the percent of the icon's size to use for the border around it.
- New Feature in v2.9.8: The RotationAngle column is now available with a value of 0 (or leave it blank), 90, 180 or 270 for the degrees to rotate the saved code.
- New Feature in v2.9.8:The ColorSpace column is now available with a value of RGB, CMYK or Grayscale. This is the color space that the code will be saved in. Please note that the only format that supports all three color spaces is TIFF.
- New Feature in v2.9.13: The colors for the PixelColorStart, PixelColorEnd and BackgroundColor colums can now be specified with "rgb(r,g,b)" or "cmyk(c,m,y,k)".
- New Feature in v2.9.13: For Calendar type codes, the description field can now be added as part of the Content column.
CSV Format:
Column Name | Key | Value |
Type | Text |
Content | Any text up to 240 characters |
Type | Email |
Content | email | Any email address |
Content | subject | The subject of the email |
Content | body | The body of the email |
Content | cc | Email address to cc (carbon copy) |
Content | bcc | Email address to bcc (blind carbon copy) |
Type | URL |
Content | Any URL including the scheme (ex: http:// or https://) |
Type | GPS |
Content | latitude | Latitude as a decimal number |
Content | longitude | Longitude as a decimal number |
Type | Phone |
Content | type | PhoneNumber or SMS |
Content | number | Any phone number |
Type | Person |
Content | nameTitle | Person's title (ex: Mr, Mrs, Dr, etc) |
Content | firstName | First name |
Content | lastName | Last name |
Content | nickname | Person's nickname |
Content | company | Company name |
Content | jobTitle | Job title |
Content | jobDepartment | Job department |
Content | phoneHome | Home phone number |
Content | phoneMobile | Mobile/cell phone number |
Content | phoneWork | Work phone number |
Content | phoneFax | Fax phone number |
Content | phoneNumberPreferredType | Home, Work, Mobile, or Fax |
Content | email | Email address |
Content | url | Homepage URL |
Content | street | Street address |
Content | city | City |
Content | provinceState | Province or state |
Content | postalZipCode | Postal or zip code |
Content | country | Country |
Content | addressType | Home or Work |
Content | note | Note about the contact. |
Content | cardType | VCARD or MECARD |
Content | encoding | ASCII or Unicode |
Type | WiFi |
Content | ssid | Name of the WiFi network |
Content | password | Password for the WiFi network |
Content | authenticationType | None, WEP, WPA or WPA2 |
Content | hidden | Yes or No |
Type | Calendar |
Content | title | The name of the event |
Content | description | The description (may be interpreted as a note in some scanners) of the event |
Content | location | The location of the event |
Content | start | Start time of the event in format YYYY-MM-DDThh:mm |
Content | end | End time of the event in format YYYY-MM-DDThh:mm |
Content | timeZone | Time zone of the event. Ex: "America/Vancouver" |
Type | SocialTwitter |
Content | Twitter username |
Type | SocialFacebook |
Content | Facebook page name |
Type | SEPA |
Content | bic | BIC (Business Identifier Code) of the beneficiary bank. Maximum of 11 characters. |
Content | name | Name of the beneficiary. Maximum of 70 characters. |
Content | iban | IBAN (International Bank Account Number) of the beneficiary. Maximum of 34 characters. |
Content | euroAmount | Amount in Euros. EUR is an optional prefix that will automatically get filled in if missing. Ex: "EUR10.5". Maximum of 12 characters. |
Content | purposeCode | Purpose of the transfer. Maximum of 4 characters. |
Content | remittanceText | Remittance information. If using a reference, maximum of 35 characters, otherwise 140. |
Content | info | Extra info. Maximum of 70 characters. |
FileName (optional) | The name of the file |
FileType (optional) | PNG, TIFF, PDF or EPS |
ColorSpace (optional) | RGB, CMYK or Grayscale. Please note that the only format that supports all three color spaces is TIFF. |
RotationAngle (optional) | 0, 90, 180 or 270 |
PixelRoundness (optional) | From 0.0 (square) to 1.0 (fully rounded) |
PixelColorType (optional) | Solid, LinearGradient or RadialGradient |
PixelColorStart (optional) | For "Solid", the pixel color. For "LinearGradient and RadialGradient", the start color of the gradient. It must be in one fo the following formats:
|
PixelColorEnd (optional) | For "Solid", this is ignored. For "LinearGradient and RadialGradient", the end color of the gradient. It must be in one fo the following formats:
|
BackgroundColorType (optional) | Solid or Transparent |
BackgroundColor (optional) | For "Transparent", this is ignored. For "Solid", the background colour of the code. It must be in one fo the following formats:
|
ReliabilityLevel (optional) | The amount of deterioration of the code that can occur where it is still readable. Low, Medium, High or Highest. |
AddIcon (optional) | Yes or No |
IconPath (optional) | The full path to the icon file to overlay in the middle of the code. It must reside inside the icons folder that was chosen in the app (because of Mac App Store sandboxing rules). For example: /Users/username/Desktop/Logo.png Pro Tip: To quickly copy the full path to a file, right click on it in the Finder, hold down the Option key and choose "Copy yourfilename as Pathname". |
IconSize (required if IconPath is used) | The percentage (1-100) that the icon should be scaled to. The icon will always retain its original aspect ratio. Note that the icon cannot be scaled to larger than its original size. |
IconWidth (optional if IconPath is used) | This can be used instead of IconSize for the width in pixels that the icon should be scaled to. Note that the icon cannot be scaled to larger than its original size. |
IconHeight (optional if IconPath is used) | This can be used instead of IconSize for the height in pixels that the icon should be scaled to. Note that the icon cannot be scaled to larger than its original size. |
IconBorderPercent (optional) | The percentage (0-100) of the icon's size to use for drawing a border around the icon. The border is used to visually separate the icon and the qr code. Use 0 to draw no border. |
OutputSize (optional) | The output size of the code. It can be between 64 and 4096. Note that the size will always be a square (width and height are the same). |
who we are
Tunabelly Software is a Canadian software development company.
contact us
what we do
Specialize in making amazing macOS, tvOS and iOS apps.