-
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 Integration Services: 7 Popular Apps for Salesforce Integration with Service Cloud
In today's digital world, Salesforce Service Cloud is considered to be the world's best solution for effective customer service. Do you know why? The answer…
5 Key Benefits of Salesforce CPQ to Your Sales Team
Salesforce CPQ increases the efficiency of the sales team by creating quotes that are curated with the diverse knowledge all brought to one place which…
Salesforce Summer '25 Highlights
Summer is nearly here, and Salesforce's Summer '25 release update means there's more to look forward to than the sun and the beach. Whether you've…
Popular Salesforce Videos
Common Salesforce Project Risks and How to Mitigate Them
Salesforce is easy to use, but don’t let its user-friendly interface fool you. Deploying Salesforce projects takes planning to be effective. Otherwise, you expose your…
How to Connect Salesforce Billing Payment Gateways (COMPILATION)
In this compilation, we’ll show you what you need to know about using your preferred payment gateway with Salesforce Billing + CPQ - like how…
How to Report on the Reports in Your Salesforce Org
Do you want a list of all the reports in your Salesforce org? Would you like to see a list of reports and the last…
