Exporting Data
Data that lives only inside an application isn't fully useful. Stakeholders need spreadsheets. Auditors need files. Reports need attachments. Lex App's export system is designed around one principle: what you see is what you get.
How Export Works
Click the Export button in the toolbar. The system generates a file that mirrors your current grid view:
- Filters applied? Only filtered rows are exported.
- Columns grouped? The group hierarchy is preserved in the file.
- Pivot mode active? The cross-tabulated layout is exported as-is.
- Rows selected? Option to export only the selected subset.
The export runs server-side, so even large datasets (tens of thousands of rows) export reliably without browser memory issues.
🎬 Video — Exporting a grouped, filtered view
🎬 Watch video
Set up a grouped and filtered view, click Export, open the resulting Excel file.
Export Formats
Format | Best For |
|---|---|
Excel (.xlsx) | Full-featured export preserving formatting, grouping, and structure |
CSV | Lightweight, universal format for importing into other systems |
What Gets Exported
The export captures the grid exactly as you're viewing it:
Grid Feature | Reflected in Export? |
|---|---|
Visible columns (order & selection) | ✅ |
Active filters | ✅ Filtered data only |
Sort order | ✅ |
Row grouping hierarchy | ✅ Group labels and nested rows |
Pivot mode cross-tabulation | ✅ Pivoted columns as-is |
Aggregation totals (group rows) | ✅ |
Selected rows only | ✅ Optional |
Column widths | ❌ Auto-fit in export |
Cell formatting (colors, fonts) | ❌ Plain data |
Exporting Grouped Data
When rows are grouped, the export preserves the hierarchy. Group headers appear as labeled rows with aggregate values, and child rows are nested beneath them:
▼ Engineering Total: €24,500
Software license renewal €3,200
Conference travel €1,800
...
▼ Marketing Total: €15,200
Ad campaign Q1 €8,000
...This makes the file immediately useful for reporting — no rearranging needed.
Exporting Pivoted Data
When pivot mode is active, the exported file reflects the pivoted layout:
Team | Q1 2026 | Q2 2026 | Q3 2026 | Q4 2026 |
|---|---|---|---|---|
Engineering | €8,200 | €6,100 | €5,400 | €4,800 |
Marketing | €4,500 | €3,800 | €3,200 | €3,700 |
This is the same cross-tabulation you see on screen — ready to paste into a presentation or share with a stakeholder.
Exporting Selected Rows
If you need a subset, select specific rows in the grid (click to select, Shift+Click for a range, Ctrl+Click for individual picks). When exporting, choose Selected rows only to generate a file with just those records.
Combine selection with filters for precision: filter down to the relevant records, select a handful, and export just those.
Was this helpful?
Your feedback shapes what we write next.
