Exporting Data

M
Written By Melih SünbülLast updated 5 months ago

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.