How to use the csv to jira table converter
- Paste your CSV text into the input area.
- Choose the delimiter (comma, semicolon, tab, or pipe).
- Toggle the header option if the first row should be a header.
- Copy the generated Jira markup and paste it into Jira or Confluence.
How the CSV to Jira table conversion works
The tool parses your CSV according to RFC 4180. Each field is split on the chosen delimiter unless it is wrapped in double quotes. Inside quoted fields, two consecutive double quotes represent a literal double quote. Embedded commas, semicolons, tabs, pipes, and newlines are preserved. After parsing, the first row becomes a header row (|| … ||) when the header option is enabled; otherwise every row uses the standard cell markup (| … |). Ragged rows (rows with a different column count than the first row) are still rendered but a note is appended to the output.
Jira table markup reference
Jira uses a simple pipe-based syntax:
| Element | Markup | Example |
|---|---|---|
| Header cell | || Header || | || Name || Role || |
| Body cell | | Cell | | | Alice | Developer | |
| New row | Line break | Each line is a new row |
No alignment or colspan/rowspan syntax exists in native Jira markup. For advanced tables, consider the Markdown table tool and use a Markdown macro in Confluence.
Common CSV edge cases handled
- Quoted fields with the delimiter:
"A,B",Cparses as two fields:A,BandC. - Embedded newlines:
"Line 1 Line 2",Bkeeps the newline inside the first cell. - Escaped quotes:
"He said ""Hi"""becomesHe said "Hi". - CRLF line endings: Both
\r\nand\nare accepted. - Empty fields:
A,,Cyields an empty second cell.
Ragged rows and validation
If rows have different column counts, the converter still produces a table. The first row (or the header row when enabled) sets the expected column count. Subsequent rows with fewer cells are padded with empty cells; rows with more cells are truncated. A plain-text warning line Note: ragged row at line N: expected X columns, got Y is appended to the output so you can spot data issues before pasting into Jira.
When to use other formats
Jira markup is convenient for quick tables in issues and comments. For documentation pages in Confluence, the Markdown table tool gives you pipe tables with alignment support. For HTML-based wikis or static sites, try CSV to HTML Table. If you need to go the other direction, Text to CSV helps structure loose data first.
Worked examples
| Example | Input | Result |
|---|---|---|
| Basic with header | CSV input: Name,Role / Alice,Developer / Bob,Designer; Delimiter: ,; First row is header: yes | || Name || Role || / | Alice | Developer | / | Bob | Designer | |
| Quoted fields with commas and newlines | CSV input: Task,Description / "JRA-123","Fix login bug, urgent" / "JRA-124","Update docs / Add examples"; Delimiter: ,; First row is header: yes | || Task || Description || / | JRA-123 | Fix login bug, urgent | / | JRA-124 | Update docs \\ Add examples | |
| Semicolon delimiter, no header | CSV input: Alice;Developer;Senior / Bob;Designer;Mid; Delimiter: ;; First row is header: no | | Alice | Developer | Senior | / | Bob | Designer | Mid | |
| Escaped quotes | CSV input: Quote,Author / "She said, ""Hello""",Anonymous; Delimiter: ,; First row is header: yes | || Quote || Author || / | She said, "Hello" | Anonymous | |
FAQ
Does this CSV to Jira table tool send my data to a server?
No. The parsing and conversion run entirely in your browser. Nothing is uploaded.
Can I use a custom delimiter not in the list?
The dropdown covers the most common delimiters. For other single-character delimiters, you can temporarily replace them in your editor (find/replace) with a supported one, convert, then revert if needed.
Why does my table look misaligned in Jira?
Jira tables do not support column alignment in the markup. The rendering is handled by Jira's stylesheet. If you need aligned numbers, consider using a Markdown table in a Confluence Markdown macro instead.
What happens with very large CSV files?
The tool handles tens of thousands of rows, but browser memory and UI responsiveness may degrade with huge inputs. For massive files, consider a local script or the CSV Viewer for inspection first.
Does it support Excel-style escaped quotes ("" for a literal quote)?
Yes. That is the RFC 4180 standard and what Excel produces. A field like "She said ""Hi""" becomes She said "Hi".
Can I convert Jira markup back to CSV?
This tool only goes one way. For the reverse, you would need a Jira markup parser, which is not currently available on this site.
Why is there a note about ragged rows in my output?
It means at least one row has a different number of columns than the header row. The note tells you the line number and the column counts so you can fix the source data before pasting into Jira.