24th October 2018

ablebits
13

How do I create a CSV file in Excel?

How to convert Excel file to CSV
  1. In your Excel workbook, switch to the File tab, and then click Save As.
  2. In the Save as type box, choose to save your Excel file as CSV (Comma delimited).
  3. Choose the destination folder where you want to save your Excel file in the CSV format, and then click Save.

Subsequently, one may also ask, what is meant by CSV file?

A CSV is a comma separated values file which allows data to be saved in a table structured format. CSVs look like a garden-variety spreadsheet but with a .csv extension. Traditionally they take the form of a text file containing information separated by commas, hence the name.

What is a CSV file and how do I open it?

A CSV file can be opened in any program, however, for most users, a CSV file is best viewed through a spreadsheet program such as Microsoft Excel, Open Office Calc or Google Docs.

Why would you use a CSV file?

A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a .csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.
Write Your Answer

Rate

80% people found this answer useful, click to cast your vote.

4 / 5 based on 2 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share