At times, you may want to save workbook data in the CSV fileformat. CSV is a simple file format that can be used to store tabulardata. It is used to export workbook data without any formatting orstyles so that it can be easily imported into various applications andthen transformed and analyzed. In the next section, we’ll take a look athow to save data in a CSV-formatted file so that we can prepare data forexport.
Often, we need to share workbooks with others, whether within thesame organization or externally. It is important to share workbooks inthe correct format to prevent loss of functionality.
To save a workbookin .csv format, we can take thefollowing steps:
- Open a workbook. For this example, we willuse YearlyProductSales.xlsx.
- Go to
File | Export.
- Choose the Save asType option.
- Select the CSV (Commadelimited) (*.csv) option and then click onthe Save As button:
- Select a location to save the file to, then clickon Save.
You will see an information bar at the top of the workbook aftersaving it as a .csv file. This information highlights to theuser that there could be a loss of certain features in the workbook ifthey continue working in .csv mode.