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

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.

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 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.

Just insert the button "From Web" as the same way in Excel for Windows

Inserting pdf into excel file doesn't work in Mac.

I would like a stable service - not to be treated as a paying guide pig for Microsoft to try out new ideas, like deleting Forms. If Microsoft want to trail stuff and take away functionality they shouldn't be doing it to the people who pay them each year via 365

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?

Allow Excel for Mac to connect to MS SSAS cubes.

Add "query from Web" for Mac version

On iPad in excel when I copy cells ( some with data, some without ) form one spreadsheet and pasting to another spreadsheet the cells with data are compressed together, without regard to blank cells

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.

Add formula to add stock quotes in realtime, like google sheets has the ability to do. I don't want to run a excel add-on to find these quotes. This would be very helpful.

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.

Pull Stock Quotes real time from MS Finance.

As Microsoft has data already for MS Finance, a simple formula like =GOOGFINANCE can make Excel amazing. Now I switch between Excel and Google Sheets.

In the most recent update of Excel for Mac 2016 (v16.9), when you import data into Excel you only get to view a small selection of columns in the data preview window (Preview of Selected Data). You cannot scroll the right to view/manipulate the rest of the columns, which is essential during the importing of the data. This behavior is unaffected by the System Preferences>General>Scrolling behavior selections.