The Moz Q&A Forum

    • Forum
    • Questions
    • My Q&A
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

    Browse the forum for helpful insights and fresh discussions about all things SEO.

    1. SEO and Digital Marketing Q&A Forum
    2. Categories
    3. Social Media
    4. Tool/Method to find users on Twitter from a CSV file

    Tool/Method to find users on Twitter from a CSV file

    Social Media
    4 3 1.5k
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Motava
      Motava last edited by

      I'm attempting to find users to follow and receive reciprocal follows for a client on twitter.

      Through the company's newsletter database, I have a CSV file of somewhere in the range of 20,000 email addresses and names.

      I've been importing them 250 at a time into an empty Gmail account then connecting that with twitter each time to find some of them.

      However, a lot of the PEOPLE using the email addresses on the mailing list are not on twitter but their COMPANY is. To find the company, I can obviously drop the name@ part of the email and just search by the domain but this becomes tedious real quick since it has to be one by one and cannot be bulk imported/searched.

      Are there any tools/ideas out there to more easily find twitter users based on a larger set of keywords and/or domain names?

      1 Reply Last reply Reply Quote 0
      • RyanPurkey
        RyanPurkey last edited by

        Since you're looking for users and not necessarily tweets, you can scrape the company names you're interested in via a spreadsheet, and then append this URL to each unique name: http://twitter.com/#!/search/users/

        Just getting rid of duplicate company names should cut down the list some, but it's still going to be a tedious process.  At least with the spreadsheet you can add further columns to prioritize your work and go after the companies that are most applicable.

        To cut the tedium, Mechanical Turk could then process the results for you fairly quickly.

        1 Reply Last reply Reply Quote 1
        • KeriMorgret
          KeriMorgret last edited by

          Hi Motava,

          I'm following up on older questions. Did you find a tool for this? Can you share anything with us for others looking for a similar answer?

          Motava 1 Reply Last reply Reply Quote 0
          • Motava
            Motava @KeriMorgret last edited by

            Hi Keri,

            No luck with any other tools, unfortunately. It's still something on the to-do list.

            Ryan's comment is helpful but still a lot of manual work involved unfortunately.

            • Victor
            1 Reply Last reply Reply Quote 0
            • 1 / 1
            • First post
              Last post
            • Hi guys, I need to create a subscribe end-off to my YouTube videos. I need something like this - https://www.youtube.com/user/SeattleCoffeeGear - where the red gear at the bottom pops up with a bright red "subscribe" CTA. How do I do this?
              Chris_Hickman
              Chris_Hickman
              0
              2
              115

            • Does anyone have a great way to determine where your new Twitter followers are finding you?
              EricaMcGillivray
              EricaMcGillivray
              0
              3
              255

            • How to promote website/blog on FB, Twitter, Pinterest etc?
              aap82
              aap82
              0
              4
              435

            • Twitter Tool Question
              Matt_Wilson
              Matt_Wilson
              1
              8
              182

            • Building links to a Twitter/social account
              OlegKorneitchouk
              OlegKorneitchouk
              0
              4
              207

            • Any facebook likes/shares/activities analytics tools
              LauraHT
              LauraHT
              0
              5
              513

            • Linking to a twitter account? Best to use the /#!/ or not? or no difference?
              caseyhen
              caseyhen
              0
              5
              618

            • Are there tools like followerwonk / wefollow for blogs?
              NerdsOnCall
              NerdsOnCall
              0
              2
              1.1k

            Get started with Moz Pro!

            Unlock the power of advanced SEO tools and data-driven insights.

            Start my free trial
            Products
            • Moz Pro
            • Moz Local
            • Moz API
            • Moz Data
            • STAT
            • Product Updates
            Moz Solutions
            • SMB Solutions
            • Agency Solutions
            • Enterprise Solutions
            • Digital Marketers
            Free SEO Tools
            • Domain Authority Checker
            • Link Explorer
            • Keyword Explorer
            • Competitive Research
            • Brand Authority Checker
            • Local Citation Checker
            • MozBar Extension
            • MozCast
            Resources
            • Blog
            • SEO Learning Center
            • Help Hub
            • Beginner's Guide to SEO
            • How-to Guides
            • Moz Academy
            • API Docs
            About Moz
            • About
            • Team
            • Careers
            • Contact
            Why Moz
            • Case Studies
            • Testimonials
            Get Involved
            • Become an Affiliate
            • MozCon
            • Webinars
            • Practical Marketer Series
            • MozPod
            Connect with us

            Contact the Help team

            Join our newsletter
            Moz logo
            © 2021 - 2026 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
            • Accessibility
            • Terms of Use
            • Privacy