In sales, your focus should be on winning deals, not getting bogged down by tedious data administration. To streamline this process, we’ve developed an intuitive data upload feature that allows you to easily import your data into CRM As A Service. This functionality helps you eliminate manual data entry, saving time and enabling your team to concentrate on what really matters—closing deals.
This feature allows you to import your data from Excel or CSV files. Once your data is uploaded, it is instantly available in CRM As A Service.
In this step-by-step guide, I’ll show you how to upload your Leads, Contacts and Organizations into CRM As A Service. You can upload your Opportunities in similar way.
1. Prepare Your Data
Ensure your Customers information is structured correctly in your Excel / CSV file, a maximum size of 25 MB, with columns clearly labelled for each data point (e.g., name, email, phone number, company name, etc.). This helps the system map the fields properly. Few additional advice in your data preparation:
Remove Duplicates
Identify and eliminate duplicate records, such as repeated leads or contacts, to avoid confusion and redundancy in your CRM system.
Correct Incomplete or Inaccurate Data
Fill in missing fields where possible, and verify the accuracy of essential information like contact names, email addresses, and company names.
Remove Unnecessary Fields
Eliminate irrelevant columns or fields that are not needed in the CRM system to avoid clutter.
Check for Inactive or Old Data
Identify and remove outdated or inactive leads and contacts that are no longer relevant.
Ensure No Special Characters or Formatting Errors
Remove unnecessary special characters, extra spaces, or formatting inconsistencies that could cause issues during import.
2. Access the Upload Feature
Once logged into CRM As A Service, locate the toolbar at the left of your screen. Click on the Ellipsis (three-dot) icon to open the options menu, and click on the Import menu item.
3. Upload your file
Click on the Import button. A file explorer window opens. Locate your data file and click open. Make sure your file is either in Excel (.xlsx) or CSV (.csv) format.
4. Configure Field Mapping
You will be prompted to map the columns in your spreadsheet to the corresponding fields in CRM As A Service. Data in CRM As A Service is organized into the following entities: Organization, Contact, Lead, and Opportunity.
For example, you might map the "Company Name" column to the "Name" field under "Organization," and "Email Address" to the "Email" field under "Contact."
Accurate mapping is crucial to ensure your data is imported correctly and efficiently.
Once your fields are mapped, click the Next button to move forward with the import.
5. Preview Your Data
Before finalizing the import, you'll be presented with a preview of your data. Review the data to make sure everything looks correct. Verify that all columns are mapped properly and that no information is missing.
In case of duplicate data, you can choose whether to duplicate or merge it.