Convert Excel97 to MySQL using an API

Use our API to convert your Excel 97-2003 (.xls) data to MySQL

Convert to
POST https://dataconverter.io/api/v1/convert/xls-to-mysql

After signing up and verifying your email, you will be able to create an API Token in your account settings.

Headers
  • Authorization (required) Bearer <<YOUR_API_TOKEN_HERE>>
Request Body — (multipart/form-data)
  • file (required) string <binary>

  • uploadSettings

    object 
    {
  "sheetName" : "Sheet1",
  "startingRow" : 0,
  "lastRow" : -1,
  "startingColumn" : 0,
  "skipEmptyRows" : true,
  "fieldNamesInFirstRow" : true,
  "evaluateExpressions" : true,
  "useSheetColumnCount" : false
}

  • downloadSettings

    object 
    {
  "tableName" : "bookstore",
  "pretty" : true,
  "dropTable" : true,
  "checkIfDropTableExists" : true,
  "checkIfTableNotExists" : true,
  "defaultBigIntegerPrecision" : 20,
  "defaultBigDecimalPrecision" : 20,
  "defaultBigDecimalScale" : 5,
  "useInferredType" : true,
  "sqlScriptType" : "DDL_AND_DML",
  "sqlInsertType" : "INSERT"
}
Request Sample

curl -X POST "https://dataconverter.io/api/v1/convert/xls-to-mysql" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.xls;type=application/vnd.ms-excel" \
-F "uploadSettings={\"sheetName\":\"Sheet1\",\"startingRow\":0,\"lastRow\":-1,\"startingColumn\":0,\"skipEmptyRows\":true,\"fieldNamesInFirstRow\":true,\"evaluateExpressions\":true,\"useSheetColumnCount\":false};type=application/json" \
-F "downloadSettings={\"tableName\":\"bookstore\",\"pretty\":true,\"dropTable\":true,\"checkIfDropTableExists\":true,\"checkIfTableNotExists\":true,\"defaultBigIntegerPrecision\":20,\"defaultBigDecimalPrecision\":20,\"defaultBigDecimalScale\":5,\"useInferredType\":true,\"sqlScriptType\":\"DDL_AND_DML\",\"sqlInsertType\":\"INSERT\"};type=application/json" \
--output converted.sql
Show All APIs