Social Spreadsheet

  • Juan José Jara Laconich
  • Fabio Casati
  • Maurizio Marchese
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7977)


Social media data is growing exponentially, to the point where it is already hard to analyze. Consequently, there is a need to increase the number of people analyzing this data, to make sense out of it and, if possible, react to it. However, accessing this data is not simple because it is behind a knowledge barrier, which can only be overcome either with learning or with money. To considerably lower this barrier, we implemented the Social Spreadsheet, which is a spreadsheet template that we extended with functions that make simple the retrieval of social media data. Moreover, the collected data is ready to be analyzed by end-users, who can use formulas, custom functions, charts, and other commonly known spreadsheet features to create visualizations similar to the ones offered by commercial applications. To validate our work, we demonstrate how end-users can easily implement the same dashboards as the ones offered by popular social media analysis tools.


Spreadsheet-based Applications Social Media Analysis End-user 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Social Media Analytics, From Data to Deliverables,
  2. 2.
    Socialbakers: Social Media Marketing, Statistics & Monitoring Tools,
  3. 3.
    Sprout Social: Social Media Management, Social CRM for Business,
  4. 4.
    NodeXL: Network Overview, Discovery and Exploration for Excel,
  5. 5.
    Mackay, H.: Information and the Transformation of Sociology: Interactivity and Social Media Monitoring. tripleC-Cognition, Communication, Co-operation 11(1), 117–126 (2012)Google Scholar
  6. 6.
    Hansen, D.L., Rotman, D., Bonsignore, E., Milić-frayling, N., Rodrigues, E.M., Smith, M., Shneiderman, B., Capone, T.: Do You Know the Way to SNA?: A Process Model for Analyzing and Visualizing Social Media Data. Group 56(3), 1–10 (2009)Google Scholar
  7. 7.
    Thackeray, R., Neiger, B.L., Hanson, C.L., McKenzie, J.F.: Enhancing promotional strategies within social marketing programs: use of Web 2.0 social media. Health Promotion Practice 9(4), 338–343 (2008)CrossRefGoogle Scholar
  8. 8.
    Chi, E.H., Riedl, J., Barry, P., Konstan, J.A.: Principles for information visualization spreadsheets (1998)Google Scholar
  9. 9.
    Ballinger, D., Biddle, R., Noble, J.: Spreadsheet visualisation to improve end-user understanding. In: Proceedings of the Asia Pacific Symposium on Information Visualisatio, vol. 24, pp. 99–109. Australian Computer Society, Inc. (2003)Google Scholar
  10. 10.
    Hoang, D.D., Paik, H.Y., Benatallah, B.: An analysis of spreadsheet-based services mashup. In: Proceedings of the Twenty-First Australasian Conference on Database Technologies, ADC 2010, vol. 104, pp. 141–150. Australian Computer Society, Inc., Darlinghurst (2010)Google Scholar
  11. 11.
    Kongdenfha, W., Benatallah, B., Vayssière, J., Saint-Paul, R., Casati, F.: Rapid development of spreadsheet-based web mashups. In: Proceedings of the 18th International Conference on World Wide Web, WWW 2009, pp. 851–860 (2009)Google Scholar
  12. 12.
    Scaffidi, C., Shaw, M., Myers, B.: The 55M End-User Programmers Estimate Revisited. Technical Report February, Carnegie Mellon University (2005)Google Scholar
  13. 13.
    Saint-Paul, R., Benatallah, B., Vayssière, J.: Data services in your spreadsheet? In: Proceedings of the 11th International Conference on Extending Database Technology: Advances in Database Technology, pp. 690–694. ACM (2008)Google Scholar
  14. 14.
    Research and Analysis of the Facebook & Mobile App Ecosystems,
  15. 15.
    PageLever: Analytics & Social Marketing Tools for Facebook Pages,

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Juan José Jara Laconich
    • 1
  • Fabio Casati
    • 1
  • Maurizio Marchese
    • 1
  1. 1.Dept. of Information Engineering and Computer ScienceUniversity of TrentoPovoItaly

Personalised recommendations