Exporting a file in .csv format (Excelonly) in Microsoft Office 2019

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:

  1. Open a workbook. For this example, we willuse YearlyProductSales.xlsx.
  2. Go to File | Export.
  3. Choose the Save asType option.
  4. Select the CSV (Commadelimited) (*.csv) option and then click onthe Save As button:

ms office 269

  1. 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.

Note that when saving workbooks with multiple sheets inthe .csv file format, multiple sheets are not accommodated.Only the first worksheet is saved as .csv. In order to savethe other sheets in the workbook, each individual sheet needs to besaved in the .csv file format separately.

Leave a Comment