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
            • Open Graph/Twitter Cards
              Deacyde
              Deacyde
              0
              2
              162

            • Is it possible for a twitter user to automate a response to a tweet that I marked as a favorite?
              Martijn_Scheijbeler
              Martijn_Scheijbeler
              0
              3
              83

            • Twitter Cards via Wordpress/Yoast
              Dan-Lawrence
              Dan-Lawrence
              0
              4
              215

            • Finding authoritative sources on Google+ - is there a tool?
              reidsteven75
              reidsteven75
              0
              3
              185

            • Twitter Username Change / Character length
              Dan-Lawrence
              Dan-Lawrence
              0
              5
              2.4k

            • 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

            • Tool that recognizes twitter spam accounts
              CPLDistribution
              CPLDistribution
              0
              6
              953

            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