Horizon Ventures

What a Confluence space export actually gives you

There is a button that takes an entire space out of Confluence, and most people never find it. There is also a gap between what it produces and what people assume it produces. Both are worth knowing before a migration or an audit.

Short answer. Confluence Cloud exports a whole space to PDF, CSV, HTML or XML from space settings. It is an administrator's action: space admins can export a space, or a set of pages selected individually inside it. The export is genuinely useful for moving or archiving content. What it is not is a spreadsheet of your data: the CSV option dumps space content, not the tables that live on your pages. And several things leave the export without telling you.

The four formats, and what each is for

FormatWhat it is really for
PDFGiving the content to somebody outside the wiki. A readable document, not a data source.
HTMLA browsable offline copy of the space. Useful as an archive you can still open in five years.
XMLMoving a space into another Confluence site. Machine-readable, faithful, and unpleasant to read.
CSVTaking content out in a portable form. By default it exports everything you can view, including attachments and comments.

Word is missing from that list on purpose: in Cloud, Word export lives at the page level, not the space level. If somebody tells you to "just export the space to Word", they are describing Data Center or wishful thinking.

What quietly does not make it

None of these produce an error. The file arrives, it looks complete, and the missing parts are noticed weeks later by somebody who needed them.

Blog posts are not included when exporting to PDF. If a team keeps decisions or release notes as blog posts, a PDF export of the space silently drops that entire body of writing.

Page comments are currently not exported during HTML export. In wikis where the real reasoning sits in comment threads under a short page, this removes the part that mattered.

Team Calendars are not included in exports.

Unpublished work is not there. An export takes published content. Edits that somebody has been carrying in a draft for three weeks do not exist as far as the export is concerned, and nothing on screen points this out.

The result depends on who clicks. Only content visible to you is exported, with one exception: exporting via CSV or XML as a site admin exports all content. The same button in two pairs of hands produces two different files, which is a problem when the export is supposed to be a complete record for legal or compliance reasons.

One detail that migrates between versions and confuses people: the limit of the first 50 attached images in a Word export is documented for Confluence Data Center, where it can be raised with a system property. Cloud has no such property, and the Cloud documentation does not state that number, so do not plan around it either way without testing your own pages.

Why the CSV option is not the answer to "get my tables into Excel"

This is the part that sends people in circles. You have a space full of registers, budgets and checklists kept as tables on pages. You find "export space to CSV", and it sounds like exactly the thing.

It is not. That export is a dump of the space's content: pages, attachments, comments. Atlassian's documentation does not describe its column layout, because it is not meant to be read as a data sheet. You do not open it and find your budget table with its columns intact; you find the space, flattened into a transport format.

For actual table data there is still nothing native on the page. Copying a table by hand into a spreadsheet works until merged cells are involved, and then the values after a merged cell shift into the wrong columns while still looking like perfectly good numbers.

How long the honest way takes

A quarterly report that pulls figures from eleven tables spread across a space: about four minutes per table when nothing is merged, closer to ten when something is, plus the time spent later working out why the finance number disagrees with the wiki. Call it an hour and a half, four times a year.

The hours are not the problem. The problem is that this is retyping data that already exists, and a number retyped is a number that can be wrong without anyone noticing.

What to use when

Leaving Confluence, or archiving a space before it is deleted: use the native export, XML for another Confluence site, HTML for an archive a human can open later, PDF for sending outside. It is free and it is the right tool.

Handing over a single document: export the page to PDF or Word. No admin rights needed.

Getting numbers out of tables to calculate with: the native export does not do this, and the CSV name is a trap.

Disclosure: I build Confluence apps. One of ours, Table Export, covers only that last case: one table, a page, or every table in a space into Excel or CSV, each sheet labelled with the page it came from, with merged cells expanded so the columns stay where they belong. It does not replace the space export and it is not trying to: for a migration or an archive, use the built-in one. There is a demo on the product page showing the merged-cell problem on a real budget table, no install needed.

Questions people ask

How do I export a whole space?

Space settings, then the export option: PDF, CSV, HTML or XML. Space admins can export a space or a group of individually selected pages. Space and site admins can also export content owned by deactivated accounts.

Does the CSV export give me my tables?

No. It exports space content, by default everything you can view including attachments and comments. It is a transport format, not a data sheet.

What gets left out?

Blog posts in PDF exports, page comments in HTML exports, Team Calendars everywhere, and anything still sitting unpublished in a draft.

Will I get everything, or only what I can see?

Only what you can see, unless you are a site admin exporting via CSV or XML, in which case all content is exported.

Can a normal user export a space?

No, it is an admin action. Anyone can still export a single page to PDF or Word.

Related: how to get a Confluence table into Excel and how to sum a column in a Confluence table.