-
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
A Complete Guide to Salesforce Development Services for Growing Businesses
Nowadays, businesses are growing faster than ever. Managing operations manually makes the process slower, and it is no longer sufficient. Fortune Business Insights projects the…
Schedule Your Path in Salesforce Flow | Developer Guide
Advantages of Flow Builder over Process Builder Process builder does work on delete the records Flow work on a different object while Process Builder only…
DevOps for the Salesforce Ecosystem
The following is a summary of the information covered in the webinar: DevOps for the Salesforce Ecosystem. Modern IT Transformation Overwhelmingly, organizations are needing to…
Popular Salesforce Videos
Highlights of the Salesforce Winter '22 Release for Nonprofits
The video includes both Winter ‘22 Salesforce Platform updates and Nonprofit Cloud tools. Chapters: 0:00 General Salesforce.com Platform Updates 8:13 Salesforce.com Release for Fundraising and…
Salesforce Service Cloud Einstein Bots
Learn how to set up and use Einstein Bots to increase case deflection and reduce service costs through self-service. This webinar gives you a guided…
Introduction to Lightning Web Components: A Practical Example
In this session, Alba Rivas will show how to build a page step-by-step in Lightning Web Components. You will learn some of the basics of…