Export & import

Every list exports to CSV, Excel, or PDF, and entity lists can import the same formats with per-row error reporting.

Export

Each DataGrid has an Export menu that downloads the current view — filters and sort included — as CSV, Excel, or PDF. Because the export honors the active query, "export what I'm looking at" just works.

On the backend, exports use a generic TabularExport against the same query spec that powers the list, so adding an export endpoint to a feature is a few lines. PDF output is rendered with QuestPDF (the Sales demo also ships a branded PDF invoice per order).

Import

Entity lists (Products and Customers in the Sales demo) also import from CSV/Excel: download the template, fill it in, and upload. Bad rows are reported by line number — unknown category, duplicate SKU, malformed email — without failing the rest of the batch, so a 500-row file with three bad rows imports 497 and tells you exactly which three to fix.

var rows = TabularImport.ReadRows(stream, fileName);   // header-keyed rows
foreach (var (row, i) in rows.Select((r, i) => (r, i)))
{
    // validate, dedupe, and collect per-row errors → ImportResult
}

The end-to-end pattern is in Export & import.

Community edition

Export/import (CSV/Excel/PDF) is a Pro feature. See Editions.