Help Centre › Building Processes
Write a JSON file of extracted documents to an Excel workbook, lists on linked sheets.
Add it to a process
In the process designer, open the Add step tab. Find Write documents to linked workbook under File & Folder › Read & Write, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Documents file (.json) | Yes | The JSON file that "Append to JSON file" filled, one extracted document per entry. |
| Workbook to write (.xlsx) | Yes | Enter the file path, or use a variable such as {folder::desktop::path}\documents.xlsx. |
| Main sheet name | No | Name of the main sheet. Leave empty to name it after the JSON file |
| Overwrite existing workbook | No | Replace the workbook if it already exists Default: off. |
See all File & Folder steps.