Web services for converting data from one format to another. The converters accept data as a query parameter named url. There's already CORS support and JSOP (add callback parameter to the URL). Empty column names will be auto-generated with column_1, column_2, etc. Duplicate column names will have _n added as well. For instance, two columns with name date will be date_1, date_2.
User stories are on Google Docs, if you want to add more, please file an issue.
Please bugs for any issues you see.
Converter automatically detects mime-type, if your file's mime-type is not "text/csv" or "text/comma-separated-values", add type=csv
to the url.
Example with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/csv/simple.csv&type=csv
Example with JSONP - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/csv/simple.csv&callback=callback
If your file's mime-type is not "application/excel", "application/vnd.ms-excel", or 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', add type=xls
to the url. If your file is an xls file, add type=xls&excel_type=xlsx
.
Example with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/xls/simple.xls&type=xls
Example of xlsx file with type - http://converter.dev.okfn.org/api/convert/json?url=http://resources.opendatalabs.org/u/nigelb/data-converters/xls/simple.xlsx&type=xls&excel_type=xlsx