{"id":84,"date":"2012-09-29T15:01:43","date_gmt":"2012-09-29T07:01:43","guid":{"rendered":"http:\/\/excelchamp.net\/?p=84"},"modified":"2022-07-11T06:27:42","modified_gmt":"2022-07-10T22:27:42","slug":"adding-line-breaks-in-a-csv-file","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/","title":{"rendered":"Adding Line Breaks in a CSV File"},"content":{"rendered":"<p>A <strong>CSV<\/strong> file is a <strong>C<\/strong>omma <strong>S<\/strong>eparated <strong>V<\/strong>alues file. And it can be opened very easily in Microsoft Excel.<\/p>\n<p>Most people use data files coming from main frame computers, or other external applications, and export the data in the CSV format, as it is easy to create, access and use. The other alternative is to create a Excel file (ending with .xls or .xlsx extension), but it is quite difficult to achieve in most legacy applications.<\/p>\n<p><strong>Thus, the CSV format has come to stick, and is one of the most popular methods to transfer data from one application to another.<\/strong><\/p>\n<p>Microsoft Excel has the capability to read and create CSV files easily.<\/p>\n<p>In Excel, you can write text in a any worksheet cell, and it can span into many lines. Sometimes, if you have a long comment, you can split it into different row lines also.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2012\/09\/multi-line-csv.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft size-full wp-image-85\" title=\"multi-line-csv\" alt=\"a long comment in excel, keyed in multiple lines, but in the same single cell\" src=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2012\/09\/multi-line-csv.jpg?resize=550%2C98\" width=\"550\" height=\"98\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"705\" class=\"elementor elementor-705 elementor-bc-flex-widget\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f5e9af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f5e9af\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6d494f\" data-id=\"f6d494f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db6834f elementor-widget elementor-widget-text-editor\" data-id=\"db6834f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div style=\"background-color: #ffffcc; color: black; border: thin Black; border-style: none; align = center; line-height: 27px; width: 95%; padding: 20px 30px 10px;\"><p style=\"text-align: center;\"><span style=\"color: #0000cd;\"><strong>Want to Improve Your Excel Skills?<\/strong><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">Learn the Key Features of Excel Quickly &amp; Easily, by <\/span><span style=\"color: #0000cd;\">Joining the<br \/> <a href=\"https:\/\/www.trueducate.com\/courses\/basic-excel-online\/\" target=\"_blank\" rel=\"noopener\"><u><strong>Online Training<\/strong> on <\/u><strong><u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">To Get Most out of Excel, Learn the\u00a0 <b><u><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table techniques in our<br \/> Pivot Table Masterclass Training<\/a><\/u><\/b><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<\/p>\n<p><strong><br \/>\nHow do you create a CSV file, which contains a long line, split into multiple rows?<\/strong><\/p>\n<p>Simply use \u00a0Quotation marks to enclose the data which spills into multiple lines. see below:<\/p>\n<p>Department, Status<br \/>\nManufacturing,<strong>&#8220;No new issues.<\/strong><br \/>\n<strong>Previous issues need to<\/strong><br \/>\n<strong>be addressed&#8221;<\/strong><br \/>\nSales, &#8220;No issues&#8221;.<\/p>\n<p>Once you load such a file into Excel, it will automatically show the complete data, in a single cell.<\/p>\n<p>That&#8217;s it&#8230; it is such a simple and neat trick.. and helped me numerous times..<\/p>\n<p><strong>Additional Resources:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/excelchamp\" target=\"_blank\" rel=\"noopener noreferrer\">ExcelChamp Video Tutorials on YouTube<\/a><\/li>\n<li><a href=\"http:\/\/excelchamp.net\/creating-a-two-axis-chart-in-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">2 Axis Charts in Excel<\/a><\/li>\n<li><a title=\"How to Analyze Data using Excel Pivot Tables\" href=\"http:\/\/excelchamp.net\/how-to-analyze-data-using-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Analyze Data Using Pivot Tables &#8211; Video<\/a><\/li>\n<\/ul>\n<p>Enjoy,<\/p>\n<p>Vinai Prakash<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"514\" class=\"elementor elementor-514\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14e69bc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14e69bc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f6f1ef\" data-id=\"31f6f1ef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b580a03 elementor-widget elementor-widget-heading\" data-id=\"3b580a03\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Are you facing any problem in using Excel?  Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2709bfb elementor-widget elementor-widget-text-editor\" data-id=\"2709bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #ff9900;\"><span class=\"st\">You have come to the right place<\/span>. Tell us your needs. We&#8217;ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e758d36 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"6e758d36\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Quick Enquiry\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"514\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6e758d36\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"ExcelChamp\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-field_1 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_1\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[field_1]\" id=\"form-field-field_1\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Name\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-field_2 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_2\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[field_2]\" id=\"form-field-field_2\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-field_3 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_3\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tQuestion\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[field_3]\" id=\"form-field-field_3\" rows=\"3\" placeholder=\"Question\" required=\"required\" aria-required=\"true\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_9c3764f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_9c3764f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6Let3GkeAAAAABfVEzbSL0GVAq2ejuG2VI3tGriG\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm elementor-animation-grow\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-align-icon-right elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Help Me Out<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A CSV file is a Comma Separated Values file. And it can be opened very easily in Microsoft Excel. Most people use data files coming from main frame computers, or other external applications, and export the data in the CSV format, as it is easy to create, access and use. The other alternative is to &#8230; <a title=\"Adding Line Breaks in a CSV File\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\" aria-label=\"More on Adding Line Breaks in a CSV File\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[5,6],"tags":[27,62],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net<\/title>\n<meta name=\"description\" content=\"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net\" \/>\n<meta property=\"og:description\" content=\"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-29T07:01:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-10T22:27:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/excelchamp.net\/wp-content\/uploads\/2012\/09\/multi-line-csv.jpg\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"Adding Line Breaks in a CSV File\",\"datePublished\":\"2012-09-29T07:01:43+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\"},\"wordCount\":262,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"CSV Line Breaks\",\"Long Text in CSV Files\"],\"articleSection\":[\"Excel Functions\",\"Excel In-Built Functionality\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\",\"url\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\",\"name\":\"How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2012-09-29T07:01:43+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"description\":\"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding Line Breaks in a CSV File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net","description":"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net","og_description":"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.","og_url":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2012-09-29T07:01:43+00:00","article_modified_time":"2022-07-10T22:27:42+00:00","og_image":[{"url":"http:\/\/excelchamp.net\/wp-content\/uploads\/2012\/09\/multi-line-csv.jpg"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"Adding Line Breaks in a CSV File","datePublished":"2012-09-29T07:01:43+00:00","dateModified":"2022-07-10T22:27:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/"},"wordCount":262,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["CSV Line Breaks","Long Text in CSV Files"],"articleSection":["Excel Functions","Excel In-Built Functionality"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/","url":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/","name":"How To Add Line Breaks in a CSV File - Excel Tips@ExcelChamp.Net","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2012-09-29T07:01:43+00:00","dateModified":"2022-07-10T22:27:42+00:00","description":"How to add line breaks in Excel Comma Seperated Values (CSV Files). Simply use a Double Quote.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/adding-line-breaks-in-a-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"Adding Line Breaks in a CSV File"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/84"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":1,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":1694,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/84\/revisions\/1694"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}