There is not way to import and map XML data to excel for mac,

it will be more convenient if Excel for Mac has the same import xml function as Windows version.

I need to import a structured xml file into excel. The xml file contains elements which contain other elements. I'd be happy to define a mapping which would excel allow to know, which elements/attributes to put into which column. The File I'd like to import is attached. However, this is jus one example.

It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.

The font used in the text import wizard really needs to be changed. 1. The preview window is to small and the font used in the preview window is to small and should be like Helvetica or something so the text is much easier to read. The zero's wth slashes is awful. please fix this so it is as nice as the windows version. Thank you.

This feature is provided with Windows Excel 2016 but not with Mac. Isn't it time to make the Mac software a first-class citizen with Microsoft. It seems like forever that Microsoft started supporting Mac Office, yet it still does not have all the features. Why not? I am paying you every month. Yet you still don't provide many advanced features. I will consider Pages then.

It would be helpful for Excel to Mac to support internet query connections.

When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

Allow Excel for Mac to connect to MS SSAS cubes.

Currently when I import data from a CSV file, Excel doesn't recognise that it is CSV even though the file name ends in ".csv"! I have to tell the program that the data file has delimited fields and define the separator as comma for it to import the data correctly. Surely this is basic stuff for a program like Excel?

Support for CHANNEL and ITEM tags in web queries for Excel 2016 for Mac.

See issue at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/trouble-opening-excel-macro-enabled-workbook-on/7da91e00-9e66-4239-b66d-53d744ed5be2?messageId=7327585a-3926-4090-aa98-bbb95f78c5a4

Add "query from Web" for Mac version

Excel 2011 (Mac OS) says Data connections have been disabled for my "Personal macro workbook".

How do I find out what data connections exist when Edit > Links is grayed out and there is no Data > connections in Excel 2011?

Is there a macro that will show them?

When I open a CSV file directly from the Finder and open it with Excel, I have not the possibility to select separator, column format or file encoding.

It will be very nice if you add the possibility (e.g.: Excel preferences) to open the Import dialog box for give the possibility to configure how to open correctly the CSV file

ODBC compatibility with Redshift Driver
Can you make the Redshift Driver compatible with Excel 2016 MAC OS X (El Capitan or higher) as the current setup is broken as it gives the following errors:
IM003 [iODBC][Driver Manager]Specified driver could not be loaded

00000 [iODBC][Driver Manager]dlopen(/opt/amazon/redshift/lib/libamazonredshiftodbc.dylib, 6): no suitable image found. Did find: /opt/amazon/redshift/lib/libamazonredshiftodbc.dylib: open() failed with errno=1

However, when testing the ODBC connection to Redshift via odbctest command line was successful.

I understand that Redshift ODBC Drivers are not supported therefore, this needs to be supported.

homanhidar113113@gmail.com

Currently if I paste data into Excel from the internet or another workbook, the default is to use the source format. If I set the preferences to display format options, I can then select an option to display the data in the destination format. I have to do this every time, but I ALWAYS want to display the data in the destination format - so I need to be able to reset the default to use destination format, but I cannot change this. You need to make the default format user-defined.

In Excel for Windows I can connect to an API url by going to the data tab then "From Web" at which point I type in the URL It downloads into my spreadsheet as a table, which is awsome because I can perform VLookups etc on it. We need better external data features like this for the Mac version.