there may be additional tools needed to transform the data and achieve the desired results. The data would be converted to an easily comprehensible format.įinally by sorting the data rows and rearranging the columns we can get the desired tabular output as shown below.ĭepending on the JSON hierarchy, usage of nested objects, parent to child relationship, etc. Given the data structure, it is most efficient to use a “Text to Columns” tool in order to split the desired column as shown below.Īdd a “Cross Tab” tool to the workflow, and configure the settings as shown below. Choose the file format as JSON and enable the option for “Parse Value as String”. Let us begin with connecting the file using the Input Data tool.

Using Alteryx, this data can be converted into the tabular format for the ease of data processing. How to Convert JSON to Excel / CSV:Ĭonsider a JSON file whose preview is as shown below. By understanding the hierarchy, i.e., parent to child relationship, of a JSON file it is easy to convert it to a tabular display with Alteryx and export it to a desired output such as CSV, Excel, or a database.

Json to csv excel