-
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
How to implement Salesforce Communities
Salesforce Communities is now considered as an important requirement that helps businesses to establish a connection with their customers, partners as well as employees. Specific…
SSO Implementation between two Salesforce Orgs in Lightning and Classic view
We can implement SSO for both Lighting and Classic view with the help of SAML. There is no difference between security protocol for both. Requirement:…
REST API in Salesforce | The Ultimate Guide
What is REST API? REST stands for Representational State Transfer, which is a web architecture that uses HTTP protocols to access and manipulate resources. REST…
Popular Salesforce Videos
The Salesforce Team is Talking About What Working for Salesforce is Like
The Salesforce team is talking about what working for Salesforce is like. Watch this video learn about their experience.
Girikon Salesforce Expertise - Salesforce Silver Consulting Partner
Girikon has experienced and certified Salesforce Consultants are available to meet your entire gamut of Salesforce Implementation, Development, Customization, Integration and Support needs. Get salesforce…
Enable Salesforce Einstein Lead Scoring with Less Data - Winter 21
Previously we needed a minimum of 1000 new leads and 120 lead conversions in the previous 6 months to calculate the lead scoring. With Winter…
