Export to Excel - Nextedy Documentation

Prerequisites

A Powersheet document open in Polarion with populated data
The sheet must be fully loaded (all rows visible) before starting the export

Prepare the Sheet

Before exporting, configure which columns appear in the output. The export includes only visible columns — hidden columns are excluded automatically.

Open your powersheet document in Polarion
Use the Views selector to switch to the view that contains the columns you want to export
Verify that all desired columns are visible in the sheet

Create a dedicated view with only the columns relevant for your export. Switch to that view before exporting to get a focused, clean Excel file without manual cleanup afterward. See Create a View for instructions.

Export to Excel

Open the sheet toolbar menu
Select Export to Excel
A loading indicator appears while the export is being generated
When the export completes, your browser automatically downloads an .xlsx file named after the current document

What the Excel File Contains

The exported .xlsx file mirrors the visible state of your sheet:

Component	Description
Column headers	Bold, centered text matching the column titles in the sheet
Column group headers	If your sheet uses `columnGroup` settings, grouped columns are merged under a shared header
Row numbers	Sequential row numbers (1-based) appear in the row header column
Cell styling	Bold and underline formatting from sheet cells is preserved
Merged cells	Cell merging from the sheet is reproduced in Excel
Group rows	Group row headers appear bold and centered, with optional item counts

How Column Types Are Exported

Powersheet converts each column type to an Excel-compatible format:

Sheet Column Type	Excel Output
Plain text	Text value as-is
Multi-item	Each value on a new line
Workflow state	State name as text
Reference (many-to-one)	Referenced item label as text
Reference (many-to-many)	Each linked item on a new line
Collection	Items on separate lines, icons removed
External link	URL text (not a clickable hyperlink)
Security-denied cell	Denied indicator preserved

Columns with the hasUrl property export URL values as plain text strings, not as clickable Excel hyperlinks. If you need clickable links in your Excel file, you will need to convert them manually after export.

Group Row Behavior

Group rows in the Excel output appear as bold, centered text. The showGroupRowCounter configuration property controls whether the item count (e.g., “Requirements (5 items)”) appears in group headers:

# In your sheet configuration
showGroupRowCounter: true   # Shows "(N items)" in group headers

When showGroupRowCounter is set to false, the counter text is removed from group rows in the export.

Character Limit Handling

Excel cells have a maximum capacity of 32,767 characters. If any cell in your sheet exceeds this limit, Powersheet automatically truncates the content and displays a warning notification:

⚠️ “Text trimmed in: row X, column Y. Excel cells are limited to 32,767 characters.”

Cells with extensive content — such as rich text descriptions or large collections — may exceed the Excel character limit. Check the warning notifications after export to identify any truncated cells. Consider splitting large content across multiple fields if truncation is a recurring issue.

Export Notifications

Powersheet provides clear feedback during the export process:

Event	Notification
Export starts	Loading indicator appears on the sheet
Export succeeds	✅ “Export downloaded: `<filename>.xlsx`” (auto-dismisses after 5 seconds)
Export fails	”Export failed: `<error reason>`” (auto-dismisses after 5 seconds)
Content truncated	⚠️ Character limit warning (persists until dismissed)

Troubleshooting Common Issues

Empty or Missing Columns

If columns are missing from the export, verify they are visible in the current view. Switch to a view that includes all required columns, or check that no columns are hidden via the column visibility settings.

Slow Export on Large Sheets

Cell merging is the primary performance factor for Excel exports. Sheets with deep hierarchies and extensive merged cells take longer to process.

For large sheets with many merged cells, consider temporarily switching to a flat view (without hierarchical merging) before exporting. This can significantly reduce processing time.

Export Fails with Error

If the export fails, the error notification includes a reason. Common causes include:

Browser memory limits on very large sheets (thousands of rows with complex columns)
Network interruption during the export process
Corrupted cell data that cannot be serialized

Try refreshing the page and exporting again. If the issue persists, reduce the number of visible columns or rows before retrying.

Verification

You should now see a downloaded .xlsx file in your browser’s download folder. Open it in Excel or a compatible spreadsheet application and confirm that:

All visible columns appear with correct bold headers
Column groups display merged header cells spanning the grouped columns
Row numbers start at 1 and increment sequentially
Multi-item and reference cells show values on separate lines
Bold and underline formatting from the sheet is preserved
Group rows appear bold with the correct item counts (if showGroupRowCounter is enabled)

​Prerequisites

​What the Excel File Contains

​How Column Types Are Exported

​Group Row Behavior

​Character Limit Handling

​Export Notifications

​Troubleshooting Common Issues

​Empty or Missing Columns

​Slow Export on Large Sheets

​Export Fails with Error

​Verification

​See Also

Prerequisites

What the Excel File Contains

How Column Types Are Exported

Group Row Behavior

Character Limit Handling

Export Notifications

Troubleshooting Common Issues

Empty or Missing Columns

Slow Export on Large Sheets

Export Fails with Error

Verification

See Also