How do I get the Table Spreadsheet Macro for Confluence to import an almost 18,000Kb excel file?

Question

Building page in Confluence and want to use the Table Spreadsheet Macro to allow the team to view/edit a large excel file verses emailing to everyone or them emailing the changes asking me to make them.

Will import smaller files just fine but the page itself is timing out before the file is loaded.

Stiltsoft support · Answer

Hi @Tiffany Myers ,

Indeed as @Carla Ann Rowland has explained, your file is just too big to be processed both by your browser and by Confluence itself. We understand the case but, unfortunately, Confluence wasn't designed to serve as a database.

The only workaround will be to split your file into several smaller files and store them on different pages as different attachments.

Carla Ann Rowland · Answer

Hi Tiffany:  There is a size setting for attachments in confluence so I need more information before I can help you.

1) How is the excel file configured as a spreadsheet or CSV?

Is the file attached to the page in confluence?

2) Are you getting any error messages.

These information might help:

When a file is uploaded, Confluence will attempt to extract and index its text. This allows people to search for the content of a file, not just the filename. This process is quite memory intensive and can cause out of memory errors when very large files are uploaded. Confluence has a number of safeguards to prevent this happening:

* If the uploaded file is larger than 100 MB, Confluence will not attempt to extract text or index the file contents. Only the filename will be searchable.
* If the uploaded file is one of the following types, Confluence will only extract up to:* 1 MB of text from Excel (.xlsx) and PowerPoint (.pptx)
* 8 MB of text from PDF (.pdf)
* 10 MB of text from other text files (including .txt, .xml, .html, .rtf etc)
* 16 MB of text from Word (.docx)

Note that this is based on the size of the file when it's uncompressed. As .xlsx and .docx files are compressed, text extraction may fail even though the size of the file appears to be under the limit.

* If the text extracted from the file was greater than 1 MB, it will be searchable, but Confluence will not show this text as an excerpt with the search result.

If Confluence stops extracting text, only a portion of the file's content will be searchable.