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? - Forcetalks

Tagged: Carriage Return, CSV File, Data Export, Google Drive, Microsoft Excel, Record ID, Salesforce Dataloader

Salesforce® Discussions

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?

Posted by Aman on September 22, 2018 at 6:20 PM

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 ?

Parul replied 7 years, 7 months ago 2 Members · 1 Reply
1 Reply

Parul

Member
September 23, 2018 at 6:26 AM

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.