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.
Where it lives
Section titled “Where it lives”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 |
Importing a file
Section titled “Importing a file”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.
- Open the list you want to import into - contacts, companies, deals, vendors, invoices or rates.
- Select the ⋮ menu beside the main action button, then Import.
- Select Download Sample file XLSX. This is the template, and its column headers are what the importer expects. Do not rename or reorder them.
- Fill the template with your data, one record per row, keeping the sample row’s formatting as your guide.
- Select Choose File and pick your completed spreadsheet.
- Select Upload. The records are created and appear in the list. Cancel backs out without importing anything.
Exporting a list
Section titled “Exporting a list”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.

