How Do I Create A Csv File In Excel

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less

Sometimes, yous might need to save a workbook in another file format, like a text (txt) or a comma-separated values format (csv). Only go on in mind that whenever you save a workbook in some other file format, some of its formatting, data, and features might not exist saved.

Caution: When yous save a workbook in any of the text formats, all formatting will be removed.

1. Open the workbook you lot want to save.

2. Click File > Save As.

   

3. Pick the identify where you want to save the workbook.

   

4. In the Salvage As dialog box, navigate to the location you want.

5. Click the arrow in the Salve as type box and pick the type of text or CSV file format you want.

   Annotation: The file formats you'll see vary, depending on what type of sheet is active in your workbook (a worksheet, chart sheet, or other blazon of sheet).

   

6. In the File name box, have the suggested name or type a new name for the workbook.

Available text file formats

Format	Extension	Description
Formatted Text (Space-delimited)	.prn	Lotus infinite-delimited format. Saves just the active sheet.
Text (Tab-delimited)	.txt	Saves a workbook every bit a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves just the active sheet.
Text (Macintosh)	.txt	Saves a workbook as a tab-delimited text file for employ on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sail.
Text (MS-DOS)	.txt	Saves a workbook as a tab-delimited text file for utilise on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active canvass.
Unicode Text	.txt	Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium.
CSV (comma delimited)	.csv	Saves a workbook equally a comma-delimited text file for utilise on some other Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (Macintosh)	.csv	Saves a workbook as a comma-delimited text file for use on the Macintosh operating organization, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (MS-DOS)	.csv	Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves just the active sail.
DIF	.dif	Data Interchange Format. Saves only the active sail.
SYLK	.slk	Symbolic Link Format. Saves only the active sail.

Need more than help?

Source: https://support.microsoft.com/en-us/office/save-a-workbook-to-text-format-txt-or-csv-3e9a9d6c-70da-4255-aa28-fcacf1f081e6

Posted by: johnsonnoned1998.blogspot.com

Share this post