Twitter - Saving your Tweets

by agrace 19. December 2009 19:44

Follow me on Twitter In my ever ending search for a tool/technology to manage my inflow of information from the Web, I opened a Twitter account that could also act as a set of pseudo-bookmarks. My IE8 and Firefox bookmarks already stretch to the floor when expanded. Plus, I'm convinced that there must be some unknown aspect of HCI that dictates that once something is saved as a bookmark, it is never opened again. Bookmarks drop downs are about as user-friendly as crotch rot. I've looked at Evernote and OneNote, the latter being the most promising to date. I plan to take another look at the products from Microsoft Live Labs.

Recently, I passed the 700 tweet mark and decided to archive what I had. But how? I gleaned the following tidbits from "Twitter Tips, Tricks, and Tweets" by Paul McFedries - founder and CEO of Mashable. You can save a local copy of your tweets by entering the following URL in your browser:

where account = your account name, and
n = number of tweets


Tweets XML


This will open n number of your tweets to date in XML in your browser. From here, you can import your saved XML file into Excel 2007 as follows:

1) In Excel, click on the Data tab

2) Data -> From Other Data Sources - From XML Data Import

3) Click a cell where you want to import the data to

4) Save as, using the id of the last tweet

Save Tweets


Tweets URL


The reason I include the last Tweet id# is to make it easy to archive next time, starting where I left off and using the following syntax:


If you look at the Excel sheet you will see that the last tweet had an ID of 6839319097. This will download an XML version of all my tweets since then. Now I have a proper archive of my tweets that I can search on :-)

From here, you might want to take a look at the TweetSharp API - a complete .NET library allowing you to build Twitter applications in C# and .NET 3.5. I've started reading a great book on the topic: "Professional Twitter Development with Examples in .NET 3.5" by Daniel Crenna.



Comments (4) -

Lanny Bussert
Lanny Bussert United States
1/1/2010 7:55:37 PM #

Thanks for this entry, very educational. I have been learning the <a href="">Android programming environment</a> for the past couple months and am really having fun.

Nat Dunn
Nat Dunn United States
1/9/2010 3:08:08 AM #

This is very cool.  So did you create a special twitter account for your bookmarks where you just tweet URLs?

agrace United States
1/9/2010 4:09:52 AM #


What I meant to say is that I generally tweet items that I know I will want to refer to again. Then I can just use the steps above to retrieve the info! It's not perfect but when I'm in a hurry and see something of real interest in my Google Reader it is a handy way to archive it for myself and share it with other at the same time.

Anthony Smile

Thank you so much. i followed you success.
my tweet at

Pingbacks and trackbacks (6)+