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 insert table with data?

Kyrylo Khatsko

i want to use syntax:

|| x || y ||
| a | b |

to insert ALOT data. And this working only for first line.

What i should do?

Accepted answers

All comments

Jeremy M

Dear Kyrylo,

You could use a tabular CSV or Excel to import alot of data. Is this an option?

Kyrylo Khatsko

can you provide more details?

Jeremy M

Dear Kyrylo,

You could for example copy all the data from your Excel sheet into a Confluence page.

For CSV you would need This plugin

That add-on will make it possible to enter data using comma seperated values (CSV).

You can also import data to Confluence using other ways;

https://confluence.atlassian.com/doc/import-content-into-confluence-191141.html

Friendly Regards,

Jeremy

Kyrylo Khatsko

so ... Atlassian team removed absolutely simple and good syntax.

And asking me to use a plugin?

I need to spend a working day to only ask permission to setup plugin.

I really prefer to use built in features, like syntax. I can parse text to any format.

Dirk Janssen_n5otkf

Copying and pasting from Excel (on MacOS) worked like a charm for me. So I would create a csv file instead (using commas instead of |), read the csv into excel, copy the range, paste into Confluence.

Katerina Kovriga _Stiltsoft_

You may also consider using the Table from CSV macro (Table Filter and Charts for Confluence app).

You'll be able to transform your CSV attachments into Confluence tables and connect your Google Sheets (Google Drive) directly via its URL. It is more convenient, especially for big tables.

Tim Smolders

||header||header||
|row|row|
|row|row|

USED to work. Now it doesn't (new editor).
For me, copy pasting data into Excel FIRST, and then copy pasting from Excel to Confluence/Jira works to paste as table data.

Katerina Kovriga _Stiltsoft_

Hi there,

As this thread 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&edit mode.

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

Ondrej Brablc

What a productivity booster ;-) Thanks for tip anyway.

Stiltsoft support

An update ->

Please check out two additions to our spreadsheet family - Spreadsheet from Table and Table Spreadsheet Include macros.

The first one turns manually created and macro generated (Jira Issues, Page Properties Report) tables into fully functional Excel-like spreadsheet. The second one - helps to reuse parts of your sheets across your Confluence instance.

Hope you may find it useful.

nmz787

pasting from Excel worked perfectly! (MS Windows)

NoamN

You can do it with this Python code:

import pandas as pd

def df_to_jira_table(df: pd.DataFrame) -> str:
    def to_str_not_empty(value) -> str:
        white_space = " "
        return str(value) or white_space

    headers = df.columns.tolist()
    jira_table = "||" + "||".join(headers) + "||\n"
    for row in df.itertuples(index=False):
        jira_table += "|" + "|".join(map(to_str_not_empty, row)) + "|\n"
    return jira_table


df = pd.read_csv("example.csv")
print(df_to_jira_table(df))

EBH: Gergely Szilas

Hi!

Copy and paste from Excel to Confluence table on Windows worked fine for me in 2024.

But today it does not work. Do you know any changes regarding this feature?

If not then what can be the reason of this?

Thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

table

table-filter

table-filter-and-charts

table-spreadsheet

table-filter-charts-spreadsheets