-
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
From Transactions to Relationships: How Salesforce Builds Customer Loyalty in Financial Services
In times of cutthroat competition, the financial industry holding on to loyal customers is a rare sight to find. One reason for this is that…
Why Growing Businesses Are Shifting to Custom CRM Development
Summary As businesses grow, their CRM needs evolve beyond what generic tools can handle. This blog explores why many are choosing Custom CRM Solutions—covering key…
Salesforce Integration Cloud: Accelerating Customer’s Digital Transformation
The connoisseurs of Salesforce were totally intrigued by the acquisition of Mulesoft for a whopping $6.5B, and the excitement reached its peak with the announcement…
Popular Salesforce Videos
How Easy (or Difficult) is it to Transition from Salesforce Classic to Lightning Experience?
This video answers the question of: How Do You Transition Your Company from Salesforce Classic to Lightning Experience? ▪️ How difficult is it? ▪️ How long should…
ampus Plus: Salesforce Grants Management System (GMS) Testimonial | TechForce Services
Hear from Campus Plus on their game-changing Grants Management System (GMS) built on Salesforce by TechForce Services! They replaced spreadsheets and siloed forms with a…
Easy Salesforce Lightning Experience Tricks for Admins
Learn how to enhance the screens for your end users by leveraging Related List - Quick Links, Report Charts and dynamic filters to show the…
