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 create a Excel file (ending with .xls or .xlsx extension), but it is quite difficult to achieve in most legacy applications.
Thus, the CSV format has come to stick, and is one of the most popular methods to transfer data from one application to another.
Microsoft Excel has the capability to read and create CSV files easily.
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.
Want to Improve Your Excel Skills?
Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.
To Get Most out of Excel, Learn the Pivot Table techniques in our
Pivot Table Masterclass Training!
How do you create a CSV file, which contains a long line, split into multiple rows?
Simply use Quotation marks to enclose the data which spills into multiple lines. see below:
Department, Status
Manufacturing,“No new issues.
Previous issues need to
be addressed”
Sales, “No issues”.
Once you load such a file into Excel, it will automatically show the complete data, in a single cell.
That’s it… it is such a simple and neat trick.. and helped me numerous times..
Additional Resources:
- ExcelChamp Video Tutorials on YouTube
- 2 Axis Charts in Excel
- How to Analyze Data Using Pivot Tables – Video
Enjoy,
Vinai Prakash
Are you facing any problem in using Excel? Any Question?
You have come to the right place. Tell us your needs. We’ll be glad to help you!
