How to migrate from Teamwork to AgencyPro

Example migration timeline

What moves to AgencyPro, and how

Import runbook: Teamwork.com to AgencyPro

AgencyPro's CSV importer takes two files: clients (Imports > Clients) and services (Imports > Services). Each has a downloadable template, and each file can hold up to 1,000 rows. Projects, tasks, files, messages, invoices, payment history, saved cards and time entries are not imported; they are set up by hand or with the migration service on the Plus plan. Where a vendor does not publish its export headers, the left column describes the data, and you match the real header in the importer's mapping step.

1. Client file

Where it comes from: More > People > People, then the options menu > Export to Excel. The file lists users and contacts; save it as CSV and keep only client contacts. Teamwork.com: export users to Excel

Rows with the same organization_name become contacts of one organization, and the first of them becomes its owner. The match is exact, so "Example Co" and "Example Co." create two organizations. Address and billing details are taken from the first row of each organization. Columns you do not map are ignored. Teamwork.com does not list the export columns; match them in the importer's mapping step.

2. Service file

Where it comes from: Teamwork.com has no sellable service catalog. Build the services file from your proposals, rates or invoices.

The CSV sets the basics only. After import, open each recurring service and add its pricing tier (billing period and price per period), and set intake form fields, images, turnaround and FAQs in the service editor.

3. Sample files

Example data, in the column names AgencyPro's templates use. Download the real templates from Imports > Clients and Imports > Services; they include every optional column.

clients.csv

name,email,phone,position,organization_name,billing_city,billing_country
"Jane Example","jane@example.com","+1 555 0100","Marketing Lead","Example Co","Austin","US"
"Sam Example","sam@example.com","","Founder","Example Co","Austin","US"
"Lee Sample","lee@sample.org","","Owner","Sample Studio","Leeds","GB"

services.csv

name,description,type,pricing_type,price,hours,credits,show_in_catalog
"Website audit","Technical and content audit","one_time","standard","1500.00","","","true"
"SEO retainer","Monthly SEO work","recurring","standard","2000.00","","","true"
"Development hours (10)","Prepaid block of 10 hours","one_time","time_based","1200.00","10","","true"

4. Permissions

• Teamwork.com: Export from an account that can see every company's contacts, or the file will be missing clients.
• AgencyPro: importing clients needs the create clients permission, and importing services needs the create services permission, in your workspace role.
• Importing does not email anyone. Clients get portal access when you send their invite from the client record, so you choose when they see the portal.

5. Validate

• Import a test file of three to five rows first, then check those clients and services in AgencyPro.
• In the mapping step, check every column. Headers such as Email, Company and Phone are matched automatically; map the rest by hand.
• The preview checks the first 100 rows for missing required values, invalid emails and invalid type values, and the import stays disabled until it shows no errors. Later rows with errors are skipped and listed by row number in the results.
• Rows whose email (clients) or name (services) already exists in the workspace are skipped, not overwritten.
• Each imported client fires the Client Created event. If you run Zaps on that trigger (Zapier is on the Plus plan), pause them during the import.
• After the import, export clients and services from Exports and compare the row counts with your Teamwork.com file.

6. Roll back

• There is no undo button. Select the imported clients or services in their lists and delete them in bulk, fix the CSV, and import again.
• To correct a client that imported with wrong details, delete or edit it first: re-importing the same email skips the row.
• Keep Teamwork.com running until the parallel run ends. Your Teamwork.com data is the fallback if anything needs re-checking.

Post-migration checklist

Continue learning