Bitly Bulk URL Shortener Tool

Okay so you have 50 URLs and you want to convert them all into Bit.ly shortened URLs. But you don’t want to manually copy 50 URLs into bit.ly, and then manually paste 50 URLs out of Bitly.

Here is a tool you can use to mass shorten up to 50 bit.ly URLs. This simple tool uses Google Docs and the bit.ly API to automate the process. Here is how you do it.

Get a Bitly Account

Go get a free bitly.com account and log in to your account. Go to your account settings page. In settings, under advanced, you’ll see “OAuth Applications”, click the link and create a Generic Access Token (have this page open as you’ll need the keys in the the next steps).

bitly oauth registration

On this page you need to confirm your Bitly password and go ahead and click “generate token”.

Bitly Generic Access Token

Get the Google Docs spreadsheet

Sign in to your Google Drive account and click this link to download the Google Docs spreadsheet

A copy of the spreadsheet will open. Now go to “File” -> “Make a copy” (Important: as this creates a copy which you can edit)

Google spreadsheets

Start Creating Bulk Bit.ly URLs

Place the access token you generated in the earlier step into cell A3. Paste your URLs into cell A6

Your bit.ly shortened URLs should now appear in the Short URL column (column B6).

bitly bulk shorten urls

Et voila, it’s as simple as that

Matt

Matt is the founder of Hosting Kingdom
with 65 comments 3 95114

65 comments on “Bitly Bulk URL Shortener Tool”

  1. carole scott

    This works only if I keep the document on google drive. If I download it, the formulas all work initially but then if I close and then reopen my spreadsheet, it gets screwed up. So strange.

    Reply
    • Matt @ HostingKingdom

      That’s right Carole, won’t work ‘offline’ as the ‘formulas need to talk with’ the Bitly API. Haven’t tried it but the Google Drive Desktop app might work, let’s you work with docs and spreadsheets offline and it automagically saves and syncs.

      Reply
      • Hai

        I paste list 50 urls and it is very slow on working. It took me a long time to wait, it showed loading all time. Please show me how make it faster ?

        Reply
  2. Karri

    OMG. I have needed this since forever. Thank you SO very much for creating it!

    Reply
  3. Alex

    Same here! Thank you very much for this useful hint!
    After I shortened 250 links I got a “Rate Limit Exceeded”- error message. I expected this error much earlier. Does anyone know how long I have to wait before I can continue?

    Reply
  4. Duncan

    I’ve been using this for a couple of weeks and love it, but recently I’m seeing a message that I’m about to reach the ImportData limit of 50 (?)

    I’ve managed to find so far, that the new version of Sheets doesn’t have this limit, but when I’ve tried to copy the function in to a new version it tells me that urlencode is an ‘unknown function’

    Any ideas on creating this same tool in the new Sheets?

    Reply
    • Matt @ HostingKingdom

      Hi Duncan, glad you like it. I haven’t experienced this, not sure if this will work but instead of copying the formulas into a new spreadsheet, see if making a copy of the spreadsheet works (top menu > file > make a copy). Let me know how you go.

      Reply
  5. Ellory Wells

    Awesome tool! Thank you!

    Do you know if there is a way to Title the links within a given parameter? For example, I’d like to shorten links with a title in order – Podcast 1, Podcast 2, Podcast 3, etc. or another batch, Blog 1, Blog 2, etc.

    Is this possible?

    Reply
  6. Zarabianie na Blogu

    really good guide. I never thought that bitly can be used to mass-shortening links!

    Reply
  7. Rob Morrow

    Thanks for sharing mate! It really helped a lot!

    Reply
  8. Maheshwar

    Hey, thanks for this simple and useful tool and a detailed write-up ! Loved it !

    Reply
  9. Cathrine Pitsi

    You have no ideaaaaaa what this done for me, everyday I have been converting 38 urls’ one after the other…Best thing that’s happened this week lol. Thanks Guys, ya’ll ROCK!!!

    Reply
  10. JaimeJCandau

    Ohhhh….. I LOVE THIS. Huge thanks Matt!!!!

    Reply
  11. FreeDomain

    How about 10k urls in bulk?

    Reply
  12. Arkadi

    Excellent. This does work! (some do not)
    Thank You!

    Reply
  13. ECRoyce

    Great little Gdocs applet. Thank you!

    Reply
  14. Wreifu

    Great Doc! thanks for share!

    Reply
  15. Ralph Tyrell

    Thank you Matt for this post. You just saved me a whole lot of time! To be honest with you my eye first glazed over when I glanced at the API steps, but it was very well explained an incredibly simple.

    Reply
  16. Br

    If you want an offline version, download as CSV

    Reply
  17. Erika Can

    OH. MY. GOD.
    That works flawlessly!

    Thank you so much!

    Reply
  18. Matt Scofield

    Super helpful thank you!!

    Reply
  19. Lyndsey

    Is anyone finding that bit links are not being created well and constantly loading or coming pu with N/a?

    Reply
    • john

      The same here, I could create short url some weeks ago but now I get only “loading…” message and can´t create. Is the script still working?

      Reply
      • Matt @ HostingKingdom

        I just tested the spreadsheet plugging in my bitly oauth access token and it works for me (see http://postimg.org/image/sqgbciqld/)

        Reply
        • Joe

          Matt if you want to replicate the issue mentioned by others. Place a link to be shortened and leave it there DO NOT ERASE it. Then come back hours later sometimes the next day and then some or all will say N/A. Sometimes it fixes itself sometimes it doesn’t.

          Reply
          • Herbert

            Did you manage to find a solution on that one? i.e. reusing the same sheet over more then 1 week, after day 2 you indeed see ‘N/A’ in the cells with bitly’s of the previous day… it seem he can generate links but tries to recreate them in bit.ly via the api and then encounters they already existed…

  20. Megan

    This is amazing. It just saved me soooo much time. Thanks!

    Reply
  21. randy siegel

    can this be done for 2000 links by creating 40 different files?

    Reply
  22. Prateek

    Wondorful tool, it simplified my lots of manual. work

    Reply
  23. tukang

    great. solve my problem. bulk short url

    Reply
  24. Has the service stopped working?

    Hi,

    I’ve been using the shortening service a few times in the past month but now it doesn’t seem to work. Any idea why?

    Reply
  25. Gary

    Great tip, thank you. Do you have any idea how to accomplish the reverse? Decoding the shortened urls in bulk?

    Thanks again,
    Gary

    Reply
  26. Sebastian Sanchez

    Thank you so much helped me a lot!

    Reply
  27. Hariharan

    It worked 🙂 Thanks for saving a lot time 🙂

    Reply
  28. cholid budiman

    Her bitly link does not appear, the problem is what?

    Reply
  29. Alex

    Thanks a lot !!! I saved so much time ! 🙂

    Reply
  30. Derric Haynie

    You can do something very similar with Rebrandly.com, except you can put it on your own custom domain instead of using “bit.ly” and you can do more than 50 URLs at once.

    Reply
  31. fawzy mawy

    There is alos tiks.co
    works pretty much as intended

    Reply
  32. fawzy mawy

    I believe tiks.co is designed to make this – multiple URLs all at once and it varies the source dynamically and report grouped URLs that belong to same campaign

    Reply
  33. Rahman Wirajaya

    For the N/A problem, I figured that we just simply delete and paste the exact OAuth again. And voila, at least it works for me… Btw, thank you so much Matt! :]

    Reply
  34. EK

    Doesn’t seem to work anymore… Some API error on the step of generating new short urls in the table

    Reply
  35. Greg

    Sir, I love you! I’ve been looking for this for so long.
    You’re the real mvp!

    Reply
  36. Tony Cox

    This is exactly what I have been looking for!

    Reply
  37. Saga Iqranegara

    really useful!

    Reply
  38. Alisa

    this doesn’t work. I followed the direction. when I went to the “make copy” part of the direction, it only let me save to drive but did not specify if this “drive” is my own computer’s hard drive or not. I did so anyway to continue to the next step, copy/pasted a bunch of URLs from a text file. there were no shortened URLs or anything whatsoever generated to the other box on the right side of the page. why can’t these stupid URL shorten websites just already have batch shorteners? this is tedious. I don’t want to be held up in my work to have to learn how to do something new just to get a task done. I also don’t want to download any program either. How do I know who made it or is it contains spyware?

    Reply
  39. Offing

    Thanks Matt! This method is simply and well explained, so I could short all my links quickly. Regards!

    Reply
  40. J. Husin

    This is great! Thanks!

    Reply
  41. Colin Clapp

    Thank you. Worked a treat. So simple and so quick just when I needed it!

    Reply
  42. Suresh

    This thing still works without issues 🙂 You rock, Matt!
    Saves time for the client reporting. and all.

    Reply
  43. Sally Dikckson

    This is not working for me today. I copy the long URLS from Excel, and it does nothing – what am I doing wrong?

    Reply
  44. Kathleen

    Outstanding tutorial Matt. Thank you for this!

    Reply
  45. Mas Trigus

    This is amazing Mr. it work, It just saved me so much time. Thanks!

    Reply
  46. Sasha

    Well looks interesting, i will try it – have the plan to shorten 2K links, so, based on what i read here it has to be done in batches? Is there any other tool to (semi) automate it ?

    Thanks!

    Reply
  47. Bagas Priyambodo

    OMG! Thanks, bro. It totally works!

    Reply
  48. Mat

    Hi there!

    Unable to make a copy?

    Reply
  49. Bárbara

    Is this still working on 2019? Because I’m trying to do it, but hasn’t it worked. Please someone could help me? Thanks

    Reply

Leave a Reply

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