Confluence Cloud guide

How to export a Confluence table to CSV

In short: Confluence Cloud can't save a table as CSV; its CSV exports are for whole spaces and databases. Paste the table into Excel and save it as CSV UTF-8, or use an app. To open a CSV in Excel, import it with Data → From Text/CSV: there you choose UTF-8 for accented letters, the delimiter (comma or semicolon, depending on the locale), and text instead of numbers for codes and long IDs.

What Confluence Cloud exports as CSV

Confluence Cloud has no option that saves a single table as a CSV file. The feature request for it, CONFCLOUD-4625 ("Export table contents as CSV"), dates from 2005 and was closed for low engagement. Here's what does produce a CSV:

  • Space export. Space admins can export a space to CSV, and Confluence puts the files in a zip. Atlassian describes this export as best for importing a space into another Confluence Cloud site. It isn't a spreadsheet of your table.
  • Databases. A Confluence database (not a table on a page) exports from its ••• menu → Export, as CSV, HTML or PDF. Check Export with current view to keep the view's settings.
  • Jira lists. If the table lists Jira work items, export them from Jira: ••• → Export → Export Excel CSV.

For an ordinary table on a page, make the CSV yourself through Excel, or use an app.

Make a CSV through Excel

  1. Copy the table from the published Confluence page and paste it into a new Excel workbook, at cell A1. The Excel guide covers the other routes and what to check.
  2. Fix what Excel changed: leading zeros, long numbers, dates and cells with several lines.
  3. Choose File → Save As and pick CSV UTF-8 (Comma delimited) (*.csv) as the file type.

Excel saves only the active sheet to a CSV file and removes all formatting. If you have several tables, put each one on its own sheet and save each as its own file.

Garbled letters: Excel and UTF-8

If letters like é, ł or ü look wrong after you open a CSV in Excel, Excel has probably read a UTF-8 file as another encoding. Atlassian says this about Jira's CSV files, which are UTF-8: older versions of Excel may read them as ANSI. Microsoft says a UTF-8 CSV opens normally if it was saved with a byte order mark (BOM). Without one, import it:

  1. In Excel, choose Data → Get Data → From File → From Text/CSV.
  2. Pick the file and select Import.
  3. Under File Origin, choose the encoding that makes the letters in the preview look right. For a UTF-8 file, pick the UTF-8 entry.
  4. Select Load.

This import recognizes UTF-8 on its own only when the file starts with a BOM, so check File Origin each time.

Commas or semicolons?

On Windows, Excel uses the list separator from your region settings as the delimiter when it opens or saves a CSV file. For US English that's a comma. Some locales use a different one by default; for German, Microsoft says, it's the semicolon. Excel also switches to a semicolon if you set its decimal separator to a comma.

So a comma-separated file can open with everything in column A on a computer set up for German, and a semicolon file can do the same on a US computer. Fixes:

  • Import instead of opening. Data → From Text/CSV lets you pick the delimiter (comma, semicolon, tab and others) and shows a preview.
  • Use the separator of the person who opens the file. If you're sending a CSV to a colleague, ask which one their Excel expects.
  • Change the setting only if you must. The Windows List separator (Region settings → Additional settings → Numbers) changes it for every program on the computer. To change it in Excel only, clear Use system separators under File → Options → Advanced and set the decimal separator to a comma. That also changes how decimal numbers display.

Keep leading zeros, long IDs and dates when you open a CSV

When you open a CSV file directly, Excel uses its default data format settings to decide what each column holds. The same conversions happen as with pasting: 007 becomes 7, digits after the 15th turn into zeros, and date-like text becomes a date. To keep values exactly as written:

  1. Choose Data → From Text/CSV and pick the file.
  2. In the preview, set the data type detection so that it doesn't detect types. Every column then loads as text.
  3. Or select Transform Data, select a column and choose Home → Data Type → Text, then Replace current and Close & Load. This lets you keep real numbers as numbers.

In Excel for Microsoft 365 and Excel 2024 you can also switch these conversions off (File → Options → Data → Automatic Data Conversion). While they're on, Excel by default shows a notice that lists the conversions it's about to make when you load a CSV file.

The older Text Import Wizard still works too. You turn it on under File → Options → Data, and in its third step you set each column to General, Text or Date, or skip it.

Cells with several lines: in a CSV, a value that contains line breaks, commas or quotes is wrapped in double quotes (RFC 4180). In Power Query, open the Source step: its Line breaks setting decides whether quoted line breaks stay inside the cell (Ignore quoted line breaks) or start new rows (Apply all line breaks).

What a CSV file can't keep

A CSV is plain text: one table, one row per line, cells separated by a delimiter. Excel saves only the active sheet and removes all formatting. So:

  • Merged cells can't stay merged. Decide whether a merged value should repeat in every cell it covered, which helps filters and pivot tables, or appear once with blanks around it.
  • Several tables need several files.
  • Types aren't stored. The program that opens the file guesses again each time, which is why the import steps above matter.
  • Formatting such as bold headers, colors and column widths is lost.

If the data is going into Excel anyway, an .xlsx file avoids most of this. See how to export a Confluence table to Excel.

CSV files from our app

We make Export Tables to Excel & CSV for Confluence, an app for Confluence Cloud, so this part is about our own product. Open a published page or blog post, choose ••• → Apps → Export Tables to Excel & CSV, and select a table's CSV button. Under Options you choose:

  • comma, semicolon or tab as the separator. A semicolon file writes plain numbers with a decimal comma (1,5).
  • whether a merged value repeats in every cell it covered (the default) or the covered cells stay blank.

The file is saved as UTF-8 with a byte order mark. Text that looks like a formula may get an apostrophe in front, so it isn't run as a formula. Tables generated by macros, such as Jira lists, aren't included, and only the published version of the page is exported.

A CSV still lets Excel guess types when you open it. If the table is going to Excel, the app's Excel download keeps leading zeros, long IDs and merged cells exactly. The user guide explains when to pick which.

Frequently asked questions

Can I export a Confluence table to CSV without an app?

Not directly. Copy the table into Excel and save it as CSV UTF-8, or export the page to Word or PDF and take the table from there. Confluence Cloud's own CSV exports cover whole spaces and databases, not single tables.

Why does my CSV open in a single column in Excel?

The file's delimiter doesn't match the list separator Excel uses, which on Windows comes from your region settings. Import the file with Data → From Text/CSV and pick the right delimiter.

Why do accented letters look wrong in my CSV?

Excel has probably read a UTF-8 file as another encoding. Microsoft says a UTF-8 CSV with a byte order mark opens normally. Otherwise, import it with Data → From Text/CSV and choose UTF-8 under File Origin.

Is Confluence's space export to CSV a table export?

No. Space admins can export a space to CSV, but Atlassian describes it as the best format for importing the space into another Confluence Cloud site, not for working with a table in a spreadsheet.

Should my CSV use commas or semicolons?

Use the separator the person opening the file uses. The comma is Excel's default for US English; for German, the default list separator is the semicolon. Importing with Data → From Text/CSV works with either.

Read next

Sources

  1. CONFCLOUD-4625: Export table contents as CSV — Atlassian feature request, created 2005, closed as Low Engagement
  2. Export a space's content as Word, PDF, or data files — Atlassian Support, Confluence Cloud: page export to Word and PDF, space export to CSV
  3. Export your database data — Atlassian Support, Confluence Cloud databases: CSV, HTML and PDF
  4. Export search results — Atlassian Support, Jira Cloud: Export Excel CSV and Open in Microsoft Excel
  5. Export issues from Jira cloud in CSV format — Atlassian knowledge base: Excel may read a UTF-8 CSV as ANSI
  6. Opening CSV UTF-8 files correctly in Excel — Microsoft Support: byte order mark, From Text/CSV
  7. Import or export contacts in Outlook using a .csv file — Microsoft Support: File Origin when importing, and Save As CSV UTF-8 (Comma delimited) in Excel
  8. Power Query Text/CSV connector — Microsoft Learn: UTF-8 detection, delimiters, data type detection, quoted line breaks
  9. Formula errors when list separator isn't set correctly — Microsoft Learn: Excel uses the Windows list separator as the .csv delimiter
  10. Import contacts from an Excel spreadsheet to classic Outlook — Microsoft Support: the default list separator for German is the semicolon
  11. Import or export text (.txt or .csv) files — Microsoft Support: opening a .csv, From Text/CSV, list separator settings
  12. Save a workbook to text format (.txt or .csv) — Microsoft Support: only the active sheet is saved, formatting is removed
  13. Keeping leading zeros and large numbers — Microsoft Support: leading zeros, 15-digit precision, importing columns as Text
  14. Data import and analysis options in Excel — Microsoft Support: Automatic data conversion when entering, pasting or loading text
  15. Text Import Wizard — Microsoft Support: column data formats General, Text and Date
  16. RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files — IETF, October 2005 (informational)