Saving an Excel .XLS file as a .CSV file

Question

Hello. I am using Microsoft Excel in One Drive. I have a workbook file that I am trying to save as a CSV file but it is not giving me the option to save it as such. Can anyone help me out?

Answer 1

I was able to duplicate the screens you showed above. You are, I assume, working in Excel online. There are a number of areas where the online version has less functionality than the full down-loaded version. This appears to be one of those limitations. I was only able to go so far in duplicating your situation since I do have it on my computer. However, I did not see any way to get from here to there unless you can open it in a local application on your computer. Notepad doesn't help as long as the file is still saved as an Excel file because it opens all of the programmatic info as well--not just the file info.

My best suggestion would be to download it to your computer and save on a flash drive that you could use on a computer with Excel installed to re-save then as .csv.

Hope this helps and you can figure this out.

Rich~M

Answer 2

in other words, I need a physical copy of excel on my computer....right?

I did take send the file to my husband, who has it on his computer. He was still not able to save the file properly.

Let me try the suggestions you mentioned above, then I will report back.

Answer 3

Thank you all for your help. I am using a different program to send out my emails now, which is what I needed the .csv file for. I will, though, keep these recommendations in the back of my brain should I need them again.

Thanks so much!