IU-DATA

JsonToXlsx



1 - Presentation & features

This add-on is a complete tool that you can integrate to your FileMaker solutions. JsonToXlsx lets you design native, fully formatted Excel (.xlsx) export templates directly inside FileMaker, then generate ready-to-use spreadsheets from your data in a single click, without Microsoft Excel or any third-party plugin installed on the client machine.

In addition, this add-on provides a visual, no-code Template Generator that lets you build the exact layout of your future Excel file — headers, merged cells, colors, frozen panes, column widths, auto-filters and zebra striping — and reuse that template for every export. The generated layout is stored as a portable JSON definition that FileMaker fills with your own data at export time.

Main features :


2 - Installation

2.1 Automatic

To make it quicker and easier for you, IU-DATA provides a small FileMaker solution beside each add-ons that directly install the add-on inside the right directory of your computer.

  1. Run the file

  2. Click on Instal the Add-on

  3. In FileMaker Pro, open the solution in which you want to add the Add-On

  4. In layout mode, open the left side panel on the Add-ons tab, click on the add button  

  5. Under the IU-DATA category, select JsonToXlsx then click on Choose  

  6. Drag and drop the JsonToXlsx add-on on the layout

2.2 Manual

  1. Close FileMaker Pro

  2. Copy the IUD_JsonToXlsx folder to the following directory :

     - macOs : ~/Library/Application Support/FileMaker/Extensions/AddonModules/
     - Windows : AppData\Local\FileMaker\Extensions\AddonModules\
    
  3. In FileMaker Pro, open the solution in which you want to add the Add-On

  4. In layout mode, open the left side panel on the Add-ons tab, click on the add button  

  5. Under the IU-DATA category, select JsonToXlsx then click on Choose  

  6. Drag and drop the JsonToXlsx add-on on the layout

2.3 Configuration

The main configuration and customization instructions can be found inside the add-on's script and custom function headers. Scripts and custom functions also have a whole series of information useful for the add-on configuration. For example purpose, a script set and a sample dataset are also provided.

Please note : If your database on which you want to install the add-on is hosted with FileMaker Server. You might need to refresh the globale calculation field z_IUD_JSONTOXLSX::gct_WV_FinalCode. Otherwise the webviewer that contains the add-on will remain empty. To refresh this field, you can set the field z_IUD_JSONTOXLSX::WV_HTML by it's own value inside a script that is launch at the start of your application.


3 - Structures

3.1 - Tables

3.2 - Scripts

All JsonToXlsx scripts are contained in the IUDATA - JSON To XLSX script folder.

The description of scripts and parameters can be found in each script header.

3.3 - Custom functions

No custom function in this add-on.

3.4 - Value lists

No Value list in this add-on.


4 - Dependencies

ExcelJS v4.4.0 (c) ExcelJS contributors (MIT License)

https://github.com/exceljs/exceljs


5 - Compatibility

Operating systems :

FileMaker :

Claris FileMaker WebDirect :


6 - End User Licence Agreement

Important Note: Please read this EULA carefully. Downloading, installing, using or modifying this add-on signifies that the end user and their organization accept this EULA.

Definitions :

Contract terms :
IU-DATA authorizes the end user and his organization or household to use, modify, copy the add-on at their convenience. IU-DATA authorizes the end user and his organization to use for commercial purposes the add-on, when the add-on is an integral part of a solution whose spectrum of use is much wider than that defined by the functionalities of the add-on alone. On the other hand, IU-DATA does not authorize the end user and his organization to use for commercial or distribution purposes the add-on, modified or not as a final product.

The end user and his organization / household have free assistance for a period of 2 months from the date of purchase of this add-on, for any questions related to the use and configuration of this add-on.
Full access to FileMaker sources as well as to the source code used in the web viewer gives to the end user and his organization / household full control over modifying this add-on. It is therefore natural that we cannot intervene free of charge on the add-on whose code has been altered compared to the original version that IU-DATA delivered. Likewise, IU-DATA cannot be held responsible for any malfunction of any libraries mentioned in paragraph 4 - Dependencies, as well as malfunctions of the add-on following use on an operating system or a FileMaker platform other than those mentioned in paragraph 5 - Compatibilities.

Contact :
For any questions, please contact us to this address: product@iu-data.com


7 - Credits

Creation and development :

Icon design :


8 - Change Log

01/08/2026 - JsonToXlsx v1.0.0 - 1st release



© IU-DATA 2026