i try to convert flatten json data to csv with js.
js code
import { saveAs } from "file-saver";
let data = [{}, {}] //data export from firebase as an array filled with objects
let dataJson = JSON.stringify(data);
let fileToSave = new Blob([dataJson ], {
type: "csv",
name: 'data.csv'
});
saveAs(fileToSave, 'data.csv');
my example json
[
{"kaab":{"ka11":6,"ka12":6,"ka10":6},"ae":{"a6":2,"a5":2,"a4":6},"kg3":"fdsf","kg2":4,"solz":"2","kg1":5,"ges":1,"kaak":{"ka4":5,"ka1":4,"ka5":3,"ka6":5,"ka3":5,"ka2":4},"eink":"","kawe":{"ka9":4,"ka7":5,"ka8":5},"soz2":"","alt":3,"zul":{"infl":1,"spi":1,"int":1,"les":1,"mer":1,"aut":1,"inf2":1},"kg4":2,"am":{"a1":5,"a3":2,"a2":2}}
{"kaab":{"ka11":6,"ka12":6,"ka10":6},"ae":{"a6":2,"a5":2,"a4":6},"kg3":"fdsf","kg2":4,"solz":"2","kg1":5,"ges":1,"kaak":{"ka4":5,"ka1":4,"ka5":3,"ka6":5,"ka3":5,"ka2":4},"eink":"","kawe":{"ka9":4,"ka7":5,"ka8":5},"soz2":"","alt":3,"zul":{"infl":1,"spi":1,"int":1,"les":1,"mer":1,"aut":1,"inf2":1},"kg4":2,"am":{"a1":5,"a3":2,"a2":2}}
]
I have used file-saver
for this but with no big succes.
I get a csv file for excel, but something is still wrong
But I need this as an example expected result
If any of you can help me I really appreciate it. It doesnt need to be done with file-saver