Convert CSV to Excel97 using an API

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

Convert to

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

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

{
  "fieldSeparator" : ",",
  "allowMultiLineText" : true,
  "allowQuoteInField" : false,
  "fieldNamesInFirstRow" : true,
  "startingQuote" : "\"",
  "endingQuote" : "\"",
  "lineSeparators" : "\\n,\\r\\n,\\r",
  "trimFields" : true,
  "skipEmptyRows" : false,
  "charset" : "UTF-8"
}

downloadSettings

object

{
  "sheetName" : "Sheet1",
  "firstRowIndex" : 0,
  "firstColumnIndex" : 0,
  "autofitColumns" : false,
  "autoFilterColumns" : false,
  "fieldNamesInFirstRow" : true
}

Request Sample


curl -X POST "https://dataconverter.io/api/v1/convert/csv-to-xls" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.csv;type=text/csv" \
-F "uploadSettings={\"fieldSeparator\":\",\",\"allowMultiLineText\":true,\"allowQuoteInField\":false,\"fieldNamesInFirstRow\":true,\"startingQuote\":\"\\\"\",\"endingQuote\":\"\\\"\",\"lineSeparators\":\"\\\\n,\\\\r\\\\n,\\\\r\",\"trimFields\":true,\"skipEmptyRows\":false,\"charset\":\"UTF-8\"};type=application/json" \
-F "downloadSettings={\"sheetName\":\"Sheet1\",\"firstRowIndex\":0,\"firstColumnIndex\":0,\"autofitColumns\":false,\"autoFilterColumns\":false,\"fieldNamesInFirstRow\":true};type=application/json" \
--output converted.xls