Save Excel to ASCII format

G

Guest

I need to save an Excel file, as comma delimited, and as ASCII. I've seen
several posts that address these individually but not together. Someone
suggested to save as ASCII, just save as text (like csv, .txt etc.)... does
this actually save as ASCII or is it still Binary?

What steps do I follow, and how can I test this to make sure its ASCII?
 
D

Dave Peterson

Saving as .csv, .txt and .prn will all result in an ascii file.

Try saving your workbook as .csv.

Then close excel and open that .csv file in Notepad. You'll see what it looks
like.

Reopening the .csv file in excel isn't a good way to inspect the file--excel
will make some decisions that may change the format when it imports the data.
 
G

Guest

Is a csv file from Excel always ASCII? How do I know its not a binary text
file? Any way to confirm (ie looking at it in notepad etc.), and what am I
looking for to know its truly ASCII?
 

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

How do I save an excel spreadsheet as a comma-delimited ASCII file 3
CSV to ASCII 4
Convert Excel file ti ASCII format to allow a SIFT transfer 1
how to save Excel data as ASCII* text? 1
Excel to ASCII Fixed Format 2
How do I save a Word file as an ASCII format? 5
How do I convert an Excel file to an ASCII file? 1
*.csv format change if .xlt save as .csv in Excel 2007 1

Top