by Flo Preynat

I will dedicate today’s post to something slightly out of the ordinary, as I’m not going to discuss some coding, or other jQuery plugin I have tested lately, but instead spend a few of my un-precious minutes on something which may be very helpful to you.


If you’re (like me) a twitter addict and you like sharing loads of good stuff with the ever-growing webdesign community on the now-famous birdy application, then on one or two occasions, you MUST have found yourself looking for something YOU had tweeted about.
Make your tweets searchable in google cal


It’s on the tip of your tongue, you know it, you’ve posted it on twitter a few months ago, but still, it ain’t coming back to you. If this has happened to you, and since it’s only a matter of days before your tweets become untraceable, you must have thought: “I need to get a backup of my tweets one of those days”.


Well this is what i thought of doing only a few days ago, and when I saw a number of tools advertising the possibility to integrate a backup of tweets into Google Calendar, i thought my alcohol-hit memory problems were past.


Unfortunately, i quickly found out that tools such Twistory could do very little if Google were to change their settings and change the behaviour of their calendar utility. I did look for alternative solutions but wasn’t able to find a working one.


I then decided to do this the hard way, i.e. manually. It doesn’t take neither a genius nor an hour to do this so I thought I would share it with you, bearing in mind that something automatic (with the folks from Twistory or others) is likely to come out very soon, and help you get this done in a more smooth and lazy-do-it-for-me manner.


Any way, talking is over. Here’s how I did import a backup of more than 700 tweets into my google calendar, in order to make them time-stamped and easily searchable.

Backup your tweets

Get one of those Twitter backup solution to extract all your tweets in one go. Be careful to do this before reaching the limit of 3200 tweets. I used for this Tweetake, third-party app which lets you backup your tweets but also your DM’s, favorites and more. I don’t have any preference as far as those tools are concerned. I’m in no way affiliated or sponsored by this particular one. It’s just Tweetake is the first one I have tried, you log in using Twitter’s OAuth system and it works straight away. Extract your tweets into a csv file. You will get something like this:


Use Tweetake to extract your tweets

Manipulate your CSV

Then it’s only a question of manipulating the CSV file to make it compliant to the Google Calendar importing tool. I can only encourage you to read the Help about CSV file, which you’ll find here. It states that the minimum requirements are a Subject AND a Start Date, but really you’d need more than that to make your backup a precise one. I replaced the ‘status text’ header by ‘Subject’, did some manipulating (text to columns) on the ‘status date’ to isolate date and time on the right format (as you can see below). And I copied and pasted a few columns to duplicate Start Date and Start Time to get End Date and End Time.


CSV file manipulation

Import your data into Google Calendar

This all done, you can log into your Google calendar, go to the settings panel, anc click on Calendars. Click on the import link and browse to your CSV, and you’re done. A minute or so later, all your tweets will be saved as single and time-stamped events in your calendar, and you will be able to search through them using the google search through my calendars functionality.


Your Tweets in Google Calendar


As I stated it below, while waiting that one of those third party services gets it right and makes it all easy for us, we can find a minute to do this manually, a few times a year.

My name is Flo Preynat and I am the freelance webdesigner and developer behind shoogle designs. I live in France and specialize in responsive web design. Give me a shoogle or get in touch with me on twitter.

Most Recent Posts

Special Recent Posts

Make Google Charts responsive

Make Google Charts responsive

March 19th, 2014

A quick blog post on how to make Google Charts play nicely in responsive mode. Nothing close to rock[...]

Codekit 2 : even more steroids for us web developers

Codekit 2 : even more steroids for us web developers

March 17th, 2014

I was on holiday when Bryan released the new version of Codekit and never had the chance to to check[...]

Open terminal from folder in finder

Open terminal from folder in finder

January 27th, 2014

A quick one nudged my way by Adrien Joly this morning. You can now open a terminal window from a [...]

A look back at Wordcamp Paris 2014

A look back at Wordcamp Paris 2014

January 22nd, 2014

I went to Wordcamp Paris last week. The event was held On Friday 17th January at MAS Paris and Satur[...]

Gruntjs Boilerplate: my dummy-proof step-by-step guide

Gruntjs Boilerplate: my dummy-proof step-by-step guide

January 14th, 2014

Right so I've made the leap. After quite a ride, and some cool adventures with Codekit, I've deci[...]


  1. Ali says:

    Thanks a lot! This works great.

    I just recorded and saved a macro that does all the manipulation, so now the whole process takes one click!