Qlikster the author of QlikView Excel Connector created another very nice and useful QlikView application – Loading Data Into QlikView from Google Spreadsheet API Using ClientLogin Authentication

The idea of application is to load data into QlikView from  excel spreadsheets hosted on Google Docs (GD) service. After spreadsheet is uploaded (or created) in GD he is converted to HTML format and using GD API QlikView applications can retrieve the content of the document in XML format.  To reach spreadsheet in Qlikster example is used user authentication and spreadsheet key. All operations for extracting data in QlikView from GD is achieved with using of JScript. After extraction is complete the data is stored in XML file locally and the result file is loaded in QlikView from script.

Good point of using GD is that the spreadsheets can be shared and many users may edit its content. This prevent the problem with many versions of the same excel file.

Unfortunately Google Docs have some limitations for spreadsheet  files – they must be with maximum size of 1Mb and each spreadsheet can be up to 256 columns, or up to 200,000 cells, or up to 100 sheets – whichever limit is reached first. There’s no limit on number of rows.

Qlikster provided in file sample GD account and spreadsheet that can be used to play with the application. To use your account and spreadsheet just edit details in Input section:

This is quick snapshot of the application:

Tagged as: cloud, Google Docs, qlikster, qlikview