Skip to content

Importing and exporting data

Most list screens can take data in from a spreadsheet and send it back out again - how you move an existing client list, vendor database or rate card into Awtomated without retyping it.

Both sit behind the ⋮ menu beside the main action button at the top right of a list.

The ⋮ menu. Easy to miss - it sits immediately right of Add New.

Module Import Export
Contacts Yes Yes
Companies Yes Yes
Deals Yes Yes
Vendors Yes Yes
Invoices Yes Yes
Rates Yes Yes
Team - Yes
Translation Memories Via Add New Yes

The dialog has two steps, and the first one matters more than it looks.

Import. Step 1 gives you the template; Step 2 takes your filled-in copy.

  1. Open the list you want to import into - contacts, companies, deals, vendors, invoices or rates.
  2. Select the ⋮ menu beside the main action button, then Import.
  3. Select Download Sample file XLSX. This is the template, and its column headers are what the importer expects. Do not rename or reorder them.
  4. Fill the template with your data, one record per row, keeping the sample row’s formatting as your guide.
  5. Select Choose File and pick your completed spreadsheet.
  6. Select Upload. The records are created and appear in the list. Cancel backs out without importing anything.

Export is a single step: choose Export from the same menu and the file is prepared for you.

Export. It runs in the background - Please wait for the export completion - rather than downloading instantly.