-
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 Administrator Exam Practice Quiz
Question 1: What is the maximum number of characters allowed for a custom text field in Salesforce? A) 50 characters B) 255 characters C) 500…
Salesforce Agentforce: Revolutionizing Customer Service
In today’s fast-paced digital world, companies are constantly searching for efficient ways to streamline operations, enhance customer service, and drive productivity. For organizations heavily…
Introduction of Lightning Component Framework
Lightning component framework is a UI framework to develop dynamic mobile and desktop app. This is the framework for building single page application. In this…
Popular Salesforce Videos
360 SMS App Demo
360 SMS App is considered to be the most reliable Salesforce SMS App. This App is listed on the AppExchange from the name "360 SMS…
3 Easy to Use Salesforce Field Service Dashboards | AblyPro- Live Webinar
Watch AblyPro's exciting webinar video on Salesforce Field Service Reports & Dashboards. Discover how these powerful tools can drive efficiency and cut support costs for…
Customize Salesforce in a Flash with Lightning
This video shows you how to use Lightning App Builder to make page customizations without any code. This enables admins to tailor Lightning Experience for…
