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.

  1. Click into the “Paste CSV or JSON” box.
  2. Paste your data (comma- or tab-separated for CSV, or 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
Use case: Share Monthly Sales in Confluence
avatar

Takumi Arai

Yamato Tech — Data Analyst

Context and challenge:
Every month, the analytics team gathers sales data from multiple systems and formats into separate spreadsheets. Publishing up-to-date reports in Confluence requires manual imports or external tools, adding delays and risking version mismatches.

Solution – CSV import with Simple Tables:
Takumi uploads the consolidated sales CSV directly into the Simple Tables macro. Confluence renders a clean, formatted table in-page—no extra spreadsheets or tools needed. The table supports built-in sorting, filtering, and styling to highlight key metrics.

Benefits:
• Single source of truth: The live table in Confluence always reflects the latest upload—no outdated attachments.
• Instant visibility: Stakeholders see monthly trends immediately without downloading files.
• Interactive reports: Users can sort by region, product, or date right in the page.
• Simplified workflow: Eliminates the need for separate BI tools or emailed spreadsheets.

Impact:
By embedding monthly sales directly in Confluence, the team cut report publication time by 70 %, enabled self-service data access for 50+ stakeholders, and reduced version-control errors to zero.

Select from page attachments

Import a CSV or JSON file that’s already attached to this Confluence page.

  1. Click the “Select from page attachments” box.
  2. Choose one of the listed files (e.g., sales.csv, metrics.json).
  3. Click Next to load and preview the data.
Use case: Monthly sales report
avatar

Finance Team

Acme Corp — Finance Department

Context and challenge:
Each month, the finance team attaches a new sales.csv to the Confluence page. Manually updating dashboards or importing the latest data is time-consuming and risks showing outdated figures.

Solution – Automated CSV attachment import:
Simple Tables automatically pulls the newest sales.csv attachment whenever the page loads. The Confluence dashboard always displays the latest sales numbers without any manual intervention.

Benefits:
• Always current: Dashboards reflect the newest data instantly—no stale reports.
• Zero manual steps: Finance saves hours by eliminating import scripts and copy-paste workflows.
• Error reduction: Automated imports remove version-control mistakes.
• Easy auditing: Attachment history in Confluence tracks every monthly update.

Impact:
By automating the CSV import, the team cut report-prep time by 75% (from 4 hours to 1 hour per month) and boosted stakeholder confidence with always-accurate dashboards.

Upload a file

Upload a CSV or JSON file from your device.

  1. Click the “Browse files” box.
  2. Select a CSV or JSON file from your computer.
  3. Click Next to import and preview.
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) that need to be reviewed immediately. Converting or uploading these into spreadsheets and then into Confluence is manual, slow, and error-prone.

Solution – Direct JSON import:
The Acme Buyer simply uploads the JSON file into the Simple Tables macro. Confluence parses and renders the data as a table in-page, ready for filtering, sorting, and inline commenting—no extra tooling or conversion steps required.

Benefits:
• Instant visibility: Data appears formatted in Confluence the moment you upload.
• No manual conversion: Skip intermediary CSV or spreadsheet files.
• Collaborative analysis: Stakeholders can comment, highlight, and filter the imported rows directly in Confluence.
• Reduced errors: Eliminates copy-paste mistakes and version mismatches.

Impact:
By enabling one-off JSON imports, the procurement team cut initial data-prep time by 60% and improved decision-making speed when vetting new vendors.