Export to CSV That Opens Correctly

ProNew

Download a table as CSV with proper quoting, a byte order mark so Excel reads accented text, protection against formula injection (cells starting with = + - @ get a leading apostrophe), a choice of columns, and a filename with the date. Use this when exported data will be opened in a spreadsheet.

Customize

This item has no props to tune. Use the lens above to change theme, density, direction and more.

Guide and examples

When to use it

People export lists to a spreadsheet and some cell values come from users.

Do not use it when: For very large exports, generate the file on the server and offer a link.

Installation

This item is part of tealmac UI Pro

The source for this item installs with a Pro licence key. Log in with your key to see the install command, or read the Pro setup page.

Props

Prop	Type	Description
`rows`	`Record<string, unknown>[]`	The data. A sample list is used by default.
`save`	`(text, filename) => void`	Replace the browser download, for example to upload to storage.

toCsv(rows, columns, { bom, guard }), guardCell and quoteCell are exported.

Accessibility

The columns are a fieldset with a legend and labelled checkboxes; Download is disabled with the reason in a status line when none is chosen, and the result states rows, columns and filename.
The file is safe to open: cells that a spreadsheet would run as a formula are neutralised, and the byte order mark makes accented names appear correctly in Excel.
Dates are written in ISO format; change the cell function if your users expect their locale.

Testing

The pattern ships with a Testing Library test (csv-export-download.test.tsx) that covers: its main behaviour, the keyboard path and the error or empty states.

Guide and examples

When to use it

People export lists to a spreadsheet and some cell values come from users.

Do not use it when: For very large exports, generate the file on the server and offer a link.

Installation

This item is part of tealmac UI Pro

The source for this item installs with a Pro licence key. Log in with your key to see the install command, or read the Pro setup page.

Props

Prop	Type	Description
`rows`	`Record<string, unknown>[]`	The data. A sample list is used by default.
`save`	`(text, filename) => void`	Replace the browser download, for example to upload to storage.

toCsv(rows, columns, { bom, guard }), guardCell and quoteCell are exported.

Accessibility

The columns are a fieldset with a legend and labelled checkboxes; Download is disabled with the reason in a status line when none is chosen, and the result states rows, columns and filename.
The file is safe to open: cells that a spreadsheet would run as a formula are neutralised, and the byte order mark makes accented names appear correctly in Excel.
Dates are written in ISO format; change the cell function if your users expect their locale.

Testing

The pattern ships with a Testing Library test (csv-export-download.test.tsx) that covers: its main behaviour, the keyboard path and the error or empty states.