Documentation
Quick Table Export turns the first table of a Confluence page into a real
spreadsheet, in one click.
Need help? Contact support
The first time: Allow access
The first time you click Quick Table Export, the panel does not export anything yet. Instead, Atlassian asks you to allow the app to access Confluence on your behalf, with an Allow access button. Click it and confirm. The panel then starts again and exports the table.
This is needed because the app reads the page with your own Confluence permissions, never more: it can only read pages you can already open. Each person is asked once. Atlassian may ask again if a later version of the app needs new permissions.
If you do not allow access, the app reads nothing and exports nothing. The request appears again the next time you click Quick Table Export, so you can allow it later.
Getting started
Open any Confluence page that contains a table. Under the page title, click Quick Table Export. The spreadsheet downloads immediately. A panel opens showing what was read, with a Download as CSV button if you also need a plain text version.
What the Excel file contains
Dates are real Excel dates, written as year-month-day so they cannot be read the wrong way round, and they sort and filter like dates. Numbers are real numbers, decided column by column: a column is only converted when every one of its values can be read the same way, so a column that mixes conventions stays as text rather than risking a wrong amount. Currency symbols are kept as a display format, so the value stays a number you can add up. Reference codes such as 0012 stay text and keep their leading zeros. Merged cells are unfolded: a value merged across several rows is repeated on each of those rows, so filters and pivot tables see every row, while a value merged across several columns stays in its first column. Nothing is merged in the Excel file, because merged cells break sorting and filtering. A link keeps its label followed by its address in parentheses, so you do not have to go back to Confluence to find it. The file opens ready to read: columns already come at the width of their content, and when the table has a header row it is bold and stays visible while you scroll.
What the CSV file contains
Raw values, at the RFC 4180 standard, for feeding another system rather than for reading. Numbers lose their currency symbol and thousands separator, dates stay year-month-day, and text keeps its leading zeros. If you want a file to read, use the Excel one.
Limits
Opening the panel exports the first table of the page. When the page holds more than one table, the panel lists the others with their size and a button to download each of them. Exports stop at 5000 rows and 200 columns, and the panel warns you when a table was too large. When a table contains macros, the panel says so, because a macro produces its content when the page is displayed and cannot always be reproduced in a file.
Subscription
The app runs on the subscription held by your Confluence site. If the subscription stops, the panel says so and nothing is exported. A Confluence administrator can restart it in Settings, then Apps, then Manage apps.
Support
Use the support contact form, or write to contact@webelisys.fr. Include your Confluence site address and, if you can, the page where the problem happened.