-
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
Choosing the Right Salesforce Managed Services Provider: Tips and Tricks
Salesforce has become the backbone of customer relationship management (CRM) for many businesses, offering a powerful platform to manage customer interactions, streamline operations, and drive…
Salesforce IoT Cloud: Benefits and Limitations
Salesforce IoT Cloud: It provides the platform to store and process the IoT data. It enables you to combine event data from devices with existing…
How to convert BAK file into CSV using ACT EXPORTER TOOL and import in to salesforce
In this Blog, you will learn, how to use the Exporter tool. The Exporter tool allows us to take the client's ACT database BAK files…
Popular Salesforce Videos
BradForce Interview with special guest Jason Jung | Landing Your First Salesforce Job
In this video, I have a great conversation with Jason Jung. Jason landed his first Salesforce Job in the middle of a global pandemic. Listen…
Salesforce Customer 360 - It Brings Your Company & Customers Together
Q: With a dispersed workforce, how do you bring all departments together with a single shared view of your customer? A: With Salesforce Customer 360.…
Salesforce Development Master Training | Salesforce Development Course
Shrey Finally launched the most awaited Salesforce Development Master Training. Features of the course are: Learn Salesforce Development from Scratch with more than 100 on-demand…
