In this section · 10 articles

Export a list to CSV

Download the records a list is showing, with your search, filters and sort applied, as a CSV file you can open in a spreadsheet.

Applies to
Core 12.0 and later
Who can do this
Administrator, Team member
On this page

Before you start

  • You need permission to see the list, for example feature.core.country.list for Countries. A few lists, such as the activity logs, ask for a separate permission that ends in .export. Without it, the export is refused.
  • One export holds up to 5,000 rows.
  • If Export CSV is grayed out, the reason shows under it in the menu.
  • Narrow the list first. The export contains the records that match your search and filters, in the order you sorted them. See Filter a list.

Steps

  1. Open the list, then search, filter and sort it until it shows the records you want.

  2. Select the menu arrow beside the gear (⚙) button at the end of the toolbar.

    The Users list with the menu beside the gear button open, showing Export CSV, Active and Trashed, with Export CSV highlighted.
  3. Select Export CSV.

Your browser downloads a file named after the list, for example country.csv.

Tip: To export deleted records, switch the list to Trashed in the same menu first. The export follows whichever set you're looking at.

What's in the file

  • One column for every column the list defines, headed with the column's name in your language. Columns you've hidden are still included.
  • Plain text values. Formatting and HTML are removed.
  • Every matching record, not only the page you're on, and not only the rows you've ticked.

If the export is refused

If more records match than one export can hold, nothing is downloaded and you see Too many rows to export. Narrow the filter to 5,000 rows or fewer. Laramin refuses rather than giving you a file that looks complete but isn't.

The Cities list showing the error message Too many rows to export. Narrow the filter to 5,000 rows or fewer. at the top right of the page.

Add a filter, for example on a date range, and export in parts.

What happens next

The file is UTF-8 encoded. If accented or non-Latin characters look wrong when you open it, open it through your spreadsheet's text or CSV import and choose UTF-8.

To add records from a spreadsheet instead, see Import records from a CSV file. Countries, States and Cities support it.