How do I export CRM data and garbled foreign characters?

How do I export CRM data and garbled foreign characters?

For Excel 2003

1. Open Microsoft Excel.
2. Data - Import External Data - Import Data.
3. Choose the file.
4. In Text Import Wizard Choose 'Delimited' as 'Original data type'.
5. Choose UTF-8 from the File-origin List box.
6. Click Next.
7. Choose 'Comma' as 'Delimiters'.
8. Click Next.
9. Choose 'Text' as 'Column data format' by selecting each column from Data Preview.
10. Click Finish and open in New Work Sheet.

For Excel 2007 & 2010

1. Open Microsoft Excel.
2. Data - From Text.
3. Choose the file.
4. In Text Import Wizard Choose 'Delimited' as 'Original data type'.
5. Choose UTF-8 from the File-origin List box.
6. Click Next.
7. Choose 'Comma' as 'Delimiters'.
8. Click Next.
9. Choose 'Text' as 'Column data format' by selecting each column from Data Preview.
10. Click Finish and open in New Work Sheet.

    • Related Articles

    • Troubleshooting Data Import and Export

      1. When I try to import leads, I get an error message which says "Duplicate record exist in system: Email." I've checked my CRM data and there is no duplicate record with the same email address. How do I resolve this? Once you have ensured there is ...

    • How do I export my leads from CRM to an XLS file?

      You can export the leads in your account to an XLS file using reports. To export leads: Go to the Reports module and click Create Report. Select the Leads module and choose a report type, e.g. Tabular. Select the fields you want to add to your ...

    • Can I sync data between multiple CRM accounts?

      No, the multi-org functionality does not allow any kind of data sync between the orgs. The sole purpose of creating multiple accounts is to provide users with ease of access. You can however, import/export data or use functions to transfer data ...

    • Can I move deals to a particular pipeline and assign a stage during data migration or import?

      Migrating from another CRM: When you migrate from another CRM, the Pipeline field will be available during field mapping. The deals will be assigned to the layout's pipeline based on this field. If the deals that are to be migrated do not have a ...

    • How can I export data from reports in Zoho CRM?

      You can export data from the modules as well as reports. In case of reports, you can export the data in three different formats - Excel, CSV and PDF. Each one of them have different export limits. Export limit In PDF and Excel formats you can export ...