It will take seconds to accomplish the said task.
1. First and foremost thing that you need to do is download the tool known as "The Archivist".
Download link: - http://visitmix.com/labs/archivist-de...
2. In real term an archivist is a professional who assesses, collects, organizes, preserves, maintains control over, and provides access to information determined to have long-term value. The information maintained by an archivist can be any form of media (photographs, video or sound recordings, letters, documents, electronic records, etc.).
3. Here archivist is a Twitter Search Archive Tool, this tool uses a concept of data mining, and in this case the data would be extracted from twitter.
4. Run the setup and Install the archivist tool.
5. Once you had installed it, open the application than click on the button Get Latest.
6. A simple click of "Export to Excel" and you have a .TXT file you can open in Excel and play around with till your heart's content!!