20110122

Zoho Reports

"Zoho Reports is an Online Reporting and Business Intelligence service. The features offered by Zoho Reports specializes on providing in-depth, powerful and flexible reporting and analytical capabilities. It contains an in-built database grid inside, is optimized for reporting and analytical querying than just serving as a real-time online transactional database.

Having said the above, Zoho Reports still offers features like manual data addition, data upload, relational modelling, SQL support, collaboration, API etc., along with specialized reporting features which could be found suitable as an Online database for some of your application requirements. Users are requested to exercise judgement to decide on the suitability of Zoho Reports in such scenarios. You can import tabular data from the following file formats:

Excel Spreadsheets (.xls)
CSV (Comma Separated Values),
TSV (Tab Separated Values)
Any tabular data in text file format
HTML files
MS Access (.mdb) files
Web URL which generates data in CSV format
Zipped files in any of the above file formats (except .mdb files)

You can also copy-paste data from all the above file formats as well as from spreadsheets (Microsoft Office Excel , OpenOffice Calc, StarOffice) files to import the data into Zoho Reports..."


http://reports.zoho.com/home.jsp

20110109

The 70 Online Databases that Define Our Planet

"If you want to simulate the Earth, you'll need data on the climate, health, finance, economics, traffic and lots more. Here's where to find it..."

http://www.technologyreview.com/blog/arxiv/26097/#

Note: Although I stated I would no longer be posting data sets this was just too comprehensive and interesting to ignore.

Common Format and MIME Type for Comma-Separated Values (CSV) Files

"The comma separated values format (CSV) has been used for exchanging and converting data between various spreadsheet programs for quite some time. Surprisingly, while this format is very common, it has never been formally documented. Additionally, while the IANA MIME registration tree includes a registration for "text/tab-separated-values" type, no MIME types have ever been registered with IANA for CSV. At the same time, various programs and operating systems have begun to use different MIME types for this format. This RFC documents the format of comma separated values (CSV) files and formally registers the "text/csv" MIME type for CSV in accordance with RFC 2048..."

http://tools.ietf.org/html/rfc4180

Google-Refine

"Google Refine is a power tool for working with messy data, cleaning it up, transforming it from one format into another, extending it with web services, and linking it to databases like Freebase."

"Google Refine is NOT for entering new data one cell at a time. It is NOT for doing accounting. Google Refine is for applying transformations over many existing cells in bulk, for the purpose of cleaning up the data, extending it with more data from other sources, and getting it to some form that other tools can consume..."


http://code.google.com/p/google-refine/