1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Convert Twitter Username IDs to Usernames

Discussion in 'Social Networking Sites' started by gold33, Jan 6, 2014.

  1. gold33

    gold33 Registered Member

    Joined:
    Dec 17, 2013
    Messages:
    85
    Likes Received:
    22
    Location:
    United States
    Anyone know of a tool that will do this in bulk?
     
  2. traglodit

    traglodit Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 7, 2013
    Messages:
    327
    Likes Received:
    25
    Home Page:
    excel macros, for example
     
  3. gold33

    gold33 Registered Member

    Joined:
    Dec 17, 2013
    Messages:
    85
    Likes Received:
    22
    Location:
    United States
    Any guidance on how to do that?
     
  4. lalit_burma

    lalit_burma Senior Member

    Joined:
    Jan 30, 2010
    Messages:
    847
    Likes Received:
    576
    Tell us with example ... what you are looking for ?

    May be I can help you ...
     
  5. gold33

    gold33 Registered Member

    Joined:
    Dec 17, 2013
    Messages:
    85
    Likes Received:
    22
    Location:
    United States
    I just have lists of username IDs that need to be converted to usernames. I found a script on metadatascience but haven't had any luck getting it to work. It just returns the username ID followed by: accountredirect_by_id where it should display the username.
     
  6. Beven

    Beven Elite Member

    Joined:
    Aug 30, 2011
    Messages:
    1,810
    Likes Received:
    937
    Location:
    United Kingdom
    What quantity are we talking?

    If you're having trouble you could hire somebody to do it for you.
     
  7. gold33

    gold33 Registered Member

    Joined:
    Dec 17, 2013
    Messages:
    85
    Likes Received:
    22
    Location:
    United States
    A pretty large quantity. Unfortunately Twitter Money Bot only scrapes Username IDs, but in order to use the Tweet Poster included in the software you need an actual username. I'm surprised more users of the software haven't documented the problem and found a solution.
     
  8. gold33

    gold33 Registered Member

    Joined:
    Dec 17, 2013
    Messages:
    85
    Likes Received:
    22
    Location:
    United States
    For anyone attempting this, here's what I ended up doing:

    1. Copy the list of scraped User IDs into Excel starting with cell A1.
    2. In B1 put this formula in the first cell: ="url of twitter/account/redirect_by_id/"&A1
    3. Copy that all the way down the rest of the column.
    4. Now, let's make the hyperlinks usable. In C1 copy this formula: =HYPERLINK(B1). Copy that down the column as well.
    6. Use WinAutomation or another macro recorder of your choosing to record a macro in which you open a URL in your browser, copy the redirected url now containing the usernames we've been looking for, paste those in D1 and repeat. Once you're finished just remove all instances of "url of twitter" using the find and replace tool and voila, a list of just usernames. Of course, use a proxy if you're going to do a ton of these. Enjoy!

    Sorry, my account's too new to post direct URLs, thus the "url of twitter" lines
     
    • Thanks Thanks x 1
    Last edited: Jan 7, 2014