{"id":9307,"date":"2009-08-25T19:00:10","date_gmt":"2009-08-25T13:30:10","guid":{"rendered":"https:\/\/www.quickonlinetips.com\/archives\/?p=9307"},"modified":"2014-11-30T12:16:50","modified_gmt":"2014-11-30T06:46:50","slug":"download-all-twitter-tweets","status":"publish","type":"post","link":"https:\/\/www.quickonlinetips.com\/archives\/2009\/08\/download-all-twitter-tweets\/","title":{"rendered":"How To Download All Your Twitter Updates"},"content":{"rendered":"

How can you download all your Twitter Tweets?\u00a0 Your Twitter updates appear in your profile pages, so you always have access to all your tweets. However, once you\u2019ve posted a few dozen updates or more, it\u2019s a hassle to slog through a bunch of different pages in your profile to find the post you want. You can use the Twitter search engine to track down the post, but that\u2019s a bit of a hassle.<\/p>\n

Download Tweets<\/h2>\n

If you want easier access to your tweets, and you want to preserve a local backup copy of your updates, then you need to download your updates to your computer. You can do this right from your Web browser by entering a special address that uses the following general syntax:<\/p>\n

twitter.com\/statuses\/user_timeline\/account.xml?count=n<\/em><\/p>\n

Here, replace “account” with your Twitter username, and replace “n” with the number of tweets you want to return. If you want to return all your updates, log in to your account, check your total number of updates (it\u2019s available on both your home page and your profile page), and then plug that number into the above address as the count value.<\/p>\n

What you get in return is a page full of data in the XML (extensible markup language) format, as shown in the screenshot below.<\/p>\n

\"twitter-xml\"<\/p>\n

Now you save the data by choosing File > Save As<\/em>, choosing a location and file name in the Save As\u00a0 dialog box, and then clicking Save.<\/p>\n

If you\u2019d prefer to receive your tweets in the slightly more friendly comma-separated values (CSV) file format, check out Tweet Scan.com, which offers a download feature. It requires you to enter your Twitter username and password, but it\u2019s safe because it doesn\u2019t store your data.<\/p>\n

Analyze Tweets<\/h2>\n

If you have Excel, you can import the XML file into a worksheet for easier viewing, searching,\u00a0 and so on. Here\u2019s how:<\/p>\n

    \n
  1. In Excel, click the Data tab.<\/li>\n
  2. In the Get External Data group, choose From Other Data Sources >From XML Data Import. The Select Data Source dialog box appears.<\/li>\n
  3. Navigate to the XML file location, click the file, and then click Open. Excel tells you it will create a scheme for the file.<\/li>\n
  4. Click OK. Excel prompts you for a location to import the data.<\/li>\n
  5. Click the cell where you want the data to appear, and then click OK. Excel displays the XML data in a table.<\/li>\n
  6. Choose File >Save As, and then use the Save As dialog box to save the data as an Excel workbook. Consider using the Save as type list to choose the Excel 97-2003 file format for maximum compatibility. Screenshot below shows just such a file loaded into the Mac version of Excel.<\/li>\n<\/ol>\n

    \"twitter-excel\"<\/p>\n

    Update Tweet Downloads<\/h2>\n

    Downloading your tweets is easy, but this method suffers from a glaring problem: as soon as you start\u00a0 posting tweets again, your backup becomes out of date, so you need to perform regular downloads. However, it doesn\u2019t make sense to download all your tweets each time. You could adjust the count value based on the number of updates you\u2019ve sent since the last download, but Twitter offers an easier way.<\/p>\n

    If you examine the screenshot above, you see that each tweet is given a unique ID value. You can use the value to download just those tweets you\u2019ve posted since your last download. You do that by using your Web browser to enter a special address that uses the following general syntax:<\/p>\n

    twitter.com\/statuses\/user_timeline\/account.xml?since_id=ID<\/em><\/p>\n

    Again, “account” is your Twitter username, and “ID” is the ID value for the latest tweet in the previous download. For example, in the screenshot above, you can see that the latest tweet in my @AkmalWardak account has the ID value of 3354513509, so I could download every tweet since that post by using the following address:<\/p>\n

    twitter.com\/statuses\/user_timeline\/akmalwardak.xml?since_id=3354513509<\/em><\/p>\n

    Guest blogger Akmal Wardak writes on AkmalWardak.com \u2013 A blog about social media, software reviews, how-to tutorials and WordPress tips.\u00a0 <\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    How can you download all your Twitter Tweets?\u00a0 Your Twitter updates appear in your profile pages, so you always have…<\/p>\n","protected":false},"author":4,"featured_media":9387,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[6,111],"tags":[44,49],"class_list":["post-9307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogging","category-social-media","tag-guest-posts","tag-tutorials"],"_links":{"self":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/9307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/comments?post=9307"}],"version-history":[{"count":0,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/9307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media\/9387"}],"wp:attachment":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media?parent=9307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/categories?post=9307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/tags?post=9307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}