RSS

Backup Your Tweets in Excel

29 Jul

I had written many small haikus on Twitter and I wanted to save them for later.

To do this, you should first save your tweets as an XML file.
Go to http://twitter.com/statuses/user_timeline/userid.xml?count=x

In the above link, replace “userid” with your user name and “x” with the number of tweets you want to download. (You can view your total number of updates on your twitter page.)

When the page opens, click Save As in your browser and save the XML file to your computer.

Open MS-Excel(2007) and click Data -> From Other Sources -> From XML Data Import

In other versions of MS-Excel, you would click Data -> XML -> Import

Browse your computer and select the Twitter XML file you downloaded.

Ta daaaa!!!!!!!!

You have all your tweets in a neat Excel sheet. Enjoy! 🙂

Advertisements
 
1 Comment

Posted by on July 29, 2011 in Tools

 

One response to “Backup Your Tweets in Excel

  1. Orlando Mezquita

    April 16, 2012 at 1:57 am

    Excellent!!! Thanks for this!

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: