-
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
Hire a Salesforce Sales Cloud Developer for Growth
In today's fast-moving business environment, companies need a robust solution to manage sales teams, customer relationships, and revenue pipelines. That’s why many are turning to…
Component Event Propagation in Salesforce - A Short Guide
The framework supports capturing and bubbling phases for component event propagation. These stages mimic the DOM processing pattern and give interested components a way to…
Why Salesforce Implementations Fail and How Business Assessment Can Help You Achieve Success
The saying “no pain, no gain” came up a long time ago, but it seems like it was something that goes well for Salesforce implementations…
Popular Salesforce Videos
Creating leads using Amazon Alexa with salesforce.
Amazon EchoAmazon Echo is a voice command device with functions like question answering, playing music and controlling smart devices. Echo connects to Alexa which is…
Salesforce Chatter Tutorial | Chatter Overview And Demo | Chatter In Salesforce
This Salesforce Chatter Tutorial will give an overview of Chatter which includes enabling chatter, configuring chatter groups and creating customer groups. Salesforce Chatter will be…
Salesforce on Salesforce: How Salesforce Uses Trailhead to Drive Enablement
With Trailhead, Salesforce is transforming the learning experience for our employees at every step of their career journey. Join us to learn tips, tricks and…
