0

According to documentation I can find the "Save as" should allow selecting csv and other types: But maybe this is only for non-MacOS versions of Excel? Save an Excel Spreadsheet as csv

But when attempting to save I only see variants of Excel:

enter image description here

So how to save to CSV?

I am using Microsoft Excel for Mac Version 16.52

enter image description here

enter image description here

File formats: as mentioned there are only .xls* offered.

enter image description here

7
  • Where are you looking? What does the File Formats show?
    – mmmmmm
    Jan 9, 2022 at 9:14
  • @mmmmmm added screenshot showing that only .xls* formats are shown Jan 9, 2022 at 18:32
  • 1
    Thanks for the screenshot, that makes it way easier to understand. Did you check in Excel‘s preferences whether an option would influence that?
    – nohillside
    Jan 9, 2022 at 18:41
  • Also, are you saving locally or to an online location?
    – nohillside
    Jan 9, 2022 at 18:42
  • 1
    It's 100% personal mac / personal office license Jan 9, 2022 at 19:05

2 Answers 2

3

I would click on File Format and select from there (on a macbook pro 15"):

enter image description here

1
  • 1
    I added screenshots to the OP : none of those non-XLS options show up for me. That's the whoel reason for the question. I did mention that but apparently the screenshots are needed to be clear. Jan 9, 2022 at 18:31
-2

You can save the file to your computers, such as a hard drive or flash drive, or a web service, such as OneDrive. You can also export files in different formats and save them under different names. I had a similar situation, and only it took me less time to create the document because I worked with a program I downloaded from https://www.wallstreetoasis.com/resources/excel/study/index-match-formula-excel. It makes working with Excel easy. So when you save a file, you can usually change its name, storage location, and format, if necessary. However, you may not need to change all of these at once.

1
  • 1
    How do you save as a .csv file - this is the question that is asked?
    – mmmmmm
    Feb 20, 2022 at 15:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .