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
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.
Please post comment in this
article if you know any other working way.
