Export a list to Excel or CSV

1. 1Filter the list to what you want. The export follows the filter — the rows you can see are the rows you get.
2. 2Open the export option on the list.
3. 3Choose the columns. The left side lists every field the record has, your own custom fields under their own heading. Type in the search box to find one, or use Markera alla and Avmarkera alla to move quickly. A field marked Alltid med is always in the file.
4. 4Put them in order. Kolumner i filen on the right is the file, left to right. Dra för att ändra ordningen, or take a column out with its cross. A field you tick joins at the end.
5. 5Pick CSV or Excel at the bottom: Excel for anything a person will read, CSV for anything that has to be read by another system.
6. 6Export. The button says how many rows you will get, and Export slutförd confirms Exporterade {{records}} post(er) med {{columns}} kolumn(er).

The columns you picked, and their order, are remembered for that list the next time you export it.

Save the column set if you will do it again. Spara dessa kolumner, name it — Ge exporten ett namn — and Sparade “{{name}}”. Välj den från listan nästa gång. Next time, Välj en sparad export under Sparade exporter rather than ticking twenty boxes from memory. This is what makes a monthly export a ten-second job.

Excel or CSV? Excel keeps numbers and dates as numbers and dates, so it is the right choice for anything a person will read. CSV is the safer choice for feeding another system, but be aware Excel will mangle long numbers in a CSV — an organisation number can lose its leading zero.

Ingen data tillgänglig att exportera means the filter matched nothing. Check the people filter as well as the conditions: Show only your records, your team's, or everyone's.

Exported data leaves the app's protections behind. A spreadsheet of customer contact details on a laptop is exactly the kind of thing data protection rules are about. Export what you need, not everything.

For a number rather than a list, a report is usually the better tool — it can be scheduled and shared without anyone downloading anything: Reports