nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to copy data from excel to confluence in table format

Prabhamani

I have a table in excel, but when i copy the data from excel and paste it in confluence page, its taking the data as an image. However, i would like to add the data as a table in confluence.

I have a big table, and now i dont want to type everything again in confluence as I would like to continue to track it in confluence rather than excel.

Could anyone share how this can be done ?

Accepted answers

All comments

shetty

Hi @Prabhamani

refer this page https://confluence.atlassian.com/confcloud/office-excel-macro-724765234.html

Thomas Schlegel

Hi @shetty ,

copy & paste from Excel works fine for me. I do the following:

create an empty table in Confluence with the number of rows your excel table has
Select the data in Excel and copy
Put the cursor into the first cell and paste

shetty

@Thomas Schlegel

Will try

Thank You

Patrick Geremia

did not work

Katerina Kovriga _Stiltsoft_

You can also use the Table Filter and Charts for Confluence app: it contains the CSV macro and you will be able to import tables easily from CSV or TSV data sources (URL or attached files).

Max Foerster - K15t

Hey @Katerina Kovriga _Stiltsoft_

In an effort to maintain transparency in the Community, please be sure to clearly identify this as your company's application and state your affiliation with the company when responding to Community posts. Please have a good read-through of the other Atlassian Community online guidelines for Marketplace vendors and Solution Partners.

Thank you!

Best, Max

Katerina Kovriga _Stiltsoft_

Hi @Max Foerster - K15t ,

Thanks for the tip - got my profile name updated.

T Foster

Is there really not a more intuitive way of moving something as basic as a table?

Everyone is well versed in creating documents in Microsoft Office products. The default behaviour should be for a list created in Excel to paste as a table in Confluence. It's completely impractical to create a table of hundreds of lines in order to paste a table from another application.

As with a lot of these online applications, the functionality is shoehorned in making it a bespoke task, rather than supporting the majority application seamlessly.

Is there anyone who doesn't expect a seamless copy and paste operation to just work?

Kenny_zdmtv4

Legacy editor helped. not perfect.

ripudaman.ubs

Try Copy pasting the table in Power Point first and then from Power point to confluence page, worked fine for me, I use this way out

ripudaman.ubs

Try Copy pasting the table in Power Point first and then from Power point to confluence page, worked fine for me, I use this way out

Andy Tatham

**UPDATED RESOLUTION**

To resolve another issue, I just ran the "Restore Settings to their Original Defaults" option on Chrome. That resolves the problem entirely (no work-around needed).

However, if that doesn't work, the work-around below is still functional:

*************

This is a bug/feature that must have just started- As you stated, copied Excel cells now paste into Confluence as a picture instead of text (I'm using the Chrome browser).

Here's the work-around I was able to use (instead of PPT):
1. Copy the table from Excel
2. Paste it into Word
3. Copy it from Word
4. Paste it into Confluence

This helps retain Excel's "text" when pasting into confluence.

Kannan S S

From the confluence "Insert table"
Copy the excel table and place the curser at the top left cell of the confluence table and paste

Steven McDowall

Yes @Kannan S S -- that works well. I think they must've improved the flow since it works basically as expected.

Andrew_8bc2sw

This only half works. I'm having to copy paste 1 or 2 rows at a time. No reason it does this. I've been able to do this with entire spreadsheets in the past.

Katerina Kovriga _Stiltsoft_

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence. You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

vsolutions

It's a Microsoft world :-(

I wanted to make the readers aware that it works perfectly in Open Office Calc.

If you copy from Open Office Calc and paste into an empty Confluence table then the pasted table is perfectly presented!

Oki__PolarisOffice_

@Prabhamani Why don't you directly attach your excel files to a confluence page instead of copying/pasting data?

Our app, Polaris spreadsheet allows you to embed an existing excel and CSV files in a confluence page and directly edit it.
It offers full editing capabilities for excel files and provides an advanced view mode that allows you to use filters, scroll, and find. Please check the details.
A month's free trial is available now!

Atlassian Marketplace

Jac_t1f958

Just make sure you don't have any merged cells in the source and it should paste ok.

Juan Fuentes_e5ts3x

This macro does not exist. I am looking for it and cant see it

Stiltsoft support

Hi @Juan Fuentes ,

Do you have the mentioned Table Filter and Charts for Confluence app installed for your instance? Can you see other macros that are provided by this app?

You may check, for example, Table Filter, Pivot Table, Table Transformer macros.

Update: you may also search not only for the Table Spreadsheet macro but for Spreadsheet from Table and Table Spreadsheet Include! Please check our spreadsheets' family here.

Now that you can transform manually created and macro generated (Jira Issues, Page Properties Report, etc.) tables into spreadsheets and widely reuse spreadsheets and their parts, your workday routine will be simplified even more.