The macro "Table from CSV" crashes for large CSV file

[Ramana]

I have a CSV file of size 8MB and has a list with 14000 entries. When I enter the URL in the "Table from CSV" macro, the macro simply stops responding and also the page crashes. What is the limitation on the file size that can be handled by Confluence? 

[Andy Gladstone · Accepted solution]

@Ramana welcome to the Atlassian Community. The problem you are experiencing here is not related to the file size, but related to the sheer number of lines you are trying to add to a Confluence page. Adding a table with 14,000 rows of data will likely crash the rendering of the page due to the length that such a page would be when displayed in a browser. 

The Macro you are referring to is a third party App produced by Stiltsoft. The documentation lives here, and i suggest you contact their support to see what the max table size for this macro to render is.

I hope this helps.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Ramana,

As usual, the file limit for the Table from CSV macro is 10 Mb. But even 8 Mb with such big number of rows can be a little too much for Confluence Cloud that was initially supposed to serve as a kind of a Wiki and not a fully functional database.

If your page crashes as well, it means that your browser can’t process such data as well.

[Bill Logan]

Do you have a recommendation for how to put a large table and make it easily sortable in Confluence ?

[Stiltsoft support]

As @Katerina Rudkovskaya _Stiltsoft_ has mentioned before, Confluence initially was not designed to serve as a database.

If your table comes close to the described limitations, it is better to host it somewhere else (AWS, for example).