Convert json to csv with js

Question

I need to convert my JSON to a CSV file, but I don't know how to do it correctly.

I have this code already

      let rows = typeof objArray !== "object" ? JSON.parse(objArray) : objArray;
      let header = "";
      Object.keys(rows[0]).map(pr => (header += pr + ";"));

      let str = "";
      rows.forEach(row => {
        let line = "";
        let columns =
          typeof row !== "object" ? JSON.parse(row) : Object.values(row);

        columns.forEach(column => {
          if (line !== "") {
            line += ";";
          }
          if (typeof column === "object") {
            line += JSON.stringify(column);
          } else {
            line += column;
          }
        });
        str += line + "\r\n";
      });
      return header + "\r\n" + str;

But I expect a different result then what I have now

wrong result

I need this expected result

  function ConvertToCSV(objArray) {
      let rows = typeof objArray !== "object" ? JSON.parse(objArray) : objArray;
      let header = "";
      Object.keys(rows[0]).map(pr => (header += pr + ";"));

      let str = "";
      rows.forEach(row => {
        let line = "";
        let columns =
          typeof row !== "object" ? JSON.parse(row) : Object.values(row);

        columns.forEach(column => {
          if (line !== "") {
            line += ";";
          }
          if (typeof column === "object") {
            line += JSON.stringify(column);
          } else {
            line += column;
          }
        });
        str += line + "\r\n";
      });
      return header + "\r\n" + str;
  }
  
  function downloadCSV () {
    let data = [{"am":{"a3":2,"a1":5,"a2":2},"zul":{"mer":1,"spi":1,"aut":1,"inf2":1,"int":1,"infl":1,"les":1},"kaab":      {"ka11":6,"ka12":6,"ka10":6},"kg3":"fdsf","ges":1,"alt":3,"kawe":{"ka9":4,"ka7":5,"ka8":5},"kaak":{"ka2":4,"ka3":5,"ka4":5,"ka1":4,"ka5":3,"ka6":5},"kg4":2,"kg1":5,"eink":"","kg2":4,"soz2":"","solz":"2","ae":{"a6":2,"a5":2,"a4":6}}]
    
    let result = ConvertToCSV(data);
    
    let fileToSave = new Blob([result], {
       type: "csv",
       name: 'data.csv
     });

     saveAs(fileToSave, 'data.csv);
  }

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/FileSaver.min.js"></script>
<button onclick="downloadCSV">download csv</button>

Cagri Tacyildiz · Accepted Answer · 2020-05-16 11:31:43Z

3

You can try this

function downloadCSV () {

    let arr = [{"am":{"a3":2,"a1":5,"a2":2},"zul":{"mer":1,"spi":1,"aut":1,"inf2":1,"int":1,"infl":1,"les":1},"kaab":      {"ka11":6,"ka12":6,"ka10":6},"kg3":"fdsf","ges":1,"alt":3,"kawe":{"ka9":4,"ka7":5,"ka8":5},"kaak":{"ka2":4,"ka3":5,"ka4":5,"ka1":4,"ka5":3,"ka6":5},"kg4":2,"kg1":5,"eink":"","kg2":4,"soz2":"","solz":"2","ae":{"a6":2,"a5":2,"a4":6}},
 {"am":{"a3":2,"a1":5,"a2":2},"zul":{"mer":1,"spi":1,"aut":1,"inf2":1,"int":1,"infl":1,"les":1},"kaab":      {"ka11":6,"ka12":6,"ka10":6},"kg3":"fdsf","ges":1,"alt":3,"kawe":{"ka9":4,"ka7":5,"ka8":5},"kaak":{"ka2":4,"ka3":5,"ka4":5,"ka1":4,"ka5":3,"ka6":5},"kg4":2,"kg1":5,"eink":"","kg2":4,"soz2":"","solz":"2","ae":{"a6":2,"a5":2,"a4":6}}   
    ];
  
    var keys = [];
    var values = [];
    function getKeys(data, k = '') {
      for (var i in data) {
        var rest = k.length ? '_' + i : i
        if (typeof data[i] == 'object') {
          if (!Array.isArray(data[i])) {
            getKeys(data[i], k + rest)
          }
        } else keys.push( k+ rest)
      }
    }   
    function getValues(data, k = '') {
      for (var i in data) {
        var rest = k.length ? '' + i : i
        if (typeof data[i] == 'object') {
          if (!Array.isArray(data[i])) {
            getValues(data[i], k + rest)
          }
        }
        else values.push(data[rest])
      }
    }

    getKeys(arr[0])
    var value="";
    arr.forEach(x=>{
       values=[];
       getValues(x);
       value+=values.join(";")+"\r\n";
    })
    
    let result = keys.join(";")+"\r\n"+value;
    let fileToSave = new Blob([result], {
       type: "csv",
       name: 'data.csv'
     });
        
    saveAs(fileToSave, 'data.csv');
  }

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/FileSaver.min.js"></script>
<button onclick="downloadCSV()">download csv</button>

edited May 16, 2020 at 11:31

answered May 16, 2020 at 11:15

Cagri Tacyildiz

17.7k6 gold badges38 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

masterDoom luxiary Over a year ago

this looks much better. Thank you

masterDoom luxiary Over a year ago

But all the data is in one row, thats a problem

masterDoom luxiary Over a year ago

I need to have for each main object one row in excel file

masterDoom luxiary Over a year ago

I need to have one row for each object So if inside the let arr= [{}, {}, {}] more objects

masterDoom luxiary Over a year ago

Yeah that better. But one last thing:

|

Collectives™ on Stack Overflow

Convert json to csv with js

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related