Transform
Convert data between formats like XML, JSON, CSV, HTML, and XLS to enable compatibility across systems and services.
Actions
-
XML to JSON: XML to JSON converter
-
JSON to CSV: JSON to CSV converter
-
CSV to JSON: CSV to JSON converter
-
JSON to HTML: JSON to HTML converter
-
JSON to XML: JSON to XML converter
-
XLS to JSON: XLS to JSON converter
Note: JSON consists of 6 data types, string, number, boolean, null, object, and array. As JSON does
not have a Date type, it encodes dates as ISO 8601 strings. Hence, for the XLS to
JSON action to interpret dates correctly, the 'Date' or 'Time' data-type field should
always have a value in DateTime format or the column should be converted into a 'String'
data-type.