inflow-logo

Inflow: eCommerce Marketing Agency

  • Services
    • SEO
    • PPC
    • CRO
    • Paid Social
  • Clients
    • Case Studies
  • About Us
    • Contact Us
  • Insights Blog
  • Request Proposal
  • Services
    • SEO
    • PPC
    • CRO
    • Paid Social
  • Clients
    • Case Studies
  • About Us
    • Contact Us
  • Insights Blog
  • Request Proposal

Home > eCommerce Digital Marketing Blog > SEO > Technical SEO > How to Convert A List of Short URLs to Long URLs With Bulk URL Checker Tools

How to Convert A List of Short URLs to Long URLs With Bulk URL Checker Tools

Posted By Alex Juel on June 4, 2013

  • 4shares
01-small-dog-big-dog

* image courtesy of Lorena Cupcake

There probably aren’t many reasons why you’d need to convert a bunch of short URLs to their original long URLs, but I can think of one reason. One of the techniques our link building team has found to result in some high-quality and easy wins is one from Seer Interactive on Using Twitter and Backlinks to Build Links. The basic idea is to find your followers on Twitter and compare their bio links to your own link reports to see who’s not linking to you. If they aren’t, your goal is to see if there are opportunities to do so.

A major part of this process is to get a free Twitter follower report from Simply Measured, which includes a list of URLs pulled from the bios of all of your followers.

The problem we’re having now is that it seems that just recently Twitter has started changing bio URLs to short urls, making it impossible to match up our own link reports to the websites pulled from Twitter.

02-twitter-redirecting-bio-urls

I went on a mission to find a way to convert a large list of short URLs to their originals so that we wouldn’t have to do this process manually, which would really suck.

Using an Online Redirect Checker To Convert URLs

My first idea was to search Google for a short URL converter, but I couldn’t really find anything, so then I started looking for a bulk redirect checker, since that’s what short URLs are actually doing – 301 redirecting to the original URL. That’s how I found this Bulk URL Checker from a company called Search Commander, Inc. It’s free, but it only does 50 URLs at a time. To paste the results into Excel, copy the entire table from the page and in Excel, right click and choose Paste Special > Text.

03-search-commander-url-redirect-checker

Xenu Link Sleauth

I continued to search for a tool that could handle more URLs at once and I also wanted other alternatives just in case Search Commander’s tool ever breaks or goes away. Any internet marketer who’s been in the industry long enough knows how common tools just disappear.

Then I thought of Xenu Link Sleuth which is great at doing things like this and it’s free. It works perfectly!

04 - xenu-link-list

Place your list of the short URLs you want to check in a .txt file and upload it to Xenu, by going to File > Check URL List. Upload the file and wait for it to run.

When it’s done, it’ll ask you if you want a report. Say no, then go to File > Export Page Map to TAB separated File and name it with a .XLS extension so that you can open it in Excel. There you go!

05-xenu-pagemap

The only problem with this method is that Xenu Link Sleuth is a Windows-only program, so you’ll need a PC, or if you’re on a Mac, you’ll need to run Windows in virtualization software such as Parallels for Mac ($80 per license) or VirtualBox, which is free and open source. I love VirtualBox, so I highly recommend it.

Screaming Frog

Xenu also has a competitor named Screaming Frog, which works on PC, Mac and Linux. I tested this one out too and it works just as good as Xenu.

06-screaming-frog-choose-list

Open up Screaming Frog and go to Mode > List. Choose the .txt file containing a list of your URLs and click the Start button.

07-screaming-frog-response-codes

When it’s finished scanning, go to the Response Codes tab and choose Export and there’s your list in an Excel file. Screaming Frog is free, but it’s limited to 500 URLs per scan, so if you have more than that, you’ll need to run it more than once or purchase a pro subscription for £99 per year.

Batch Link Review Tools and Tab Exporting Browser Plugins

08-linkbunch-and-copy-all-urls

The final option I could think of, and most likely a last resort because of the amount of time it would take, is to use a tool like Ontolo’s URL Reviewer or Linkbun.ch, which are tools that take a list of URLs and open them all up at once in your web browser. Once they’re all loaded up, you’ll need to use a browser plugin such as Send Tab URLs for Firefox. I’m sure there’s a similar plugin for Chrome, but I haven’t used one.

How Would You Use a Tool Like This?

This is the only time I can think of where I needed a tool that could do something like this, but I’m really interested hearing about how someone else might need it. Let me know in the comments!

******

Update: If the URLs you’re checking go through multiple redirects, the only tool here that will show you all of the redirects and the final URL is Xenu Link Sleuth. See the picture below of a test I did using my own website. The “/aimlessdirection.com/listing/” is the starting URL, and it runs through several other URL’s before finally returning to my home page.

xenu-link-sleuth-multiple-redirects

  • 4shares

12 Comments on "How to Convert A List of Short URLs to Long URLs With Bulk URL Checker Tools"
  1. Arif Gangji says:
    June 5, 2013 at

    Nice one Alex…

    Do you know if these follow multiple redirects? i.e. We had a case where we were pulling in a xml feed and it actually redirected 4 times before getting to the final url.

    Reply
    • Alex Juel says:
      June 5, 2013 at

      Great question Arif, thanks for the comment! I just set up a test URL on one my sites that redirects 5 times and tested it in all the tools. The only one of these methods that works is Xenu Link Sleuth. I added an image at the end of the post if you want to see what Xenu returns.

      Reply
      • Arif Gangji says:
        June 5, 2013 at

        Sweet. Thanks for trying that out.

        Reply
        • Alex Juel says:
          June 5, 2013 at

          Sure! It would be nice if Xenu could just give the final result, but I guess that’s as good as it gets.

          Reply
  2. Christy Correll says:
    June 7, 2013 at

    Nice post, Alex. One more way to use Screaming Frog, yaa!

    Reply
    • Alex Juel says:
      June 10, 2013 at

      Thanks Christy! Screaming Frog really is an awesome tool.

      Reply
  3. amrit says:
    November 15, 2017 at

    xenu…not giving me final redirected url.

    pls help

    Reply
    • Alex Juel says:
      November 15, 2017 at

      Unfortunately, I no longer have access to a Windows environment to troubleshoot for you, but Xenu has not updated since 2010 so it should work the same as it did when this post was published. Sorry! If your site is under 500 pages you can use the free version of Screaming Frog and export the redirect chains report.

      Reply
  4. Amrit says:
    November 17, 2017 at

    its not working as if now. will try screaming frog now. tnx

    Reply
  5. John Q says:
    February 1, 2018 at

    I would like to update a list of URL’s with http, get excel to follow the link and return the new URLS (https). Is this possible using an excel module?

    Reply
  6. John Q says:
    February 1, 2018 at

    Thank you!

    Reply
  7. Alex Juel says:
    April 4, 2018 at

    Hi John, I’m not sure about an Excel module, but here’s a post with a spreadsheet you can download. Looks like it does what you’re looking for – https://www.searchenginepeople.com/blog/how-to-check-http-redirects-with-microsoft-excel.html

    I would use Screaming Frog. You can run a crawl and get a redirect chain report, which would show you where all URLs originate and end up. The free version allows 500 URLs, so if you don’t have the paid version and you have a big site, you could instead import 500 URLs at a time with the crawl depth set to 0.

    Reply

Leave a Reply Cancel 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.

Related Posts

  • Quick AdWords Campaign-Level Audit for PPC Marketing Managers The last few months have produced an increase in requests for PPC audits here at Inflow. We’re not sure why the growing trend but two reasons stand out: 1. What should we be doing for […]
  • eCommerce Shopping Cart Optimization Trends for Checkout Sales & Conversions Inflow’s Conversion Optimization team has compiled and maintains a list of Best-in-Class eCommerce websites. This is part of a series based on the findings from our most recent review of […]
  • How to Scrape eCommerce Sites for SEO Content Audits with Screaming Frog When performing an eCommerce Content Audit, many times our Analysts will require the specific category page content and product page excerpts, so they can analyze for length, originality […]
Alex Juel on lake beach.

Alex Juel

Alex’s specialty at Inflow is to link it up, wrap it up, get it out there and get results. He has experience with clients large and small in a wide variety of industries.

View Author’s Profile

Related Categories

  • Content Marketing (13)
  • Link Building (16)
  • On-Page SEO (14)
  • SEO Strategy (10)
  • Technical SEO (33)
  • Most Popular Posts:

    eCommerce Marketing Automations Systems Compared
    Technical Mobile Best Practices for SEO and Usability
    Expanding the Horizons of eCommerce Content Strategy
    Thin & Duplicate Content: eCommerce SEO
    5 Ways eCommerce Content Audits Can Increase Revenue
    Want to get content like this straight to your inbox? Subscribe to our weekly content alerts and monthly Inflow Insights newsletter now.

    Categories

    • SEO
      • Content Marketing
      • Link Building
      • On-Page SEO
      • SEO Strategy
      • Technical SEO
    • Paid Advertising
      • Goal Metrics and Analytics
      • Paid Search
      • Paid Search Shopping
      • Paid Social
    • Conversion Rate Optimization
      • A/B Testing
      • eCommerce Page CRO
      • Mobile Conversion Optimization
      • Tools and Plugins
      • Usability
    • Case Studies
    • eCommerce Strategy
      • KPIs and Reporting
    • Digital Marketing Trends in eCommerce
    • Inflow News

    Request a Proposal

    We'll build a custom proposal to meet your goals. Get the process started now.

    Google Premier PartnerInflow is a facebook-certified-creative-strategy-professional Moz Recommended Company Inc 5000 Inflow Clutch Profile
    • Services
      • SEO
      • PPC
      • Conversion
    • Case Studies
      • SEO
      • PPC
      • Conversion
    • Insights Blog
    • Resources
    • More
      • Contact
      • Careers
      • Press Info
      • Privacy Policy
    REQUEST A PROPOSAL
     
    CALL US AT 303-905-1504
    Monday - Friday, 8 a.m. - 6 p.m. (MST)
     
    facebook twitter linked-in linked-in rss

    Send this to a friend