Quick Table Export Quick Table Export

Documentation

Quick Table Export turns a table of a Confluence page into a real Excel file, or all the tables of the page into one workbook.
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 two CSV buttons 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.

The panel offers two CSV buttons. CSV separates values with commas, for other software and databases. CSV for Excel in Europe separates them with semicolons and writes decimals with a comma, so the file opens correctly in Excel with European settings. In both files, a text cell that starts with =, +, - or @ gets an apostrophe in front of it, so no formula can run when the file is opened.

Earlier versions, comparison and selection

Every Excel file has a Source sheet with the page title, its link, the version number and the time of the export. When you download all the tables of a page as one workbook, the Source sheet also lists each sheet with the first row of its table and its number of rows.

The Download an earlier version button exports the table as it was in a past version of the page. The Compare with an earlier version button downloads the current table with an extra Changes sheet that lists the rows added, the rows removed and the cells modified. Rows are matched by their first column when it has no empty cell and no duplicate, and otherwise by their content.

To export one table among several, select some text inside it, then open the ... menu, choose Apps, then Export this table. The whole table is exported, not only the text you selected.

Rovo agent

On sites where Rovo is turned on, Quick Table Export adds a Rovo agent. Open Rovo Chat on a page, choose the Quick Table Export agent, and ask it to show a table of the page, or what changed in a table since an earlier version. The agent only reads the page you have open, with your own permissions, and never changes anything.

Rovo cannot hand you a file: for the Excel file, click Quick Table Export under the page title. On very large pages (above about 5 MB of content), Rovo does not tell the app which page is open, so the agent cannot read it; the panel under the page title still works up to 15 MB. Questions to the agent count against your Rovo credits.

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, and a Download all tables as one workbook button that puts every table in one Excel file, one sheet per table. Exports stop at 10,000 rows and 200 columns, and the panel warns you when a table was too large. A page whose content exceeds 15 MB is not exported, and the panel says so. A table, or a set of tables, too large to send to your browser in one go is not downloaded either: the panel says so, and the other tables of the page stay available. This only happens with very long texts in the cells. Each Confluence site can send the app up to 60 requests per minute, counting exports, version lists and comparisons. Past that, the panel tells you how many seconds to wait before trying again. 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 site administrator can restart it from Atlassian Administration (admin.atlassian.com), in Connected 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.

Open the support page