dataset=Dataset[{
<|"a"->1,"b"->"x","c"->{1}|>,
<|"a"->2,"b"->"y","c"->{2,3}|>,
<|"a"->3,"b"->"z","c"->{3}|>,
<|"a"->4,"b"->"x","c"->{4,5}|>,
<|"a"->5,"b"->"y","c"->{5,6,7}|>,
<|"a"->6,"b"->"z","c"->{}|>}]
Export["test.xls",
Prepend[List @@@ Normal@dataset, Keys@Normal[dataset][[1]]]] like SemanticImport/SemanticExport
or a pivot table with column names and row names and a table_name in left corner.
titanic = ExampleData[{"Dataset", "Titanic"}]
titanic[GroupBy["sex"], GroupBy["class"], ratio, "survived"]
Are there some more stupid/better methods to do this?