Download Tweets from Twitter: How To

It’s remarkably easy to download tweets from Twitter. You of course always have access to your Twitter updates via your own profile page, but once you’ve posted a few dozen it can be a hassle to scroll forever to review or capture them. Thankfully, you can do it very easily without an external application/website, or use of the Twitter API. All that’s required is a specially formatted URL string.

Download Tweets

There are all kinds of reasons why you might want to download Tweets. You might want to be able to keep a local copy to analyze the frequency or volume of your tweets and activity on Twitter; or import the XML and display it on your own website (though I don’t recommend this for SEO purposes because it technically counts as duplicate content). You might know someone who Tweets frequently and you don’t want to miss out on their content. You may need to download tweets for legal reasons, like being harassed or slandered on the net. You could be using a tool like Buffer to automate Tweets at specific times to reach your target audience. Whatever reason you have to download Tweets it’s remarkable simple to do.

Download Tweets: Save As

This is the most simple method to download Tweets. From your Twitter page, or the page of anyone else, simple tell your browser to ‘Save As’ and download the page. In Chrome the easiest way to do this is to right click on the page and click ‘Save As’. A dialog box will appear and you can name the download, and decide if you want to download the entire page or just as HTML.

Download Tweets: The better method

All you need to download tweets is a web browser and knowledge of a special address you can use in the address bar of your browser. Twitter will respond with a page full of data in the XML (extensible markup language) format. The syntax is simple once you know what Twitter expects. To tell the Twitter website you want to download tweets simply format your request like this:

http://twitter.com/statuses/user_timeline/account.xml?count=n

In order to use this request you’ll need to replace “account” with your username or the username name of the person who you want to download tweets for. You’ll also need to replace “n” with the number of tweets you want returned. If you want to download all of your Tweets you can view your total number of Tweets on your homepage and on your profile page. Simply note that number and replace “n” with that value. When done properly Twitter will respond with a properly formatted XML that looks like this:

Now just save the data by choosing File -> Save As, select the location and file name and save the file.

Keep a log of Tweets

What’s great about this method is that because when you download tweets with this method the XML can be easily imported into Excel. Again, this is remarkably simply to do by creating a new Excel file to import the downloaded tweets into. Create a new Excel file, select the “Data” tab, and select get external data. Then choose “From Other Data Sources -> From XML Data Import”. When the dialog box opens navigate to where you stored the download tweets files and import the contents. Tada! Now, in addition to the raw XML data you have a more user friendly way to view the download tweets file.

Of course your activity on Twitter can range from a random Tweet every couple of days, or it could be something you use as an over all social media engagement strategy that contains tons of Tweets relevant to your followers. This is where the “n” on the query string used earlier and the Excel file come in handy. As Tweets accumulate you can continue to download tweets any time you choose and simply continue to import the data into Excel.

More Twitter tips

If you’re looking for ways to maximize the impact of your Tweets, it’s all about timing. You can increase clicks by 200% with Buffer. It’s simple, effective, and available everywhere you Tweet.

If maximizing your Twitter reach is something of interest, look no further than Triberr. Every time you publish a new post, everyone in your tribe(s) will tweet it to their followers. You do the same for everyone in your tribe. This takes place automatically and extends the reach of your blog by exposing your content to an audience you’re not directly connected with – right now each post I write gets Tweeted to 497,810 people via the Tribes I’ve aligned with.

If this was helpful, if you can’t figure it out, or want more info on Buffer or Triberr you can always find me on Twitter: @PaulSpoerry!

About Paul Spoerry

I’m a groovy cat who’s into technology, Eastern Thought, and house music. I’m a proud and dedicated father to the coolest little guy on the planet (seriously, I'm NOT biased). I’m fascinated by ninjas, the Internet, and anybody who can balance objects on their nose for long periods of time.

I have a utility belt full of programming languages and a database of all my knowledge on databases... I practice code fu. Oh, I've also done actual Kung Fu, and have a black belt in Tae Kwon Do.

Comments

Great article, Paul, thanks. I’m wondering if you know of a way to download tweets by keyword or hashtag, not by account. Companies like TrendsMap obviously have access to this data, but I haven’t found m/any apps that can export tweets in bulk for data analysis.
Thanks in advance.

Thanks for the tip. I didn’t read the whole article, so it is good that you used headings to clarify content. I used the “save page as” option to download my tweets. Very helpful and a relatively easy way to save your tweets to your PC. Thanks