Question: Can I see a content of a table directly in excel? Answer: Yes, with a simple code of VB for application.
Here an article to define some simple macro and related function module in the back-end system SAP. Read any SAP Table from Excel
Question: Is there a method to use Excel directly like an SE16 transaction? Answer: Yes, but you need to define more complex functions macros to manage selection of the data and to render the data in the appropriate format.
The real scope of this contribute is not to replicate the SE16 in excel but to take confident with the VB in excel and how is simple to call SAP function. An example of result with table T005 (country):
Note that in the article there is the possibility to log-on directly to different systems and so to compare the result directly in excel.
….. PS in the article I missed the declaration of structure ZCHAR1250. Here the definition:
The function TABLE_ENTRIES_GET_VIA_RFC is a good example to retrive data with this macros without implement ABAP (function or structure).
Take care that the function is not builded to retrive data. The function module is only intended for internal use in the ALE area see note 881127.
To read simply and short table you can use this function. But for more complex query, you can define a custom function that encapsulate that.