The result will be a comma delimited text file which you can export to MS Excel for further analysis.

Read the following information in order to understand the whole process:

Step 1 - Download and install both, Python and Tweepy, and make sure you have a Twitter API. Watch this YouTube video to familiarize yourself with these concepts and the applications.

Step 2 - Download the scripts and place them in a folder.

Step 3 - Run either the retrieve_tweets_auto, the retrieve_tweets, or the retrieve_tweets_list_ids script. Once you're done, a "data" folder will be created and it will store all the data that was extracted from the tweets. The more users you have, the more times you will have to re-run the script, mainly due to the "time-out" errors.

Step 4 - Open up MS Excel > Click on the "Data" tab > "Get External Data" > "From Text" > Select the "twitDB.txt" file that was generated. Make sure you check the "Delimited" option, use "Unicode (UTF-8)" encoding, and select "Comma" as the delimiter.