What is a CSV file?
A CSV or "Character Separated Value" file allows for storing and exporting tabular information (rows and columns) without formatting. This allows for quick extraction of the information from a database to a spreadsheet program, i.e. Excel.
How To Convert The Data To Columns
Follow the steps below to convert the row information to table form with rows and columns.
1 -Select the column containing information (usually column A)
2 - Click on "Data"
3 -Click on "Text to Columns" to bring up the wizard
4 -Select "Delimited"
5 -Click on "Next"
6 -Select "Comma"
7 -Click on "Finish"
Please note that you should now save the file in Excel format to preserve this formatting.
Please sign in to leave a comment.