How to import JSON into Confluence without installing an app?

[Clarie Dubois]

Hi everyone, I’m working with a JSON file that contains nested data (for example, arrays or objects inside each record) and I’d like to display it directly in a Confluence table.

Is there any built-in way or macro to do this without installing an app? If not, which apps would you recommend for importing JSON directly into Confluence? Any options would be appreciated.

I’m looking for a solution that keeps the structure and avoids preprocessing outside Confluence.

Thanks in advance for your help!

[Stiltsoft support]

Hi @Clarie Dubois

You may also try the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

Please take a look at the Table from JSON macro - it will help your case. Besides, you'll be able to filter, aggregate, and calculate your recreated JSON table with the help of our other macros.

If you are not familiar with the app, please book a live call with us. And if you have any further questions, don't hesitate to contact our support directly. 

[Katerina Rudkovskaya [Stiltsoft]]

@Clarie Dubois,

In the near future, as part of a major update to Table Filter, Charts & Spreadsheets for Confluence (transitioning to Atlassian’s latest cloud platform and obtaining the Runs on Atlassian badge), there will be a change in data import functionality: 

CSV/JSON import via URL will be moved out of the main app due to platform-specific constraints. However, it will remain available to all customers for free through a fully compatible companion app — Live Tables from CSV & JSON, developed and maintained by our team.  

This app allows you to import CSV, TSV, or JSON not only directly from attachments, but also from URLs, connect external sources like APIs or Google Sheets, and automatically keep data updated.

[Brant Schroeder]

@Clarie Dubois You will need a marketplace app to import JSON.  There are a couple to choose from.  You can always try a paid app for free.  Here are two to take a look at:

https://marketplace.atlassian.com/apps/197/advanced-tables-for-confluence?hosting=cloud&tab=overview 

https://marketplace.atlassian.com/apps/1238229/simple-table-for-confluence?hosting=cloud&tab=overview 

[Mia Tamm _Simpleasyty_]

Hi @Clarie Dubois You’re right. Confluence doesn’t have a built-in way to import JSON (especially with nested fields) without an app. That’s exactly the challenge we wanted to solve with Simple Table.

With Simple Table for Confluence App, you can import a JSON file directly (nested arrays, objects, etc.) and the app will keep the structure intact, so you don’t need to flatten or preprocess the data outside Confluence. You can then display it in a table, expand nested fields, and even combine it with calculated columns or other display options.

You can see an example of how nested JSON fields are handled here.

It’s free to install, so you can try it out and see if it works for your case.

— Mia Tamm from Simpleasyty