Wanna download the tweets ?? Here is the solution. .

How to import your tweets directly from tweeter to the excel file? ? ?

The above can be done by many methods and many tools.

Here I would be showing two of the easiest technique.

Procedure:-

The only difference between the ways is that in the first way the tweets that are of a particular user would be imported as mentioned in the assignment, and in the second way it would import all the latest tweets of the twitter.

1)By way of using an API of tweeter.

It will hardly take five minutes for the process to get completed.

1. You need to visit http://backupmytweets.com/ , than you need to click on the button “BACKUP YOUR TWEETS!!!”
2. Than you need to sign in @ http://twitter.com/ by clicking on the button “Sign In At Twitter.com and backup Your Tweets”.
3. After signing in the application (API) will ask to grant the permission for access. Press the “ALLOW” button there and than the twitter will redirect you to the application.
4. In the Dashboard of the API in the module of download formats, there are three formats available, in this case we will select xml format.
5. Just save that xml file on your PC.
6. Open a new workbook in EXCEL, than  navigate to the data tab than select “From Other Sources”
7. Than you need to click on From XML Data Import, than navigate your explorer and select the XML file that we had saved it before.
8. Once the XML file is opened than just save it as a worksheet and you are done!

The following is the live demonstration for the above by way of an API:

http://www.youtube.com/watch?v=IQlYo5iGsn4

2)By way of a Tool.

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-desktop/install/setup.exe

1. 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.).
2. 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.
3. Run the setup and Install the archivist tool.
4. Once you had installed it, open the application than click on the button Get Latest.
5. 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!!

The following link is the live demonstration for the above by way of a tool:

http://www.youtube.com/watch?v=IQlYo5iGsn4