Skip to main content

How To Download All Your Twitter Updates

How can you download all your Twitter Tweets? Your Twitter updates appear in your profile pages, so you always have access to all your tweets. However, once you’ve posted a few dozen updates or more, it’s 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’s a bit of a hassle.

Download Tweets

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:
http://twitter.com/statuses/user_timeline/account.xml?count=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’s available on both your home page and your profile page), and then plug that number into the above address as the count value.
What you get in return is a page full of data in the XML (extensible markup language) format, as shown in the screenshot below.
twitter-xml
Now you save the data by choosing File > Save As, choosing a location and file name in the Save As dialog box, and then clicking Save.
If you’d prefer to receive your tweets in the slightly more friendly comma-separated values (CSV) file format, check out Tweet Scan, which offers a download feature. It requires you to enter your Twitter username and password, but it’s safe because it doesn’t store your data.

Analyze Tweets

If you have Excel, you can import the XML file into a worksheet for easier viewing, searching, and so on. Here’s how:
  1. In Excel, click the Data tab.
  2. In the Get External Data group, choose From Other Data Sources >From XML Data Import. The Select Data Source dialog box appears.
  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.
  4. Click OK. Excel prompts you for a location to import the data.
  5. Click the cell where you want the data to appear, and then click OK. Excel displays the XML data in a table.
  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.
twitter-excel

Update Tweet Downloads

Downloading your tweets is easy, but this method suffers from a glaring problem: as soon as you start posting tweets again, your backup becomes out of date, so you need to perform regular downloads. However, it doesn’t make sense to download all your tweets each time. You could adjust the count value based on the number of updates you’ve sent since the last download, but Twitter offers an easier way.
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’ve posted since your last download. You do that by using your Web browser to enter a special address that uses the following general syntax:
http://twitter.com/statuses/user_timeline/account.xml?since_id=ID
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:
http://twitter.com/statuses/user_timeline/akmalwardak.xml?since_id=3354513509
Guest blogger Akmal Wardak writes on AkmalWardak.com – A blog about social media, software reviews, how-to tutorials and Wordpress tips. You can also write a guest article and share your tips and tricks.

Comments

Popular posts from this blog

SEO Optimizing A Website For Improved Value

SEO or search engine optimization is something that every web owner and creator should be aware of. Even if a website owner hires an expert to carry out the online marketing, understanding the very basics and how it really can improve a websites performance and popularity is important. Simply put, optimizing a website is important and is built around keywords that are valuable to a website and to the products or services it is trying to provide. By focusing on main keywords or key phrases for a business, and expanding on them over time, can improve the amount of visitors a website receives, in turn increasing profits or simply improving its popularity if it is an information website. SEO is valuable, and means a way of making a site appear at a higher ranking in search engines such as Google, Yahoo, AOL etc. Using this important type of online marketing can reap great benefits. It takes time to learn and time to complete, and is a constant job to keep a website performing well above co...

Email On Deck: A disposable email address that works

Today, Team Inforpioneer brings an interesting Email service for our reader which will definitely help our readers to improve their internet security and will benefit in some other ways.  Here is a short description of this service.  EmailOnDeck.com is the premier site for all things relating to temporary, disposable and throwaway email addresses. We want to help you avoid SPAM, protect your online privacy, and stop you from having to give away your personal email address to every company and person on the internet who insists on you giving it to them. We work hard and will continue to work hard to give you a disposable email address that works with any site or app. We hope to help give you back the control of deciding who you want to give your personal info to. Temporary emails are perfect for any transaction where you want to improve your online privacy. Use them when you buy or sell Bitcoins or trade cryptocurrency, at exchanges, or locally. They can be used for QA tes...

Dr. Elmi Zulkarnain Osman. The Award Winning Trainer With The Right Humour.

Dr. Elmi Zulkarnain Osman – an award-winning educator, a popular corporate trainer and a highly paid Malay English Language Coach started his career as a teacher in a government school in Singapore before becoming a lecturer in a government-based institute. Throughout his career with the Singapore Public Service, Dr. Elmi has already been acknowledged as an accomplished public speaker and a motivational speaker known for his high energy delivery and humorous approach. He is also well known in the grassroots circle as an experienced Chief Facilitator and an accomplished Forum Moderator. Upon completing his PhD in Educational Leadership with Trident University International in 2018, he and a few like-minded friends decided to set up Elemantra Training Consultancy. A consultancy that has been delivering their promise to deliver an “enriching experience every time”. As the CEO and Principal Trainer at Elemantra Consultancy, Dr. Elmi is very much known for his exceptional communication ...