Save Excel to ASCII format

A

Aaron Z

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

Aaron Z

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

Convert Excel file ti ASCII format to allow a SIFT transfer 1
How do I save an excel spreadsheet as a comma-delimited ASCII file 3
CSV to ASCII 4
Can't save my Office documents (after computer rebuild and reauthorization) 0
Excel to ASCII Fixed Format 2
how to save Excel data as ASCII* text? 1
Excel does not accept text format! 0
How do I convert an Excel file to an ASCII file? 1

Top