Tuesday, January 28, 2014

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

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.
  

8 comments:

  1. There is certainly a great deal to find out about this topic. I love all of the points you have made.
    Video watch online

    ReplyDelete
  2. I’m amazed, I must say. Rarely do I come across a blog that’s equally educative and entertaining, and without a doubt, you have hit the nail on the head. The issue is something that not enough folks are speaking intelligently about. Now i'm very happy I stumbled across this during my hunt for something concerning this.Watch Online Pinoy Shows

    ReplyDelete
  3. You can try loading that in MS Access as well, it also doesn't misbehave with your csv.

    ReplyDelete
  4. It was thinking about whether I could utilize this review on my other site, I will connect it back to your site though. Great Thanks.
    Devilish Joy

    ReplyDelete
  5. website is looking bit flashy and it catches the visitors eyes. Design is pretty simple
    https://dramaidea.org

    ReplyDelete
  6. Very nice blog. Doing a great job as always


    thanq.

    BEST Packers And Movers is a Vijayawada based reliable packing and moving company. It provides you trustworthy relocation services, transportation services, warehousing, and storage services. While choosing Movers and Packers, people are worried about the safety of goods, but Online Cargo Packers And Movers handle your goods carefully and shift with utmost care. BEST Packers And Movers provide packers and movers services everywher in India, namely, Delhi, Gurgaon, Mumbai, Jaipur, Pune, Kolkata, Chennai, Chandigarh, Vadodara, Surat Bangalore. We have self-kept trucks and laborers to manage your goods in a more effective and professional way.

    https://g.co/kgs/D2d3Vh.


    https://g.co/kgs/TJzchD


    https://wap.justdial.com/edit-list/Vijayawada/Best-Packers-Movers/0866PX866-X866-140526104938-V1X1

    https://bestpackersmoversindia.com/

    https://m.facebook.com/Packers.movers.vij/?ref=bookmarks

    https://mobile.twitter.com/BestPackersand2

    https://best-packers-and-movers.ueniweb.com

    ReplyDelete
  7. Looking for professional and licensed verified Packers and Movers at an affordable cost?
    Your search ends here... Hire the most licensed and verified packers and movers at an affordable cost and save money, compare the quotes with the top 3 competitors and choose the best one!
    100% Licensed & verified Transporters in India

    Packers and Movers India | Licensed Transporters | Hassle-free relocation
    Call now : 8886663106

    Packers and Movers Hyderabad
    Packers and Movers Bangalore
    Best Packers and Movers in Vizag
    Packers and Movers Kolkata
    Packers and Movers Mumbai

    ReplyDelete