How to save Microsoft Excel worksheets as CSV files

1158285 pts.
Tags:
.CSV files
Microsoft Excel
I have to analyze several Excel worksheets. Afterwards, I have to save them as .CSV files and I'm not sure how to do that. What's the best way to do it? Should I use a macro?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

When doing a save or save as, there are two lines, the first is where you designate the name of the file, the second (defaults to Excel workbook) is the format. On this second line use the drop down until you find the CSV or comma delimited  format.

Note: If you are new to saving .CSV files in Excel, you may want to play with this some. This file format can be opened w/ NotePad and might be good to look at it that way. Some of your formatting will get changed.  If you have a comma in a text cell (i.e. a sentence with a comma in it) unless the text is enclosed in double quotes, when the next program opens it, it will see the comma as a cell separator. This holds true for numeric values as well. (By default, Excel should save numeric fields without comma designations).

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    You might want to provide more details about why you are even considering using a macro.

    Do you want to automate something? Why? What exactly are you thinking the macro would do?
    85,925 pointsBadges:
    report
  • ToddN2000
    Under file, click save as and select CSV as the file type. If this does not suit your needs report back with some additional info on the problem.
    136,550 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: