CSV to ASCII
 

What is the CORRECT procedure to convert a CSV file (a comma delimited file)
that I created using Excel 2007, to an ASCII file? I think there is more than
just changing the extencion from *.csv to *.asc

Answer: CSV to ASCII
 

Yes, you are correct that simply changing the file extension from .csv to .asc will not convert the file to ASCII format. Here are the steps to correctly convert a CSV file to an ASCII file:

1. Open the CSV file in
   Formula:

   ---

   Excel 2007 


   ---

   .
2. Click on the "File" tab in the ribbon and select "Save As".
3. In the "Save As" dialog box, choose a location to save the file and select "Text (Tab delimited) (*.txt)" from the "Save as type" drop-down menu.
4. Click the "Save" button.
5. In the "Text Import Wizard" that appears, select "Delimited" and click "Next".
6. Check the box next to "Tab" under "Delimiters" and uncheck any other boxes. You can also choose the text qualifier if your CSV file contains text fields with commas in them.
7. Click "Next" and then "Finish".
8. Open the saved text file in a text editor such as Notepad or WordPad.
9. In the text editor, click "File" and then "Save As".
10. In the "Save As" dialog box, choose a location to save the file and select "ASCII (DOS)" or "ASCII (Unix)" from the "Save as type" drop-down menu, depending on your operating system.
11. Click the "Save" button.

Your CSV file should now be converted to an ASCII file. Keep in mind that ASCII files do not support formatting or formulas like Excel files do, so any formatting or formulas in your original CSV file will not be preserved in the ASCII file.

CSV to ASCII
 

A CSV file is a text file. Try opening it with NotePad.

"Quco" wrote:

What is the CORRECT procedure to convert a CSV file (a comma delimited file)
that I created using Excel 2007, to an ASCII file? I think there is more than
just changing the extencion from *.csv to *.asc

CSV to ASCII
 

Depends entirely on the application that is "expecting" the .asc file.
But you may get by just renaming. A ".csv" file just "generally" means
its a text file with the "fields" separated by commas.

Quco wrote:

What is the CORRECT procedure to convert a CSV file (a comma delimited file)
that I created using Excel 2007, to an ASCII file? I think there is more than
just changing the extencion from *.csv to *.asc

CSV to ASCII
 

Open the FILE OPEN dialog box, change the files of type option to text files,
where csv is one of several extensions, locate your csv file and the import
wizard should open allowing to define how to parse the data.

--
Kevin Backmann


"Quco" wrote:

What is the CORRECT procedure to convert a CSV file (a comma delimited file)
that I created using Excel 2007, to an ASCII file? I think there is more than
just changing the extencion from *.csv to *.asc

CSV to ASCII
 

I don't think the OP was asking how to open the file with Excel, but as a
matter of interest, which version of Excel opens the wizard for File/ Open
of a csv, Kevin?
In general (such as in Excel 2003), to get the wizard one has to change the
csv extension to txt, or open the file with Data/ Import External Data; a
simple File/ Open of a csv bypasses the wizard and Excel decides what it
wants, rather than what *you* want. :-(
--
David Biddulph

"Kevin B" wrote in message
...
Open the FILE OPEN dialog box, change the files of type option to text
files,
where csv is one of several extensions, locate your csv file and the
import
wizard should open allowing to define how to parse the data.

--
Kevin Backmann


"Quco" wrote:

What is the CORRECT procedure to convert a CSV file (a comma delimited
file)
that I created using Excel 2007, to an ASCII file? I think there is more
than
just changing the extencion from *.csv to *.asc