XML
CSV
XLSX
XLS
JSON
TXT
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
The first item of the file must be the header
id,name,location001,John,North America002,Eric,Brazil
The data transformation will have the following JSON result
[{ "id": 001, "name": "John", "location": "North America"},{ "id": 002, "name": "Eric", "location": "Brazil"}]