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.

How to make it easier to get external data from the web for mac users. I can't do it for some reason. I have saved plain text query in word and when I run the saved web query what gets upload is the hyperlink address.

excel should be able to import word or power point docs to intergrate together.
This would allow to produce solid intergrated documents & presentations.
This option should be available to insert excel sheets/tables into word documents as well.

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.

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 will be more convenient if Excel for Mac has the same import xml function as Windows version.

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

Excel on IOS currently does not support the functionality to pull data from external sources e.g Stock prices, FX Rates , table imports from the web.

Dateien einfach freistellen

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

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.

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

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

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.

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