Save Excel to ASCII format
 

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?

Save Excel to ASCII format
 

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.

Aaron Z wrote:

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?

--

Dave Peterson

Save Excel to ASCII format
 

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?

"Dave Peterson" wrote:

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.

Aaron Z wrote:

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?

--

Dave Peterson