-
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 Custom Objects and Behavior - All You Need to Know
At the point when you make or empower highlights for a custom article, Salesforce makes elements to help your custom item. For instance, when you…
An Overview of Salesforce Einstein Analytics
In this top blog on Salesforce, we will be discussing Salesforce Einstein Analytics and what it is, how it works, and more. Salesforce Einstein Analytics…
Salesforce Spring ’19 Release – Key Points
The first Salesforce release for 2019 is now installed in your org, ready for you to take advantage of these exciting new features. Sales Cloud Features…
Popular Salesforce Videos
Dynamic Action in Salesforce | Salesforce Tutorial
In this video, we are going to talk all about dynamic actions in Salesforce. 00:00 Introduction 00:57 Work with Dynamic Action 05:05 Dynamic Actions in…
Salesforce for Manufacturing: How to Digitize Your Sales Processes
As a manufacturing sales leader, you’re looking for ways to go digital with your sales processes and improve channel performance. In this video, you’ll learn…
Understanding Salesforce Field Service Mobile App - An Overview | AblyPro
Field Service mobile app is an all-in-one tool designed for today’s mobile workforce. Salesforce Field Service Mobile App is an innovative tool designed to help…
