converting csv to excel file

zachvaldez
zachvaldez used Ask the Experts™
on
how to convert csv to excel
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill PrewTest your restores, not your backups...
Top Expert 2016
Commented:
Open CSV file in Excel (should just be able to double click on the file in Explorer), then "Save As" and select Excel Workbook as the file type.


»bp

Author

Commented:
Really. I thought you have to open a blank Excel workbook to begin with.
AlanConsultant

Commented:
Bill's suggestion above will work most of the time - for the vast majority of CSV files I would say.

You never need to open a blank file first - but sometimes it helps to use the import options, which means you have to have Excel open, albeit with nothing, not even a blank workbook, open in it.  There is no issue if you *do* have something already open - it is not required though.

You can then do File - Open, change the 'type' to Text files (which includes CSV files), then open the CSV, and use the wizard to choose options appropriate to the CSV file, and your requirements.

Alan.
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Ryan ChongSoftware Team Lead
Commented:
you can also do the same thing directly from the Data tab instead.

Untitled.jpg

Author

Commented:
Ryan will you please complete the steps. Thanks
Software Team Lead
Commented:
well, you probably can refer to many resources on internet.

one of that you can refer to below:

How to open a CSV file in Excel?
https://www.copytrans.net/support/how-to-open-a-csv-file-in-excel/
Bill PrewTest your restores, not your backups...
Top Expert 2016

Commented:
If you can share a bit more about what your specific need is then we can provide more detailed and appropriate suggestions for your situation.  Is this a one time need, or do you have hundreds of files to convert?  Is there anything interesting about the input CSV files?  Why do you want to convert them?  Etc...

"how to convert csv to excel"  doesn't give us a lot to go on, so you are getting some general suggestions based on that.


»bp

Author

Commented:
I will try those suggested solutions. Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial