How to convert .xls file into CSV format?
Answer Posted / manjunath wadi
It is very simple.
1. Click on "FILE" menu of the MS Excel file
2. Select "Save As" Option and click on that
3. Now you can see a dialog box "Save As", type the file
name select location to save
4. Select the option CSV(comma delimited)option from Save as
Type drop down box and click Save button.
Its Done!
Note: Only active worksheet can be saved if you are saving
your file in CSV format
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
What is the purpose of trailing @ and @@? How do you use them?
What Proc glm does?
explain the concepts and capabilities of business object? : Sas-bi
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what are some differences between proc summary and proc means? : Sas programming
How do you add a number to a macro variable? : sas-macro
What are the limitations for memory allocation for SAS variables
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
explain about various caches available in data integrator? : Sas-di
How to sort in descending order?
how to generate the test data in sas without input data? : Sas-administrator
What are the differences between sum function and using “+” operator?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
List down the reasons for choosing sas over other data analytics tools.
Explain the difference between informat and format with an example.