Import and export your data
Bring customers, companies and tickets from another help desk with a CSV file, and export tickets, customers, ratings or everything.
Go to Settings, then Import and export.
Import from CSV
Importing is for admins.
- Under Import from CSV, choose the Data: Customers, Companies or Tickets with messages.
- Choose the CSV file: UTF-8, separated by commas, semicolons or tabs, with a header row first. At most 4 MB and 5,000 rows; split bigger files.
- Check the Columns. Aoun recognises usual column names, in English, French and Arabic and from other help desks. Pick the right Field for any column it did not guess, or Do not import.
- Select Check (dry run). Nothing is saved: you see how many rows would be New, Updated or Unchanged, and each problem with its Row number as your spreadsheet shows it.
- Fix the file if needed, then select Import.
What each import does
- Customers: one row per customer; the e-mail address is required. Existing customers keep their values: only empty ones are filled in, if Fill in empty values of existing records is on. A company given by name is created if needed.
- Companies: one row per company. Domains separated by semicolons link customers by their e-mail address.
- Tickets with messages: one row per message. Rows with the same Ticket id form one ticket; the first row carries the Subject and the Requester e-mail. Each message's author is found by Message author e-mail: an agent, the requester or another customer. Dates are read in the help desk time zone.
Imported tickets send no e-mail, run no rules and get no SLA targets, so customers are not disturbed. They are tagged imported. If you import the same file again, tickets already imported are skipped and shown as Already imported.
Export to CSV
- Under Export to CSV, choose the Data: tickets, customers, companies or Satisfaction ratings.
- Optionally set From and To (help desk dates), a status or rating, and a team.
- Select Download CSV.
The file opens in any spreadsheet, Arabic included. Only the tickets your role can see are exported, and exporting tickets or ratings needs permission to view reports. Cells that a spreadsheet would run as a formula are written as text, so a customer's message cannot run anything on your computer.
Full export
Admins can select Download JSON under Full export to get everything of the help desk in one file: settings, agents, roles, teams, customers, companies, fields, rules, views, macros, saved replies, the knowledge base, and every ticket with its messages and history.
Secrets are left out (connected mailboxes, webhooks, API tokens, identity secret), and so are file contents: attachments are listed with their name, size and checksum.
Every import and export is recorded in the audit log.
Was this article helpful?
Related articles
- Send events to your systems with webhooksNotify your own server when tickets, messages, customers or ratings change, check the signature, and follow deliveries and retries.
- Get reports by e-mail on a scheduleSend a daily, weekly or monthly summary of the help desk to agents, with a CSV file of the tickets.
- Roles and permissionsChoose what each agent may do and which tickets they see: admin, agent, light agent or a custom role.
Still need help?
Write to the Woosool team. Sign in with your Woosool Account and we reply by e-mail and in My requests.

