Export & Import

Download a Connected Table as Excel, PDF, Word or CSV, or fill it from a CSV or Excel file. Both run entirely in your browser — files are never uploaded anywhere.

Note

Export and import are available on the issue’s Apps panel and the JSM customer portal request panel. Your administrator can turn either one off per field (see Admin settings).

Exporting a table

1. Open the table on the issue’s Apps panel or on a portal request.
2. Click the Export (download) icon in the table toolbar. It’s there both while viewing and while editing.
3. Pick a format. The file is prepared and downloaded straight away.

Connected Table⋯

Quote line items Excel (.xlsx)Numbers, dates and merged cells kept PDFReady to print or share Word (.docx)Editable document CSVComma-separated CSV for Excel (semicolon)For Excel set to a European locale

ABCItem	123Qty	123Unit price	{ }Total
Laptop 14"	3	1,250.00	3,750.00
Docking station	3	189.00	567.00
Monitor 27"	6	310.00	1,860.00
Total	12		6,177.00

The Export menu on the Apps panel toolbar. The file contains every row in your current search and sort, across all pages, plus the totals row.

Formats

Format	Best for	What you get
Excel (.xlsx)	Further analysis, sharing with spreadsheet users	Real number and date cells (in the column’s date format), merged cells kept, bold totals row.
PDF	Printing, attaching to emails, sign-off	An A4 document titled with the field name, header row repeated on every page, page numbers, merged cells kept. Wide tables switch to landscape automatically.
Word (.docx)	Reports and documents you want to edit	An editable Word table with merged cells kept.
CSV	Other tools and integrations	Comma-separated UTF-8 — accented and Cyrillic text opens correctly in Excel.
CSV for Excel (semicolon)	Excel set to a European locale	Same as CSV but separated by ;, so Excel splits it into columns when you double-click the file.

What’s in the file

• Exactly what you see: your current search and sort are applied, and all pages are included — not just the visible page.
• Readable values: user columns show people’s names, selection columns show option labels (multi-select values joined with commas), and formula and sequence columns show their calculated results.
• Checkboxes: TRUE / FALSE in Excel and CSV; a check mark (or blank) in PDF and Word.
• Totals row at the bottom when the table has column summaries.
• Merged cells stay merged in Excel, PDF and Word. CSV has no merged cells, so each row gets its own cell.
• Always the grid layout, even if you’re viewing the table transposed, so the file is spreadsheet-friendly.
• While editing, the export contains your unsaved changes as shown on screen.

Files are named <issue key> - <field name> - <yyyy-mm-dd>, for example SUP-42 - Quote line items - 2026-10-12.xlsx.

Safe to open in Excel

Text that starts with =, +, - or @ is prefixed with an apostrophe in CSV and Excel exports, so a value typed into the table can never run as a spreadsheet formula on someone else’s computer. Plain negative numbers are left as they are.

PDF and non-Latin scripts

PDF export supports Latin, Cyrillic and Greek text. Chinese, Japanese and Korean characters aren’t included in the PDF font — use Excel or Word export for those tables.

Importing rows from a file

Import adds rows to the table from a CSV or Excel (.xlsx) file — for example a list exported from another system, or a table you exported earlier and edited in Excel.

1. Start the import

1. Open the table and click Edit.
2. Click the Import (upload) icon on the left of the toolbar, next to + and ×.

2. Choose a file

Drag a file onto the dialog or click Choose file.

• Supported: .csv and .xlsx (from Connected Table, Excel or Google Sheets), up to 2 MB.
• Comma-, semicolon- and tab-separated CSV files are detected automatically.
• If an Excel workbook has several sheets with data, you pick the sheet to import.
• Old .xls workbooks aren’t supported — in Excel, save the file as .xlsx or CSV UTF-8 first.

Import rows from CSV or Excel

Drag a CSV or Excel file here

Choose file

.csv or .xlsx from Connected Table, Excel or Google Sheets · up to 2 MB

CSV encodingUTF-8 (recommended)

Cancel

Step 1 — choose a .csv or .xlsx file. Change the encoding only if accented or Cyrillic text from an older Excel CSV looks garbled.

Garbled characters?

Excel’s plain “CSV” format isn’t always UTF-8. If the preview shows broken characters, click Change file, set CSV encoding to Windows-1251 (Cyrillic) or Windows-1252 (Western European), and choose the file again. Saving from Excel as CSV UTF-8 avoids this altogether.

3. Map the columns

The first row of the file is treated as headers. Each table column is matched automatically to a file column with the same title (or column id) — case, spaces, dashes and underscores are ignored. Check the matches and change any of them with the dropdowns, or set a column to Don’t import. File columns that aren’t mapped are ignored.

Formula and sequence columns are calculated, so they can’t be imported — they fill in automatically.

4. Add or replace

• Add to the existing rows — the imported rows are appended after the current ones.
• Replace all existing rows — the current rows (and any merged cells) are removed and replaced by the file’s rows.

5. Preview and import

A preview shows the first 20 rows exactly as they’ll be imported, with a summary such as “48 rows to import · 3 cells need attention (imported empty)”. Cells that can’t be converted are highlighted — hover one to see why — and the first few problems are listed below the preview.

Import rows from CSV or Excel

equipment.xlsx· Sheet1 · 4 rows Change file

Columns

Matched by column title or id. Formula and sequence columns are calculated, so they aren't imported.

ItemItem

QtyQuantity

Unit priceUnit price

Owner— Don't import —

Rows

Add to the existing rows

Replace all existing rows

4 rows to import · 1 cell needs attention (imported empty)

Item	Qty	Unit price
Keyboard	6	49.9
Mouse	6	24.5
Headset	six	79
USB-C cable	12	9.99

• Row 3, Qty: "six" isn't a number

CancelImport 4 rows

Step 2 — check the column matches, choose Add or Replace, and review the preview. Cells that can't be read are highlighted and imported empty.

Click Import N rows. The dialog closes and the rows appear in the table as unsaved changes.

6. Review and save

Nothing is written to Jira until you click Save. Fix any highlighted cells, then save as usual — required-column checks apply. Click Cancel to throw the import away.

How values are read

Column type	Accepted values
Text	Any text. Text longer than the column’s maximum length is shortened (you’ll see a warning).
Number / Integer	1234.5, 1,234.5, 1.234,5, 1 234,5 — both decimal styles are understood. Integer columns reject fractions. Numbers are rounded to the column’s decimal places.
Checkbox	Checked: true, yes, y, 1, x, ✓, on. Unchecked: false, no, n, 0, off, or empty.
Date / Date-time / Time	The column’s own format, ISO format (2026-10-12, 2026-10-12 14:30), or real Excel date cells. Stored in the column’s format.
Single select	Must match one of the column’s options (case doesn’t matter).
Multi-select	Options separated by , or ; — each must match an option.
User	An exact display name, an email address, or an Atlassian account ID. If no user or more than one user matches, the cell is flagged rather than guessed.

• Problem cells are imported empty — never silently wrong. If the column is required, Save stays blocked until you fill them in.
• Table columns you didn’t map get their default value, just like a row added with +.
• Completely empty rows in the file are skipped.
• Merged cells in an Excel file are read correctly (the value is used for every row it covers), but imported rows aren’t merged in the table.

Table size limit

A table has a maximum size (roughly 100–150 rows, depending on columns and content). If the import would go over it, the Import button is disabled and the dialog tells you how many of the file’s rows would fit — split the file, or use Replace instead of Add.

Round-trip editing

Exported Excel and CSV files import back cleanly: the headers match the column titles, so mapping is automatic. A common pattern is to export, edit in Excel, then import with Replace all existing rows.

Admin settings

Both features are set per field context in the table settings (see the Admin Guide):

Setting	Default	Effect
Let viewers export the table (CSV, Excel, PDF, Word)	On	Shows the Export icon to everyone who can see the table, including portal customers.
Let users import rows from a file while editing (needs add/remove rows)	On	Shows the Import icon in edit mode. Only available when adding and removing rows is allowed.

Privacy

Exported files are built in your browser and saved directly to your computer. Imported files are read in your browser and never uploaded — only the rows you save end up in the Jira issue, exactly as if you had typed them in.

Troubleshooting

Message / symptom	What to do
“Connected Table was updated. Reload the page and try again.”	A new app version was installed while the page was open. Reload the page.
“The file is larger than 2 MB.”	Split the file, or remove unneeded columns first.
“Old .xls workbooks aren’t supported.”	Save the workbook as .xlsx or CSV UTF-8.
Accented or Cyrillic text looks garbled	Change the CSV encoding on the file picker, or save from Excel as CSV UTF-8.
Excel shows the whole CSV in one column	Use CSV for Excel (semicolon), or export to Excel (.xlsx).
A user cell says “matches more than one user”	Use the person’s email address or account ID in the file instead of their name.
No Export or Import icon	Your administrator may have turned it off for this field. Import also needs Edit mode and permission to add rows.