Take control of large CSV datasets and utilize SQL to explore what is within
Are you more comfortable working with databases than raw CSV files? Unlock the power of SQL queries by
converting your CSV files into a SQLite database. This product is extremely unique in the
marketplace. Data scientists and academics rejoice over this functionality!
Transforms CSV data into a SQLite.db file
10+ built in parameters to help transform the data
API Design allows you to pass a local file, simple CSV string, or Web URL
Extendable to external APIs by passing credentials or OATH
Full Documentation and example usage
You must have an API token to call our APIs. You are automatically assigned one upon registering and confirming your email.
See our tutorial: Two Methods of API Authentication and
Example Use below that demonstrate passing your token to our server.
You must substitute your token found in the Account page in place of [YOUR TOKEN]. Also, use your data file name instead of [YOUR FILE], i.e. invoices.csv.
All conversion APIs require the infile parameter since it is the data you are converting. Note that to read from an S3 bucket that requires authorization, you must pass both username and password parameters, and the URL must start with s3://.
There is a 200MB limit on input. You may however zip your input file and use it for infile.