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.
You have all your tweets in a neat Excel sheet. Enjoy! 🙂