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


0
Download Tweets from tweeter








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


Like it? Share with your friends!

0
Abhishek Shah

-Digital Evangelist

3 Comments


Warning: Undefined array key "html5" in /home/bmsnewco/public_html/wp-content/plugins/facebook-comments-plugin/class-frontend.php on line 140

Facebook comments:

This Website Is For Sale. Email us an offer we cannot refuse on [email protected] :)

X
Choose A Format
Personality quiz
Series of questions that intends to reveal something about the personality
Trivia quiz
Series of questions with right and wrong answers that intends to check knowledge
Poll
Voting to make decisions or determine opinions
Story
Formatted Text with Embeds and Visuals
List
The Classic Internet Listicles
Countdown
The Classic Internet Countdowns
Open List
Submit your own item and vote up for the best submission
Ranked List
Upvote or downvote to decide the best list item
Meme
Upload your own images to make custom memes
Video
Youtube and Vimeo Embeds
Audio
Soundcloud or Mixcloud Embeds
Image
Photo or GIF
Gif
GIF format