Convert Excel to TSV using an API

Use our API to convert your Excel 2007+ (.xlsx) data to Tab Separated Values

Convert to
POST https://dataconverter.io/api/v1/convert/xlsx-to-tsv

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
    {
      "fieldSeparator" : "\t",
      "fieldNamesInFirstRow" : true,
      "startingQuote" : "\"",
      "endingQuote" : "\"",
      "newLine" : "\\n",
      "nullValuePolicy" : "EMPTY_STRING",
      "emptyStringValuePolicy" : "QUOTED_EMPTY_STRING",
      "forceQuote" : false,
      "charset" : "UTF-8"
    }
Request Sample

curl -X POST "https://dataconverter.io/api/v1/convert/xlsx-to-tsv" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.xlsx;type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" \
-F "uploadSettings={\"sheetName\":\"Sheet1\",\"startingRow\":0,\"lastRow\":-1,\"startingColumn\":0,\"skipEmptyRows\":true,\"fieldNamesInFirstRow\":true,\"evaluateExpressions\":true,\"useSheetColumnCount\":false};type=application/json" \
-F "downloadSettings={\"fieldSeparator\":\"\\t\",\"fieldNamesInFirstRow\":true,\"startingQuote\":\"\\\"\",\"endingQuote\":\"\\\"\",\"newLine\":\"\\\\n\",\"nullValuePolicy\":\"EMPTY_STRING\",\"emptyStringValuePolicy\":\"QUOTED_EMPTY_STRING\",\"forceQuote\":false,\"charset\":\"UTF-8\"};type=application/json" \
--output converted.tsv
          
Show All APIs