Searching a CSV and displaying the result on a page

Question

I have a CSV /  Excel file with over 150k rows. Each row is 4 columns, the first row being the field I wish to search. I cannot live display said document on the site but would like to have the ability to search a specific column for matching search results and return the entire rows as a result.

Is there any way to do this?

Basically, the excel / CSV contains over 150k error codes and their translations in basic English, and I wish to make the data searchable, but can't outright display the entire document, as it crashes confluence pages every time.

Danny Nolan · Answer

Yep I don't even need to display the contents, just make the data searchable and to return matching rows in a nicely formatted way

Stiltsoft support · Answer

Hi @Danny Nolan ,

In general, our Table Filter and Charts for Confluence app provides two ways to work with Excel/CSV files:

* Use the Table from CSV macro to connect your file as an url/attachment to your Confluence page and recreate a table from it. Then you may wrap this macro in the Table Filter macro and filter your table.
* Use the Table Spreadsheet macro. Import your existing file in CSV/Excel formats and continue to work with it using all the basic Excel features right in Confluence.

The only issue may be in the size of your file as you mention 150k rows. Confluence is not supposed to serve as a database, so you may experience memory browser issues and errors loading Confluence pages.

Sayed Bares [ServiceRocket] · Answer

@Danny Nolan Welcome to Atlassian community!

You can use REST APIs to create a page and supplying your csv dataset as a body to your page. Which should make your page searchable:

* https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-page/#api-pages-post

Alternatively, you can try third-party apps:

* https://marketplace.atlassian.com/search?hosting=cloud&product=confluence&query=csv

Hope it helps!