Links

Bulk Link Creation

Our new bulk link creation feature allows users to create up to 1000 shortlinks at once with the upload of a single .csv file!
  1. 1.
    When creating a new shortlink, you will see a new option to create shortlinks from a .csv file
  2. 2.
    Download the template .csv file (to ensure that the file is formatted correctly for upload)
  3. 3.
    Upon opening the .csv template file, you should see something like this
  4. 4.
    Fill up the file with the original links you wish to shorten & save the file.
    • Note: Ensure to save the file in the original .csv file format, if not the file will not be available for selection for upload in the next step
  5. 5.
    Click on “Browse” and select the file you saved in the previous step
    • Optional: You can add up to 3 tags if you wish to categorise shortlinks created from this .csv file. Tags will be applied to all links in the .csv file.
  6. 6.
    Click on “Create” and you should see a success pop-up at the top of your screen indicating how many shortlinks were successfully created from your .csv file

How should I format my CSV file?

In order for successful bulk creation of links, the uploaded .csv file should be formatted properly.
Here are some checks to ensure your file is ready for uploading:
  • Uploaded file must be .csv file (e.g. .xlsx, pdf, .docx files are not accepted)
  • File must not contain more than 1000 links
  • Header row in the file should follow original header in template format exactly, ie. “Original links to be shortened”
  • No additional columns should be added to the file (eg. user should not insert more headers/columns like ‘preferred shortURL’)
  • File should not contain any empty rows
  • Original links in file should all be valid (eg. https://open.gov.sg)
There are several reasons why your attempt to bulk create links could have failed:
  • File contains more than 1000 links
  • Header row does not follow original header in template
  • More than 1 column in your csv file
  • Empty rows in your .csv file
  • Invalid original link, eg.
    • Broken links due to spacing issues
    • Links start with http:// instead of https://

How do I delete empty rows in my CSV file?

  1. 1.
    Open your file in your Notepad app (for Windows) or TextEdit app (for Mac)
  2. 2.
    Delete the empty rows like so:
    Before deleting the empty rows
    After deleting the empty rows
Your QR code generation should take up to 5 minutes to complete, and the status bar should automatically update to success (or failure). If your QR code generation is taking longer than 5 mins, please reach out to us for help here.
  • If your bulk link creation was successful, you should see a notification bar at the top that offers a few options for download.
    • Clicking on “QR Codes (PNG)”, “QR Codes (SVG)” and “Download all” will download a .zip file that contains all the generated QR codes image files in the corresponding file format.
    • Note: You will have to unzip these files & transfer them out in order to use them. Refer to Microsoft’s guide on unzipping file here for more details.
  • As an alternative, you can also find the option to download all the generated QR codes image files in your email like in the image below: