-
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
Using CRON Expression in Salesforce
Hello to all the salesforce developers, here in this blog I am covering a very crucial topic that we all use in our coding skills…
Success Stories – How DemandBlue Helped Its Clients Improve Revenue Recognition with Salesforce Revenue Cloud Implementation
Businesses that deal with subscription-based contracts, usage-based billing or other complex contracts face several difficulties in managing their billing cycle. Though Salesforce CPQ implementation does the heavy-lifting…
Leverage the Power of Personalization with Salesforce Marketing Cloud
Reaching out to the customers with the right content at the right time through their preferred platform is the key to ensuring a delightful experience.…
Popular Salesforce Videos
What Is Loyalty Management in Salesforce? | Video Tutorial
In the past few years, we have come across terms such as loyalty programs and loyalty management. Let's understand the concept of loyalty management with…
2020 Salesforce Administrator Certification Start Here
Get ready for the administrator certification exam with interactive study tools. Collaborate and study with fellow Trailblazers in the Trailblazer Community. Learn with Salesforce experts…
Create Your First Salesforce App in 30 Minutes
In this session, we will design, build and deploy a Salesforce App in 30 minutes using the low code and Salesforce modern developer tooling. Presenter…