> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nextedy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Export to Excel

> Export your Nextedy POWERSHEET data to an Excel (.xlsx) file that preserves column headers, cell styling, group structure, and complex cell content for offline analysis and reporting.

export const LastReviewed = ({date}) => {
  if (!date) return null;
  const formatted = new Date(`${date}T00:00:00Z`).toLocaleDateString("en-US", {
    year: "numeric",
    month: "long",
    day: "numeric",
    timeZone: "UTC"
  });
  return <p className="mt-10 text-sm text-gray-400 dark:text-zinc-500 not-prose">
      Last reviewed on {formatted}
    </p>;
};

## Prerequisites

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

<Steps>
  <Step title="Prepare the Sheet">
    Before exporting, configure which columns appear in the output. The export includes **only visible columns** — hidden columns are excluded automatically.

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

    <Tip title="Use Views to control export scope">
      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](/powersheet/guides/sheet-configuration/create-view) for instructions.
    </Tip>
  </Step>

  <Step title="Export to Excel">
    1. Open the sheet toolbar menu
    2. Select **Export to Excel**
    3. A loading indicator appears while the export is being generated
    4. When the export completes, your browser automatically downloads an `.xlsx` file named after the current document

    <Frame>
      <img src="https://mintcdn.com/none-17b4493f/3Zik2OH750CE3kB4/powersheet/diagrams/guides/export/export-to-excel/diagram-1.svg?fit=max&auto=format&n=3Zik2OH750CE3kB4&q=85&s=99906acde58b53b3110cb61e44281145" alt="diagram" style={{ width: "520px", maxWidth: "100%" }} width="520" height="220" data-path="powersheet/diagrams/guides/export/export-to-excel/diagram-1.svg" />
    </Frame>
  </Step>
</Steps>

## 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             |

<Warning title="External links export as plain text">
  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.
</Warning>

## 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:

```yaml theme={null}
# 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."

<Warning title="Large text fields may be truncated">
  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.
</Warning>

## 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.

<Tip title="Reduce export time">
  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.
</Tip>

### 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)

## See Also

* [Export to PDF](/powersheet/guides/export/export-to-pdf) — why Powersheet has no PDF export, and the Excel-only alternative
* [Export Guides](/powersheet/guides/export/index) — overview of all export options
* [Create a View](/powersheet/guides/sheet-configuration/create-view) — set up column visibility presets for targeted exports
* [Configure a Column Group](/powersheet/guides/sheet-configuration/configure-column-group) — organize columns under shared headers
* [Configure Read-Only Column](/powersheet/guides/sheet-configuration/configure-read-only-column) — control which columns are editable vs. display-only

<LastReviewed date="2026-06-24" />