Import Your Data

Start by choosing how you want to import your table data. You can:

Paste CSV or JSON

Paste raw CSV or JSON data directly into the editor field. Note: Excel files (.xls or .xlsx) are not supported via paste.

  1. Click into the “Paste CSV or JSON” box.
  2. Paste your data (comma- or tab-separated for CSV, or a valid JSON array).
  3. Click Next to preview and confirm.
Region,Month,Sales
Kanto,2024-05,32500
Kansai,2024-05,27400
Tohoku,2024-05,14600
Chubu,2024-05,19950
Kyushu,2024-05,17120

Select from page attachments

Use the Simple Table macro to import a CSV, Excel (.xls or .xlsx), or JSON file that’s already attached to this Confluence page. This macro enhances native tables with rich features like sorting, filtering, and formatting.

  1. Click the “Select from page attachments” box in the Simple Table macro.
  2. Choose one of the attached files (e.g., sales.csv, report.xlsx, metrics.json).
  3. Click Next to load and preview the data.
  4. The data renders as an interactive Simple Table with full macro functionality.
  5. Click Save to embed it in the page.
Use case: Monthly finance dashboard
avatar

Finance Team

Acme Corp — Finance Department

Context and challenge:
Every month, the finance team uploads a sales.xlsx file with the latest figures. Updating Confluence dashboards manually used to be slow and error‑prone.

Solution – Excel import with Simple Table macro:
The attached Excel file is automatically parsed and rendered. The data appears directly in Confluence with full support for sorting, filtering, and formatting—all without converting to CSV.

Benefits:
• Excel ready: No need to save as CSV.
• Always synced: Dashboards display the latest attached file.
• No friction: Skip intermediate conversions.
• Scalable: Perfect for monthly KPI reports or budget sheets.

Impact:
Excel imports have cut manual prep time by 70% and improved reporting efficiency across departments.

Upload a file

Use the Simple Table macro to upload a CSV, Excel (.xls or .xlsx), or JSON file from your device.

  1. Click the “Browse files” box in the macro.
  2. Select a supported file from your computer.
  3. Click Next to import and preview.
  4. The data renders as an interactive Simple Table.
  5. Click Save to embed it on the page.
Use case: One-off dataset import
avatar

Acme Buyer

Procurement — Acme Corp

Context and challenge:
Procurement teams often receive ad‑hoc data dumps (e.g., vendor catalogs in JSON or XLSX) that must be reviewed immediately. Converting or uploading these into spreadsheets and then into Confluence is manual, slow, and error‑prone.

Solution – Direct import via Simple Table macro:
The Acme Buyer uploads the supported file type directly into the macro. Confluence parses and renders the data as a clean, interactive table—no extra tools or conversions required.

Benefits:
• Instant visibility: Data appears formatted right after upload.
• No conversions: Supports CSV, Excel, and JSON natively.
• Collaborative: Stakeholders can filter, sort, and comment directly in Confluence.
• Error reduction: Eliminates manual steps and mismatches.

Impact:
By enabling direct import of Excel and JSON files, the team cut initial data‑prep time by 60% and improved decision speed when evaluating vendor data.