Merge Reponses table and Excel document based on column names

[Praneeth Kumar]

Hi team,

I created a form in confluence using forms for confluence which when filled, the response goes into a separate response table in other page. I receive responses even in an excel format. The columns are same in both response table and excel sheet. Is there a way that I can see the Excel data in the response table. Please help. 

This will indeed help me with other confluence projects where I would need to do a bulk upload onto the responses table. 

[Katerina Kovriga _Stiltsoft_]

Hi @Praneeth Kumar

We can recommend you to try the Table Filter and Charts for Confluence app.

To import your Excel files to Confluence, use the CSV macro.

To merge the tables, use the Table Transformer macro. The default Merge preset will help you to combine tables with the same column names.

[Praneeth Kumar]

I am not able to find the table transformer macro in my server version. Is there any other possibility we can achieve this?

[Katerina Kovriga _Stiltsoft_]

Check if the Table Filter and Charts for Confluence app is installed on your instance - it is a separate plugin. If yes, then make sure that it is up-to-date (the Table Transformer macro is a rather old feature, but nevertheless it's always better to check).

What concerns standard tools, you can try to copy/paste Excel tables manually. Sometimes it goes well and sometimes you need to create an empty table of the required size and only then paste you info there.

If to talk about table merging, there are no any standard tools at all. Maybe besides the Page Properties Report macro, but I don't think that it will be suitable for your case. 

[Praneeth Kumar]

0