How To Save A Microsoft Excel Workbook As A CSV File

An Excel sheet can be saved as different CSV formats. An active sheet can be saved as CSV (comma delimited), DSV (Macintosh), and CSV (MS-DOS) formats. It is necessary to save a file in proper format to use it in another computer environment or computer system. A file also should be saved in perfect format to work with other software. Here necessary instructions are given to save an Excel workbook as a CSV file.

CSV (comma delimited) format saves the file as comma-delimited text. It is done to use the file on another Windows environment. This file format will keep the line breaks, tab characters, other characters in such condition that they can be interpreted correctly. The Excel saves the file in CSV (comma delimited) format and it saves the active sheet only. Another option is CSV (Macintosh). Macintosh operating system is different from the Windows operating system. If anyone wants to use the CSV file in Macintosh computer, then he should save the file in CSV (Macintosh) format. The format will help to keep different characters, tab characters, and line breaks in such condition that they can be interpreted correctly. The active sheet will be saved only. CSV (MS-DOS) is another option. For using in MS Dos the Excel file should be saved in CSV (MS-DOS) format. This format will keep all the characters and line breaks in positions to be interpreted correctly. The active sheet will be saved only.

Usually, there are two types of text file formats. One is delimited text files and another is comma separated values or CSV text files. In the delimited text or txt files, every field of text is separated by the TAB character. In the comma separated values files, every field of text is separated by the comma character. The separator character can be changed, this can be necessary for some export or import operation works. Here, it should be noted that up to 16384 columns and 1048576 rows can be imported or exported.  To know more about the text file formats, you can see the help topics.

To import a CSV file in Excel use the Open command. Click on the Office button and click the Open button, a dialog box will appear. Select text files from the list. Then double click on the text file that you wish to open. Excel will open the CSV file and will display the data. For more flexibility, import text wizard can be used. You can also import text files by connecting to them. For this, click on the cell in which you wish to put the text file. Then go to Data tab, click on From Text in Get External Data. Then locate the file and double click it. To set formatting, refresh, and layout options click on Properties in the dialog box of Import Data. To see the data in the existing worksheet, click existing worksheet; and to see the data in a new worksheet, click new worksheet. Then click OK. Excel will put the data in the specified location.

To export data as a text file, you can convert the worksheet. To do this, use the Save As button or command. After clicking Save As a dialog box will appear. Choose the file format in which you want to save the file. To save in CSV, choose the CSV format. When you will save the file, the current sheet will be saved. To save other sheets, repeat this procedure. Another dialog box can appear to inform you that there may be unsupported features in the worksheet. Click yes to save the worksheet data or to know more about the Excel features you should read the help files. After clicking yes the worksheet will be saved as CSV file.

You can export contacts to your Gmail by CSV files. Make a CSV file where the contacts will be in a table. The table will include name, email address, and home address. You can use more columns to store more information such as initial name, middle name, last name, phone number and so on.  Save the file in CSV (Comma delimited) format; then import it to your Gmail.

Post comment