Skip to content
Office

Office CRM feature

Import from Zoho CRM and spreadsheets

Bring your data over from Zoho CRM or a spreadsheet with columns already mapped, and undo the whole import if it's wrong.

Spreadsheets in

Import CSV or Excel files for leads, deals, contacts, companies and products. Columns map automatically by name, and you fix any that didn't. Owners match by email or name; pipelines and stages match by name and can be created as part of the import. For each import you decide what happens with rows that match an existing record: skip, update or create.

Imports run in the background with a progress bar, a summary at the end, and a file of any rows that failed and why. Each record type has a sample file to start from.

Zoho CRM, recognized

Export your modules from Zoho CRM and upload the files. Zoho's column names are detected and mapped, "Closed Won" and "Closed Lost" become Won and Lost, and contacts and deals link up by Account Name and Contact Name. Each Zoho Record Id is kept, so running the same import again updates records instead of doubling them, and the original Created Time is preserved.

Revert for 30 days

Import history lists every import. Revert one within 30 days and it removes only the records that import created and nobody has changed or used since.

And out again

Export any list (its filters and columns, or a selection) to CSV whenever you want. Your data is yours.

Example

Moving a 6-person team off Zoho CRM

Acme Studio exports Accounts, Contacts and Deals from Zoho CRM. They import Accounts first (412 companies), then Contacts (1,180, linked to their companies by Account Name), then Deals (96, with stages matched by name and two new stages created). One deal file had the wrong date format; the error file lists 7 rows, they fix them and import those again. Total time: about 20 minutes.

How to set it up

  1. 1

    In Zoho CRM, export each module you want (Accounts, Contacts, Leads, Deals, Products) to CSV.

  2. 2

    Open Import and export, click Import, and pick the record type.

  3. 3

    Upload the file, check the mapping, choose how to handle matches, and start.

  4. 4

    Import companies before contacts, and contacts before deals, so the links connect.

Import from Zoho CRM and spreadsheets is part of Office CRM and included on every plan.

Questions people ask

Do you have presets for Pipedrive and HubSpot?

They're coming soon. Their CSV exports import today with a quick check of the column mapping.

Do notes and emails come across from Zoho?

Records and their fields come across today. Importing notes, tasks and calls for migrations is coming soon.

Try Office CRM with your whole team

7-day trial with every feature. Cancel from the billing page whenever you like.