CSV Table macro - 8.x

On this page

Overview

The CSV Table macro can import, format, and display comma-separated values (CSV) data from anywhere, by:

  • Reading the CSV data from any of these sources:
    • Within your Confluence page.
    • From a file residing on the Confluence server.
    • From a global or space template.
    • From a page attachment.
    • From an external URL.
  • Allowing customizable delimiters, quote characters, and character encoding.
  • Supporting inclusion of Wiki Markup macros within the CSV data.
  • Combining with the Chart macro to produce powerful data visualization.
  • Leveraging the same table styling capabilities as the Table Plus macro.

CSV is not a formal standard, but the best reference isThe Comma Separated Value (CSV) File Format. The support in this macro comes close to following this pseudo-standard. This macro supports certain Common table capabilities

Applicable upto app version 8.1:

To enable using HTML content with CSV data, you must enable the Stop encoding of html characters parameter. In such a case, it is recommended to contact your administrator to use Macro Security for Confluence with this app to provide an additional layer of security to your data and privacy. Refer to this documentation to for more information on the Macro Security for Confluence app.

From app version 8.2 onwards, if the Stop encoding of html characters parameter is enabled, use of Macro Security for Confluence is no longer needed as the macro itself provides additional security to your data

Basic use

This macro can be deployed using one of the following methods:

Selected from the macro browserAdvanced Tables - CSV Table
Markup shortcut{csv}

Screenshot

Parameters

Deprecation notice

Please note that Username and Password parameters are deprecated and will be removed on March 31, 2022. We recommend using profiles to access your data from remote locations.

CSV Table settings

Augment parameters

See Augments for details.

Common parameters

The parameters listed on this page are a part of our common table capabilities that are available in many macros that produce or modify tables.

Click a column heading to toggle the sorting of that column.

Examples

Compatibility

  • Chart macro - the CSV Table macro can be used to create data for a chart
  • Beanshell macro - can be used to generate CSV Table macro and data as output from Java code (use output=wiki)
  • Groovy macro - can be used to generate CSV Table macro and data as output from Groovy code (use output=wiki)
  • Jython macro - can be used to generate CSV Table macro and data as output from Jython code (use output=wiki)

Other macros

The list of all other macros available within this app is as follows:

Additional references