提问者:小点点

Firebase JSON到CSV的转换


如何将导出的JSON firebase实时数据库文件转换为可视的excel格式。

这里是示例的JSON数据,在任何情况下,我都无法将此JSON文件转换为可视的excel文件。 请帮帮我。 有没有其他的选择呢? 关于这个json文件,我所知道的最好的是,这是一个Google使用的键控json文件。

null

{
  "2354" : {
    "15-07-2020_19:19" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "divisionName" : "KANPUR",
      "duringVisitResolve" : "Yes",
      "errorCode" : "2",
      "finalRemarks" : "Pingtest Fail",
      "lat" : "",
      "lon" : "",
      "newMeterNumber" : "GP3620615",
      "newModuleNo" : "8288282",
      "newSealNumber" : "64949",
      "newSimNumber" : "89911500028407656055",
      "oldmeterNo" : "GP1232475",
      "oldmodulenumber" : "64949979794",
      "oldsealnumber" : "64949499",
      "oldsimnumber" : "89911554728407768686",
      "pageNumber" : "2",
      "ping" : "23",
      "recordDate" : "15-07-2020  19:19",
      "rssi" : "30",
      "sealingBookNumber" : "1"
    }
  },
  "741700122999" : {
    "15-07-2020_12:21" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "2/436, Mandi Parishad Rd, Vibhav Khand, Gomti Nagar, Lucknow, Uttar Pradesh 226010, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "",
      "finalRemarks" : "Door Lock",
      "lat" : "LATITUDE:  26.86627563",
      "lon" : "LONGITUDE:  81.01962545",
      "newMeterNumber" : "gp7654321",
      "newModuleNo" : "",
      "newSealNumber" : "",
      "newSimNumber" : "98387928569838792856",
      "oldmeterNo" : "GP3624117",
      "oldmodulenumber" : "",
      "oldsealnumber" : "",
      "oldsimnumber" : "89911500028407706884",
      "pageNumber" : "",
      "ping" : "",
      "recordDate" : "15-07-2020  12:21",
      "rssi" : "",
      "sealingBookNumber" : ""
    },
    "15-07-2020_12:22" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "2/436, Mandi Parishad Rd, Vibhav Khand, Gomti Nagar, Lucknow, Uttar Pradesh 226010, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "",
      "finalRemarks" : "Door Lock",
      "lat" : "LATITUDE:  26.86627563",
      "lon" : "LONGITUDE:  81.01962545",
      "newMeterNumber" : "gp7654321",
      "newModuleNo" : "",
      "newSealNumber" : "",
      "newSimNumber" : "98387928569838792856",
      "oldmeterNo" : "GP3624117",
      "oldmodulenumber" : "",
      "oldsealnumber" : "",
      "oldsimnumber" : "89911500028407706884",
      "pageNumber" : "",
      "ping" : "",
      "recordDate" : "15-07-2020  12:22",
      "rssi" : "",
      "sealingBookNumber" : ""
    },
    "15-07-2020_12:23" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "2/436, Mandi Parishad Rd, Vibhav Khand, Gomti Nagar, Lucknow, Uttar Pradesh 226010, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "",
      "finalRemarks" : "Door Lock",
      "lat" : "LATITUDE:  26.86631405",
      "lon" : "LONGITUDE:  81.01964089",
      "newMeterNumber" : "gp7654321",
      "newModuleNo" : "",
      "newSealNumber" : "",
      "newSimNumber" : "98387928569838792856",
      "oldmeterNo" : "GP3624117",
      "oldmodulenumber" : "",
      "oldsealnumber" : "",
      "oldsimnumber" : "89911500028407706884",
      "pageNumber" : "",
      "ping" : "",
      "recordDate" : "15-07-2020  12:23",
      "rssi" : "",
      "sealingBookNumber" : ""
    },
    "15-07-2020_18:28" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "2/436, Mandi Parishad Rd, Vibhav Khand, Gomti Nagar, Lucknow, Uttar Pradesh 226010, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "00",
      "finalRemarks" : "Meter Defective",
      "lat" : "LATITUDE:  26.86630446",
      "lon" : "LONGITUDE:  81.01963832",
      "newMeterNumber" : "gp1161819",
      "newModuleNo" : "7655",
      "newSealNumber" : "147",
      "newSimNumber" : "12345678901234567890",
      "oldmeterNo" : "GP3624117",
      "oldmodulenumber" : "123",
      "oldsealnumber" : "123",
      "oldsimnumber" : "89911500028407706884",
      "pageNumber" : "36",
      "ping" : "258",
      "recordDate" : "15-07-2020  18:28",
      "rssi" : "43",
      "sealingBookNumber" : "456"
    },
    "15-07-2020_18:29" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "2/436, Mandi Parishad Rd, Vibhav Khand, Gomti Nagar, Lucknow, Uttar Pradesh 226010, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "00",
      "finalRemarks" : "Meter Defective",
      "lat" : "LATITUDE:  26.86630446",
      "lon" : "LONGITUDE:  81.01963832",
      "newMeterNumber" : "gp1161819",
      "newModuleNo" : "7655",
      "newSealNumber" : "147",
      "newSimNumber" : "12345678901234567890",
      "oldmeterNo" : "GP3624117",
      "oldmodulenumber" : "123",
      "oldsealnumber" : "123",
      "oldsimnumber" : "89911500028407706884",
      "pageNumber" : "36",
      "ping" : "258",
      "recordDate" : "15-07-2020  18:29",
      "rssi" : "43",
      "sealingBookNumber" : "456"
    }
  },
  "751601669466" : {
    "15-07-2020_02:19" : {
      "actionTaken" : "Yes",
      "city" : "Varanasi",
      "currentAddress" : "Near DVC More, Malancha, Kalitala, 713 103, Ichlabad, Bardhaman, West Bengal 713103, India",
      "divisionName" : "EDSD2 Varnasi",
      "duringVisitResolve" : "Yes",
      "errorCode" : "404",
      "finalRemarks" : "No Time To Solve The Problem",
      "lat" : "LATITUDE:  23.22290181",
      "lon" : "LONGITUDE:  87.88539515",
      "newMeterNumber" : "GP3620615",
      "newModuleNo" : "8188282",
      "newSealNumber" : "",
      "newSimNumber" : "89911500028407656055",
      "oldmeterNo" : "GP3625944",
      "oldmodulenumber" : "",
      "oldsealnumber" : "946646619194949",
      "oldsimnumber" : "89911500028407656055",
      "pageNumber" : "46",
      "ping" : "92",
      "recordDate" : "15-07-2020  02:19",
      "rssi" : "32",
      "sealingBookNumber" : "23"
    }
  }
}

null


共1个答案

匿名用户

有很多csv转换器在线。 您可以尝试https://json-csv.com/。 保存csv并用Excel打开。