Is there an easy way to create table a table with hundreds of rows?

[Hazel MM]

I'm trying to create a table with 100+ entries in Confluence. Is there an easy way to do this? 

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Hazel MM ,

Some 3rd party apps will be able to help you indeed, but you need to clarify the use case.

For example, I can suggest trying our add-on that is Table Filter and Charts for Confluence.

If you need Excel functionality, you may embed its Table Spreadsheet macro. You may also import existing xlsx and csv files to your spreadsheet not to start from the scratch.

If you have a precreated csv/json file and you need to show its contents in Confluence, you may use the Table from CSV/Table from JSON macros.

Further you'll be able to filter, calculate, aggregate and visualize your data.

[Shardul Juyal_Addteq_ · Accepted solution]

There are a couple of ways without any add-ons

Option 1: Create a 2*2 table and press tab for a few seconds. (Number columns can easily help identify which row is 100, and you can delete the rest)

Option 2: Copy 100 blank rows/columns from Excel/Google Sheets, and paste them in the page

[Brant Schroeder · Accepted solution]

@Hazel MM Welcome to the Atlassian community

If I have repeating values or something I can duplicate through an Excel funtion I will create the table in excel and copy it into Confluence.  Otherwise it is a manual process just like any other application.  There are some apps in the marketplace that enhance and improve table functionality.  I have not used any of them but you could also take a look there https://marketplace.atlassian.com/search?hosting=cloud&product=confluence&query=table