Skip to main content

Importing twitter feed in google spreadsheet

Often I wanted to store my twitter feed or any other online feed into my google spreadsheets. Here is how to do it.

USING GOOGLE DOCS SPREADSHEET
Create a new blank spreadsheet. In the column A2 enter  

=ImportFeed(“http://twitter.com/statuses/user_timeline/princemishra1.rss”,”items title”,false,20). 

Replace "princemishra1" with your twitter username. 20 is the maximum number of updates you can see at any one time. The updates are cached by the google server, so you may see some delays.
USING EXCEL
Create a blank spreadsheet. Select Data -> From Web
This should open the New Web Query Window. In the address field enter

http://twitter.com/statuses/user_timeline/princemishra1.rss (Replace princemishra1 with your twitter username) and press Go. Excel will now fetch all your twitter updates. After the fetching has finished click on Import.
Now, you should have an excel sheet with your twitter updates. To fetch new updates, select Data -> Refresh All

Comments

Popular posts from this blog

On working remote

The last company I worked for, did have an office space, but the code was all on Github, infra on AWS, we tracked issues over Asana and more or less each person had at least one project they could call "their own" (I had a bunch of them ;-)). This worked pretty well. And it gave me a feeling that working remote would not be very different from this. So when we started working on our own startup, we started with working from our homes. It looked great at first. I could now spend more time with Mom and could work at leisure. However, it is not as good as it looks like. At times it just feels you are busy without business, that you had been working, yet didn't achieve much. If you are evaluating working from home and are not sure of how to start, or you already do (then please review and add your views in comments) and feel like you were better off in the office, do read on. Remote work is great. But a physical office is better. So if you can, find yourself a co-working s

Capture and compare stdout in python unit tests

A recent fan of TDD, I set out to write tests for whatever comes my way. And there was one feature where the code would print messages to the console. Now - I had tests written for the API but I could not get my head around ways to capture these messages in my unittests. After some searching and some stroke of genius, here's how I accomplished capturing stdout.

Todo lists are overrated

My tasks come from a variety of sources: 1) Tasks from emails  2) Meeting notes with details of people who participated  3) Project related tasks that can have a long format and can be tagged/ delegated  4) Scratchpad for unrefined ideas  5) Detailed documentation for completed technical tasks / ideas  6) FIFO list of high priority small daily tasks No one app has been able to map all the requirements above, and I have tried a lot of them! In my lifetime I’ve tried a dozen todo apps. In the beginning they all seem different, novel and special. Slick UI, shortcuts, tags, subtasks, the list goes on and on. But all our stories were the same: I start using the new app, then after awhile I stop using it. Up until the last week I thought the problem was in myself (you probably think so too). After all, David Allen seems to have figured this shit out. Also there are people leaving long 5 star reviews on every major todo list app, they discuss them on forums, recommend them to friends. But the