Convert JSON to Excel File (XLSX)

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

Parameters

Output Parameters

Parameter

Description

Example

File Content

The content of the result XLSX file.

It is the content of the result file.

Setup Parameters

Parameter

Description

Example

App

Select the app.

Plumsail Documents

Action event

Select an action from the Plumsail Documents bundle.

Convert JSON to XLSX

Account

To allow your zaps 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.

Configure Parameters

Parameter

Description

Example

Source JSON

Specify raw JSON here or extract a JSON file content from other apps like:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

Zapier 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.

Specify one of the 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 File action, or apply raw JSON.

Convert JSON to XLSX example