Skip to content

Import and export

Bring records in from a CSV or spreadsheet, take them out as CSV, XLSX or a full backup, and copy your objects to another organization.

Who can do this: Import: Owners, Admins, Managers and Members. Export: Owners and Admins. Export and import of the organization's objects: Organization settings.

Records come in from a file and go out as one. Your organization's own objects can travel as a file too, without their records.

Import records#

Start the import#

Choose Import in a list's toolbar, or go to Settings > Data > Imports and pick a record type under Import into.

Choose the file#

Choose a file: a CSV, TSV, TXT, XLSX or XLS file whose first row holds the column headers.

Map the columns#

Under Where each column lands, check the Property in SalexHub for each column, or Skip this column. Use the mapping of a previous import repeats an earlier one.

Say how rows match#

Under Which column identifies the record?, pick the column that says a row is a record you already have, or Don't match: import every row as new. Then choose what happens to a match: Keep the existing record, Update the existing record or Import as a second record.

Import#

The screen says how many rows are ready, and nothing is written until you choose Import.

Before the run, the import also asks how to read dates such as 03/04/2025 and numbers such as 1.500, when the file leaves them unclear. A word in a choice column that names no option can be pointed at one, added as a new option, or left out with its rows.

What an import checks#

Every row goes through the same checks as a record saved by hand: required and unique properties, field access and record rules. A refused row is listed with its line in your file and the reason, and Download error file gives you those rows to fix and import again.

  • A contact whose email is already here, or a company whose domain is, is recognized whatever column you match on. It is never imported twice.
  • Rows that only look like someone already here can be created and marked as possible duplicates, left out, or listed for you.
  • A file of companies, contacts and deals can carry all three in one row, with an activity on them.
  • A column of files is left out: files are uploaded on each record.

A file over ten rows imports in the background, and the bell tells you when it is done.

Undo an import#

In Settings > Data > Imports, choose Undo import on its row. Records the import added move to the recycle bin, and records it updated get their earlier values back. A record someone changed after the import is left as it is.

Ask the Agent#

Attach the file in the chat and ask. The Agent reads it first and shows a card with the row count and the columns; approving it runs the import. The Agent cannot add new options to a property: it maps each word to an option that exists, or asks you.

Export records#

Choose Export in a list's toolbar. Export this view takes the records with the filters and search you applied:

  • Format: CSV, which imports back as it is, or XLSX, which keeps dates and numbers as such.
  • Columns: Columns in this view, or All properties you can view.

Up to 10,000 records download at once. A larger export is prepared in the background, and you are told when it is ready. Properties you cannot view are left out, and the export names them.

Settings > Data > Exports lists your exported files, each downloadable again for 30 days.

Back up all data#

On the same page, Back up all data makes one ZIP: a CSV file for each record type you can export, a file of the links between records, and a note of what was left out. You confirm it is you first, and an email brings the link. It takes Organization settings and Export.

Copy your objects to another organization#

Settings > Organization > Export and import copies your objects, properties and views to another organization. Records, workflows, agents and permissions never travel in the file.

Download the file#

In the organization you copy from, choose Download a file.

Import it#

In the other organization, choose Import a file. A plan shows what will be created and what is skipped because that organization already has it; its own version wins.

Install#

Choose Install. What you imported is listed in Settings > Organization > Packs, where you can remove it.

Rights#

ToYou need
Import recordsImport, and the right to create the records the file fills
Create a new property during an importOrganization settings
Export recordsExport
Back up all dataOrganization settings and Export
Export and import your objectsOrganization settings
See everyone's imports and exportsAudit log. Without it you see your own

By default Owners, Admins, Managers and Members hold Import; Owners and Admins hold Export. Roles and permissions lists the rest.

Limits#

WhatUp to
Rows in one import of contacts, companies or deals1,000,000
Rows in one import of any other type, or of a file with activities5,000; split a longer file
Columns in one sheet of a workbook1,000
An .xls file32 MB; save a larger one as .xlsx
Records that download at once10,000; more are prepared in the background
Exports running for one person3
Exports in one organization200 in 24 hours
Backups of all data1 in 24 hours
Days an export file and an import's refused rows are kept30

Cookies and measurement