Microsoft Excel save dialog… what on earth?!

Every time I have to save a document in Microsoft Excel and I’m presented with this drop-down list of available file types I cry a little inside.

I often use Excel to create files of events to bulk import into Microsoft Outlook, Google Calendar or The Events Calendar (WordPress plugin). And each time I need to convert from the default Excel Workbook (*.xlsx) format to CSV (Comma delimited) (*.csv) format I cringe when I see this mess of a list.

Excel save dialog showing file types not in alphabetical order
Whose idea was this listing?!

I find it hard to believe that this order has been the result of extensive user-testing.

Would it be too much to ask for an alphabetical list?

I mean, sure, put the default Excel format at the top, but then list everything else alphabetically. That would work for me, and I’m sure lots of other users too.

Current list

This is the list as it currently looks. I can appreciate that the most commonly used formats are near the top (Excel, old Excel and XML) but after that… where is the logic?

Try quickly finding CSV (Comma delimited) (*.csv) in this list.

  • Excel Workbook (*.xslx)
  • Excel Macro-Enabled Workbook (*.xlsm)
  • Excel Binary Workbook (*.xlsb)
  • Excel 97-2003 Workbook (*.xls)
  • XML Data (*.xml)
  • Single File Web Page (*.mht, *.mhtml)
  • Web Page (*.htm, *.html)
  • Excel Template (*.xltx)
  • Excel Macro-Enabled Template (*.xltm)
  • Excel 97-2003 Template (*.xlt)
  • Text (Tab delimited) (*.txt)
  • Unicode Text (*.txt)
  • XML Spreadsheet 2003 (*.xml)
  • Microsoft Excel 5.0/95 Workbook (*.xls)
  • CSV (Comma delimited) (*.csv)
  • Formatted text (Space delimited) (*.prn)
  • Text (Macintosh) (*.txt)
  • Text (MS-DOS) (*.txt)
  • CSV (Macintosh) (*.csv)
  • CSV (MS-DOS) (*.csv)
  • DIF (Data Interchange Format) (*.diff)
  • SYLK (Symbolic Link) (*slk)
  • Excel Add-in (*xlam)
  • Excel 97-2003 Add-in (*.xla)
  • PDF (*.pdf)
  • XPS Document (*.xps)
  • Strict Open XML Spreadsheet (*.xlsx)
  • OpenDocument Spreadsheet (*.ods)

More user-friendly list

This order would make much more sense to my mind. The default Excel format is at the top, to make it easier to find, but after that everything else is in alphabetical order. I’ve also removed the “Microsoft” prefix from Excel 5.0/95 as it’s the only Excel format that includes it.

Now try finding CSV (Comma delimited) (*.csv) in this list.

  • Excel Workbook (*.xslx)
  • CSV (Comma delimited) (*.csv)
  • CSV (MS-DOS) (*.csv)
  • CSV (Macintosh) (*.csv)
  • DIF (Data Interchange Format) (*.diff)
  • Excel 5.0/95 Workbook (*.xls)
  • Excel 97-2003 Add-in (*.xla)
  • Excel 97-2003 Template (*.xlt)
  • Excel 97-2003 Workbook (*.xls)
  • Excel Add-in (*xlam)
  • Excel Binary Workbook (*.xlsb)
  • Excel Macro-Enabled Template (*.xltm)
  • Excel Macro-Enabled Workbook (*.xlsm)
  • Excel Template (*.xltx)
  • Formatted text (Space delimited) (*.prn)
  • OpenDocument Spreadsheet (*.ods)
  • PDF (*.pdf)
  • SYLK (Symbolic Link) (*slk)
  • Single File Web Page (*.mht, *.mhtml)
  • Strict Open XML Spreadsheet (*.xlsx)
  • Text (MS-DOS) (*.txt)
  • Text (Macintosh) (*.txt)
  • Text (Tab delimited) (*.txt)
  • Unicode Text (*.txt)
  • Web Page (*.htm, *.html)
  • XML Data (*.xml)
  • XML Spreadsheet 2003 (*.xml)
  • XPS Document (*.xps)

Now, isn’t that easier to use? Microsoft… please make this a thing.

Published by

Gareth Saunders

I’m Gareth J M Saunders, 46 years old, 6′ 4″, father of 3 boys (including twins). Latterly, web architect and agile project manager at the University of St Andrews and warden at Agnes Blackadder Hall. Currently on sabbatical. I am a priest in the Scottish Episcopal Church, and I sing with the NYCGB alumni choir.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.