-
Data Export using DataLoader causes data to be on New Line when we open CSV file in Excel. How can we override this in Salesforce?
After Data Export using DataLoader, Some time it appears that data is on New Line (Carriage Return) when we open CSV file in Microsoft Excel. For example, Address Data separated on different lines. How can we override this problem ?
-
1 Reply
-
Excel does all sorts of “useful” things when it opens a CSV file. It will re-format dates, strip leading zeros, corrupt record IDs (if you have them in your report), and as explained it will also break line. Best way as per my experience till date is, Upload document to Google Drive. Export document back from Google drive as Excel.
Log In to reply.
Popular Salesforce Blogs
Optimization of Salesforce Org - Everything You Need to Know
In this blog we’ll learn about Optimization, why is it necessary, how can we optimize apex class, the highest execution duration of an apex class,…
The Impact of Salesforce Certification on Your Salesforce Career
Introduction In today's fast-paced and highly competitive job market, having a Salesforce certification can make all the difference in your Salesforce career. Whether you're already…
Sales Cloud in Salesforce - All About it!
Every business needs various Salesforce products and services to support and manage its operations. Sales Cloud, Service Cloud, Marketing Cloud, Analytics Cloud, Community Cloud, App…
Popular Salesforce Videos
Salesforce Data Management - Data Loader - Insert, Update, Upsert, Export, Delete
Use the Data Loader wizards to add, modify, or delete records. The upsert wizard combines inserting and updating a record. If a record in your…
What is Salesforce? | Why is it So Good ? | High Demand Skills
In this video, Technical Suneja explains what Salesforce is and why it is such a valuable skill set to have. He goes into detail about…
Salesforce JMS Integration Using MuleSoft | Salesforce Tutorial
Salesforce JMS Integration. In this video, the following points will be covered - 1. Introduction Learn how to use queues to integrate data in Salesforce.…
