Documentation › Convert JSON to XLSX

Convert JSON to XLSX

Converts JSON to an XLSX file with the help of Make.

Parameters

Output Parameters

Parameter

Description

Example

File Content

The content of the result XLSX file.

It is the content of the result file.

Input Parameters

Parameter

Description

Example

Connection

To allow your scenarios to get information from and send it to Plumsail Documents, you need to create a connection.

For more information on how to create a connection to Plumsail Documents, see the online Help.

Input type

Defines the source of the HTML.

JSON File or Raw JSON

Source JSON

The option depends on the Input type. You can specify raw JSON here or extract a JSON file content from other apps like:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

List of apps

The action supports JSON in the following formats:

[
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
]

--------------------------------------

{
  "data": [
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
  ]
}

--------------------------------------

{
  "prop1": {
    "prop2": {
      "prop3": [
        {
          "prop": "value"
        },
        {
          "prop": "value"
        }
      ]
    }
  }
}

Mappings

Specify XLSX column types and names corresponding to the JSON property.

The result XLSX column will have this type and a new name. If not specified, the type and name will be inferred from the column values.

Delimiter

Delimiter of columns. By default it’s a comma.

You can select from the following default values: Comma, Semicolon, Tab or Pipe.

Path to JSON array

Specify the property with JSON array explicitly.

Define the path to the array in the JSON to process complex objects like the following:

{
  "data": [
    {
      "prop": "value"
    },
    {
      "prop": "value"
    }
  ],
  "prop1": "value1",
  "prop2": "value2"
}

Locale

The locale that will be applied to the source document.

Specify the locale in order to correctly parse currencies, dates and other depending values.

Example

Download a source JSON file and use the output in the Convert JSON to XLSX action, or apply raw JSON.

Convert JSON to XLSX example