Avatar of zachvaldez
zachvaldez
Flag for United States of America asked on

converting csv to excel file

how to convert csv to excel
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
zachvaldez

8/22/2022 - Mon
SOLUTION
Bill Prew

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
zachvaldez

ASKER
Really. I thought you have to open a blank Excel workbook to begin with.
Alan

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.
SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
zachvaldez

ASKER
Ryan will you please complete the steps. Thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bill Prew

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
zachvaldez

ASKER
I will try those suggested solutions. Thanks