ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I save an excel spreadsheet as a comma-delimited ASCII file (https://www.excelbanter.com/excel-discussion-misc-queries/80362-how-do-i-save-excel-spreadsheet-comma-delimited-ascii-file.html)

karaayn

How do I save an excel spreadsheet as a comma-delimited ASCII file
 
I can save an xls as a csv comma-delimited file, but I don't think its in the
ASCII format and can't find ASCII on the list of save as file formats.

Kevin B

How do I save an excel spreadsheet as a comma-delimited ASCII file
 
Select FILE from the menu and click SAVE AS. From the SAVE AS dialog box
drop down the selection list for the SAVE AS TYPE combo box. Select CSV
(comma delimited)(*.csv) as the file type.
--
Kevin Backmann


"karaayn" wrote:

I can save an xls as a csv comma-delimited file, but I don't think its in the
ASCII format and can't find ASCII on the list of save as file formats.


karaayn

How do I save an excel spreadsheet as a comma-delimited ASCII file
 
The csv file I made did not work (as a class properties file in Fragstats),
and I could try a txt file instead but I see no options in Excel for
comma-delimited txt files (only tab or space). Any suggestions out there?

"karaayn" wrote:

I can save an xls as a csv comma-delimited file, but I don't think its in the
ASCII format and can't find ASCII on the list of save as file formats.


Kevin B

How do I save an excel spreadsheet as a comma-delimited ASCII
 
Do you have MS Access on your PC. If you do you can either link to
spreadsheet as a table or import your excel data into a table. From Access
you would have a wider array of choice for exporting your data to a text file.
--
Kevin Backmann


"karaayn" wrote:

The csv file I made did not work (as a class properties file in Fragstats),
and I could try a txt file instead but I see no options in Excel for
comma-delimited txt files (only tab or space). Any suggestions out there?

"karaayn" wrote:

I can save an xls as a csv comma-delimited file, but I don't think its in the
ASCII format and can't find ASCII on the list of save as file formats.



All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com