Bringing Your Data In
Moving to ORCA
Most people come to ORCA with data somewhere else: an old CRM, a few spreadsheets, or both. There are three ways to bring it across, and all three end up in the same place. Whichever you use, a record that is already in ORCA can be matched and updated rather than added twice. None of the import, the connection or the upsert endpoints deletes anything in ORCA.
You'll find all three under Settings > Import.
From a Spreadsheet
Export a CSV or Excel file, match its columns to ORCA's fields, look at the review, and import.
Suits: a list you keep in a spreadsheet, a system ORCA can't connect to, or a one-off load. It works for accounts, contacts and the records of any section.
If you're moving from another system and will load its export more than once, tick Update existing records. ORCA matches each row on the old system's ID, remembers how you matched the columns, and the next file goes straight to the review.
See Importing from a Spreadsheet.
If you'd rather not do it yourself, email the spreadsheet to hello@orca-crm.com and we'll do it.
Connecting the System You're Moving From
Sign in to the old system once, and ORCA reads it directly: no files. It proposes where everything goes, shows you a preview, and brings it in. It can then keep ORCA in step every night until you switch over. ORCA only reads the other system, and never changes anything there.
Suits: moving from Zoho CRM, the first system ORCA can connect to. It's listed under Or connect the system you are moving from where it is switched on for your ORCA.
See Connecting Another System.
Your Own AI Assistant, Through the API
An AI assistant such as Claude can read your old system and bring its companies, contacts and records across through the ORCA API, then keep them in step until you switch over.
Suits: a system ORCA can't connect to, where you'd rather not export and tidy files by hand, or data that needs some sorting out on the way in.
Settings > API Keys makes a key for it, and has a prompt written for your account to hand over with the key. The prompt asks the assistant to show you what it would add and change, and wait for your go-ahead, before it writes anything.
See Handing ORCA to an AI agent, and Bringing data across from another system for the endpoints it uses.
Good to Know
- You need Settings access to update existing records, to connect a system, and to make an API key. Anyone who can create records in a section can add new ones from a spreadsheet.
- The old system wins until you switch over. While you're keeping ORCA in step, whether by loading a fresh file, a nightly connection or an assistant, the old system's values replace ORCA's in the fields being brought across. Make changes there, not in ORCA, until the day you move.
- The three can be mixed. A spreadsheet loaded with "Zoho" as its source and a Zoho connection recognise the same records by their Zoho IDs.
- Your rules still apply. Section access, sign-offs, barriers and frozen records hold on the way in, and anything that can't go in is skipped with its reason.
Related
- Importing from a Spreadsheet : the four steps, and updating existing records
- Connecting Another System : connecting Zoho CRM and keeping in step
- Using the ORCA API : API keys, the upsert endpoints and the AI agent prompt
- Your First Days : the guide new accounts start from
- Data Export : taking your data out again
