Importing and Exporting customer data

Importing Data

You can import contact and company information from a CSV into your Freshdesk account. Importing customer data allows you to make bulk updates and additions to your database with ease.

You can also import all the custom fields you have in both contacts and companies.

Before you import data, make sure that the CSV file follows these guidelines: 

  • The first line of the CSV file is the column header which contains the fields names like Name, Email, Title, etc.
  • The CSV file must contain Name and Email address or Name and Phone number, without which the contacts will not be imported.
  • The email address and URL should be in the correct format. (Example - sample@freshdesk.com and http://freshdesk.com/ or https://freshdesk.com/)Please note that the email address is the unique identifier. This allows you to have multiple contacts with the same name as long the email address provided is different. Also please note that if the CSV file contains an email address of an existing contact in Freshdesk, the import will overwrite the existing contact.If you have more than one email address associated with a contact, please use the format given in the screenshot below to make sure data import is completed properly. You can add upto 9 secondary emails for one contact apart from the 1 primary email, allowing a contact to have 10 emails associated with it.
  • Please note that the email address is the unique identifier. This allows you to have multiple contacts with the same name as long the email address provided is different. Also please note that if the CSV file contains an email address of an existing contact in Freshdesk, the import will overwrite the existing contact.
  • If you have more than one email address associated with a contact, please use the format given in the screenshot below to make sure data import is completed properly. You can add upto 9 secondary emails for one contact apart from the 1 primary email, allowing a contact to have 10 emails associated with it.
  • In order for the phone channel in Freshdesk to recognize your phone numbers, you should have the country code clearly specified. For example, 4088481234 or 408-848-1234 should be written as +14088481234 in your CSV file before you import into Freshdesk.
  • If you have more than one company associated with a contact, kindly use the format given in the screenshot below to make sure data import is completed properly. Customers can now send yes || no || yes for each company to see all tickets from the company. (This feature is available only if you have enabled one contact multiple companies feature.) 
  • Value of a dropdown field should only be the choices available for that particular field in the helpdesk.
  • The existing details of contacts and companies will be overwritten/updated after an import.
  • A checkbox field only accepts yes or no. Any other value encountered during the import will be considered as no. 
  • If you have a tag field with multiple tags, every tag should be separated by a comma.
  • Please ensure that your CSV file is in UTF-8 format and the first row has the header information (example: name, email, phone etc.)

Note: The first company in the company column in the CSV will be made the primary company for that contact.

To import customer data into your helpdesk:

  • Go to the Contacts > Import button. To import Companies, use the same button in the Companies page (accessible via the hamburger icon in the upper-left corner of the page).
  • Click on Upload a File. Navigate to where the CSV file is located on your computer and select it. 
  • If you have custom fields in your CSV file, ensure that those fields are first added to Freshdesk before you import. Go to Admin > Support Operations > Customer Fields to add custom fields.
  • After you map the information, click on the Import button and wait for Freshdesk to finish importing the data. It will not take more than a few moments.
  • If you want to import company information of the customer, you will have to add a company column in your CSV. If the company name in the CSV does not exist in your helpdesk, a new company will be created.
  • If you are trying to import contacts in bulk, you can refer to this article for the various timezones and languages that you can use in your CSV for the configuration.
  • Once you are done, you will receive an email about the status of the import. The import of fields which does not follow the guidelines listed above will fail. The failed rows will be attached to the status email as a CSV file and it will contain the reason for the failure. 

Note: You need to have at least 10 tickets in your Freshdesk account to import your contacts successfully.

Exporting Data

You can export your customer data as a CSV file at any time. To start exporting:

  • Go to the Contacts tab in your helpdesk.
  • Click on Export.
  • Select the fields you wish to export. (Custom fields that you've created will also be seen.)
  • Click on the Export button.
  • A file containing all the data that you selected will be sent to your helpdesk's associated email address.

You can export company information by clicking on the Companies option from the left corner of the Contact page (using the hamburger icon) and then follow the same procedure. Exported data will be sent to you through email.

Note: Exporting based on the tags added for each contact is currently not an option. It can be filtered through the UI but, upon exporting, the entire contact list will be exported and not just the contacts associated with the chosen tag.

Generating a sample file:In order to make sure all the fields (default and custom) are available in your CSV import file, you can trigger a sample Contacts/Companies export, edit the file and then use this file for your import.

The account admin can schedule an export of the helpdesk data by following the steps mentioned in this video:

https://www.youtube.com/watch?v=DTa_LDg8vng&list=PLsYJ3BsyR4qGFujlW0iDtOBOf4IPVsAqt&index=11

Freshdesk – Seamless Customer Support Made Easy

Freshdesk by Freshworks is an award-winning, cloud-based customer support solution that equips you with all the tools needed to deliver outstanding and efficient customerΒ service.

Freshdesk Products
Customer Data Management

Import and export customer data easily

πŸ‘‰ Learn More
Helpdesk activity checking

Reviewing the latest support tickets and helpdesk interactions.

πŸ‘‰ Learn More
One contact across multiple companies

Linking a single contact to multiple associated companies.

πŸ‘‰ Learn More
Sender name customisation

Using sender's name as ticket requester in forwarded emails

πŸ‘‰ Learn More
Finding API Key

Steps to locate and access your API key from your account settings.

πŸ‘‰ Learn More
Knowledge base setting

Guidelines to create and organize your Knowledge Base for easy customer access.

πŸ‘‰ Learn More
Organising agents into group

Grouping support agents based on roles or departments for better workflow Management

πŸ‘‰ Learn More
setting up sand box

Instructions to configure your Sandbox environment for safe testing and development.

πŸ‘‰ Learn More
Freshdesk help widget on WordPress

Steps to embed and display the Freshdesk help widget on your WordPress site.

πŸ‘‰ Learn More
Default fields in ticket form

Overview of the standard fields included in your Freshdesk ticket form by default.

πŸ‘‰ Learn More
Configure custom email server

How to configure custom email servers for sending and receiving support emails.

πŸ‘‰ Learn More
Run automation on ticket

Set up automation rules for tickets submitted via a specific form.

πŸ‘‰ Learn More
Merging contacts

Combining duplicate contacts into a single profile in Freshdesk.

πŸ‘‰ Learn More
Freshdesk Multilingual ticket fields & forms

Creating and managing ticket fields and forms in multiple languages in Freshdesk.

πŸ‘‰ Learn More
Creating companies and contacts

Steps to create and manage companies and their associated contacts in Freshdesk.

πŸ‘‰ Learn More
Freshdesk App Log in & Log out

Instructions for logging in and out of the Freshdesk Android mobile app.

πŸ‘‰ Learn More
Forward Emails as Tickets

Forward and convert your support emails to tickets in Freshdesk

πŸ‘‰ Learn More
Freshdesk help widget setup

Steps to configure and customize your Freshdesk help widget for your website

πŸ‘‰ Learn More
Freshdesk - Freddy self service

Guide to creating a basic bot flow using Freddy Self-service in Freshdesk.

πŸ‘‰ Learn More
Freshdesk - Feedback Widget

Collecting user feedback directly from your website using the feedback widget.

πŸ‘‰ Learn More
Custom field creation

adding and configuring custom fields in your Freshdesk ticket form.

πŸ‘‰ Learn More
Adding new support agents

Steps to add and manage new support agents in your Freshdesk account.

πŸ‘‰ Learn More
Custom Support using Customer Segments

Use Customer Segments to tailor and personalize your support responses in Freshdesk.

πŸ‘‰ Learn More
Customer portal - Log in & Access

Instructions for logging in and navigating the Freshdesk customer support portal.

πŸ‘‰ Learn More
Freshdesk - Customer Tab

Overview of the Customers tab features for managing contacts and companies in Freshdesk

πŸ‘‰ Learn More
Freshdesk - Ticket Status

Explanation of different ticket statuses and their roles in the support workflow.

πŸ‘‰ Learn More
Multiple ticket forms - Freshdesk

Overview of using multiple ticket forms in Freshdesk to handle various support queries.

πŸ‘‰ Learn More
Customer tickets - Auto solve

Set up the Email Bot to automatically resolve customer tickets based on predefined rules.

πŸ‘‰ Learn More
Live Chat - Freshdesk

Using live chat as a support channel in Freshdesk for real-time customer assistance.

πŸ‘‰ Learn More
Field service management - Freshdesk

Overview of Field Service Management in Freshdesk for managing on-site service

πŸ‘‰ Learn More
Freshdesk Reporting & Analytics

Gain insights and track performance metrics using Freshdesk Analytics for smarter support decisions.

πŸ‘‰ Learn More
Dependant field in ticket forms

Configure dependent fields in your Freshdesk ticket form to show relevant options based on user input.

πŸ‘‰ Learn More
Single Sign-On in Freshdesk

Enable Single Sign-On (SSO) in Freshdesk for seamless and secure user authentication.

πŸ‘‰ Learn More
Multi-channel support

Provide customer support across multiple channels like email, chat, phone, and social media in Freshdesk.

πŸ‘‰ Learn More
Multi-channel support

Provide customer support across multiple channels like email, chat, phone, and social media in Freshdesk.

πŸ‘‰ Learn More
Adding twitter accounts - Freshdesk

Connect your Twitter account to Freshdesk to manage and respond to tweets as support tickets

πŸ‘‰ Learn More
Ticket submitting via email

Allow customers to create support tickets by sending an email to your Freshdesk support address.

πŸ‘‰ Learn More
Adding phone channels - Freshdesk

Integrate a phone channel into Freshdesk to handle voice calls as part of your support system.

πŸ‘‰ Learn More
Editing, cloning and deleting a ticket form

Manage your Freshdesk ticket forms by editing,duplicating, or deleting them as needed.

πŸ‘‰ Learn More
Adding new customer agents

Learn how to invite and set up new support agents in Freshdesk to handle customer queries efficiently.

πŸ‘‰ Learn More
Freshdesk Automation updates

Review the latest updates and improvements to Freshdesk’s automation features for better ticket management.

πŸ‘‰ Learn More
Dynamic sections - Freshdesk

Learn to build dynamic sections in Freshdesk forms that display fields based on user input or conditions.

πŸ‘‰ Learn More
Customizing Customer Fields

Modify and manage customer fields in Freshdesk to capture specific information relevant to your business needs.

πŸ‘‰ Learn More
Help Desk Reporting Best Practices: 7 Essential Tips

Discover key strategies to optimize your help desk reports, improve decision-making, and enhance customer support efficiency.

πŸ‘‰ Learn More
Customer 360 – Get Complete Context on Your Customer

Gain a holistic view of each customer with Customer 360 in Freshdesk, consolidating interactions, tickets, and data for personalized support.

πŸ‘‰ Learn More
Understanding Full-time vs Occasional Agents

Learn the difference between full-time and occasional agents in Freshdesk to manage roles, access, and billing effectively.

πŸ‘‰ Learn More
Introduction to Apps

Explore how Freshdesk apps enhance your helpdesk by adding new features, integrations, and custom workflows

πŸ‘‰ Learn More
Creating a New Ticket from Agent Portal

Learn how agents can manually create support tickets directly from the Freshdesk agent portal.

πŸ‘‰ Learn More
User Guide Template Example

Explore a sample user guide template that outlines structure, formatting, and content flow for creating effective documentation.

πŸ‘‰ Learn More
Getting Started with FreshThemes

Learn how to customize your Freshdesk portal’s appearance using FreshThemes for a branded support experience.

πŸ‘‰ Learn More
Changing Customer Password

Guide to help customers reset or change their Freshdesk portal password securely.

πŸ‘‰ Learn More
Identifying Contacts with an External ID

Learn how to use external IDs in Freshdesk to match and manage contacts from third-party systems.

πŸ‘‰ Learn More
Getting-started-multiple-customer-support-agents
πŸ‘‰ Learn More
Manually Create Tickets from the Agent Portal
πŸ‘‰ Learn More
Getting-started-multiple-customer-occasional-agents
πŸ‘‰ Learn More

Search, compare & buy top business software with FGRADE. Find the best deals on Microsoft 365, Zoho, Google Workspace & more. Shop smart & save big!

Office Address

AWFIS, Ground Floor, DSL abacus it park, Survey Colony, Industrial Development Area, Uppal, Hyderabad, Telangana 500039

Call us: +91 916 056 5554

Email: sales@fgrade.com