SOURCE

function trans(){
    var data = JSON.parse(document.getElementById("json").value);
    var alarmList = transList(data.alarmList);
    var normalList = transList(data.normalList);
    var unknowList = transList(data.unknowList);

    document.getElementById("xls").value=alarmList.join("\n")
    +"\n"+normalList.join("\n")
    +"\n"+unknowList.join("\n");
}
function transList(list){
    var arr = [];
    for (var i =0; i < list.length; i++){
        arr.push(transRow(list[i]));
    }
    return arr;
}
function transRow(row){
    var arr = [];
    arr.push(row.serverIp);
    if (row.core>0){
        arr.push(Math.round(row.cpu/(row.core*100)));
    }else{
        arr.push(0);
    }
    
    arr.push(Math.round(row.memMb/1024));
    arr.push(row.memory);
    return arr.join("\t");
}

<textarea id="json" style="width:800px;height:400px" placeholder="请输入json串"></textarea>
<p><button onclick="trans()">转换</button><p>
<textarea id="xls" style="width:800px;height:400px" placeholder="将结果复制到EXCEL"></textarea>