Bulk Bit.ly URLs Shortener – 2018

Do you have more than 10 links or even 100 links that you need instantly shortened using bit.ly? I am sure you are not looking to do them manually and I am sure you tried to google for the solutions and found quite a few excel sheets which are not working. This tutorial is for 2018 with updated API of bit.ly to bulk shorten URLs. 

Steps are pretty simple.

  1. Make a copy of this Excel sheet (File -> Make a Copy…)
  2. Generate your Access Token in bit.ly by following the steps below
    1. Go to Settings
    2. Click on Advanced Settings
    3. Click on OAuth (http://prntscr.com/iiogfh) and then Generic Access Token
    4. Enter your password and click Generate Token
  3. Enter the access token in the first sheet of the excel copied in the first step
  4. Go to the Shortener tab in the excel and enter your links to bulk shorten all of them

If you are copying these shortened URLs into a spreadsheet, you’ll need to right click and use the “Paste Special” function and paste “Values Only” otherwise you get the formula rather than the URL.

Leave a Reply

Your email address will not be published. Required fields are marked *

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