-
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
Salesforce and DocuSign Integration
DocuSign is a product that provides the facility of a digital signature of the document. Salesforce.com is a cloud-based customer relationship management (CRM) software solution for sales, service,…
Learn About Lightning Design System in Salesforce
What is the Salesforce Lightning Design System? Should I use it? It's easy to forget the days before Bootstrap when web developers had to painstakingly…
Inserting Records in Account or (any other sObject) Through Postman in Salesforce
We are using postman from API testing and request management to hit API by get or post and received data in the form of JSON…
Popular Salesforce Videos
Lesser Known VSCode Tips for Salesforce Developers
More Code, Less Work. Whether you are a beginner or an advanced developer, smart tips, and sharp tools can significantly improve your productivity. There are…
Wildcards in SOSL | Clauses in SOSL | Learn Salesforce Development
In this video, Shrey covered Wildcards in SOSL in Salesforce. And also you will learn: What are the different Wildcards in SOSL? What are Clauses…
Escalation Rule in Salesforce
In this video, Shrey is not only teaching but also demonstrating Escalation Rule in Salesforce. 1. What are Escalation Rules in Salesforce? 2. What is…
