Merge Reponses table and Excel document based on column names

Question

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} · Answer

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_l563w8 · Answer

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

Praneeth Kumar_l563w8 · Answer