-
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 Data Cleansing Guide
The Salesforce data cleansing process involves identifying, correcting, and maintaining accurate and consistent data within the Salesforce platform. Data cleansing is essential to ensure the…
Sales Cloud in Salesforce - All About it!
Every business needs various Salesforce products and services to support and manage its operations. Sales Cloud, Service Cloud, Marketing Cloud, Analytics Cloud, Community Cloud, App…
How can Salesforce CRM be used for Small Businesses?
With straightforward tools, a connected app, and Salesforce dashboards & analytics, small businesses can develop a thorough picture of their present and potential customers. By…
Popular Salesforce Videos
Salesforce Consent Management
Consent Management: Track Customer Consent and Honor Opt-Out Requests. Track your customers' approval for how your company interacts with them. To help you assess your…
TrailheaDX '18 Opening Keynote - Part 2: Salesforce Platform
Salesforce TrailheaDX ’18 Opening Keynote – Part 1: Create Connected Customer Experiences TrailheaDX ’18 Opening Keynote – Part 3: Connect Every Experience Salesforce TrailheaDX ’18…
Easy Way to Learn Salesforce | How to Learn Salesforce Step by Step
In this video on Easy Way to Learn Salesforce, you will learn introduction to Salesforce, how to learn Salesforce easily, Salesforce as Career and Growth,…
