Supported File Formats

• XML

• CSV

• XLSX

• XLS

• JSON

• TXT

Requirements

This recommendation is applicable to the following data format

• Excel files XLS, XLSX

• Google Sheets

• CSV (Comma Separate Files), TSB (Tab Separated Files), Text files

Header

The first item of the file must be the header

id,name,location
001,John,North America
002,Eric,Brazil

Transformation Result

The data transformation will have the following JSON result

[
  { "id": 001, "name": "John", "location": "North America"},
  { "id": 002, "name": "Eric", "location": "Brazil"}
]