Analyzing social media such as Twitter and facebook takes much time and effort.
Using Google spreadsheet is one of solution.
Link in below there are 5 template to analyze social media.
http://mashable.com/2012/02/09/social-media-analytics-spreadsheets/