How do I save an excel spreadsheet as a comma-delimited ASCII file

G

Guest

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

Guest

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

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save Excel to ASCII format 2
CSV to ASCII 4
CSV Tab Delimited 4
*.csv format change if .xlt save as .csv in Excel 2007 1
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
how do I change a csv extension file to an xls file and use it? 1
Save as CSV: extra spaces around commas 2
CSV error when trying to save 3

Top