Activity Forums 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?

  • 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.

Popular Salesforce Blogs

Popular Salesforce Videos