Converting JSON object to CSV format in JavaScript

Question

I am trying to convert a JavaScript object set in to CSV format

You can get the idea about my Javascript object, if you put it in online JSON parser http://json.parser.online.fr/

This is how I tried to work it out... but it flopped.. http://jsfiddle.net/fHQzC/11/

I am trying to take the whole values corresponding to the value "term" and corresponding title in to CSV format

The expected output for is like

Time,Dec 9, 2012 
News,Germany,election, Egypt,Revolution, Japan, Earthquake
Person,Obama, Beckham
Title,Pearce Snubs Beckham                                
Time,Dec 5, Birthday
Person, Lebron James
News,Italy,Euro 2012 Final
Title-Heats National Champions

and is it possible to download the csv file in excel sheet the one I found in Stackoverflow was not really useful me...

I guess you've already checked http://stackoverflow.com/questions/4130849/convert-json-format-to-csv-format-for-ms-excel and that didn't work for you? — Ando, Jun 29 '12 at 06:33

score 27 · Answer 1 · edited Jan 03 '14 at 22:17

27

you can try as

$(document).ready(function () {

        // Create Object
        var items = [
              { name: "Item 1", color: "Green", size: "X-Large" },
              { name: "Item 2", color: "Green", size: "X-Large" },
              { name: "Item 3", color: "Green", size: "X-Large" }];

        // Convert Object to JSON
        var jsonObject = JSON.stringify(items);

        // Display JSON
        $('#json').text(jsonObject);

        // Convert JSON to CSV & Display CSV
        $('#csv').text(ConvertToCSV(jsonObject));
    });

and a function ConvertToCSV

// JSON to CSV Converter
        function ConvertToCSV(objArray) {
            var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
            var str = '';

            for (var i = 0; i < array.length; i++) {
                var line = '';
                for (var index in array[i]) {
                    if (line != '') line += ','

                    line += array[i][index];
                }

                str += line + '\r\n';
            }

            return str;
        }

Source

edited Jan 03 '14 at 22:17

Raghd Hamzeh

304
10
16

answered Jun 29 '12 at 06:34

Hemant Metalia

25,838
17
67
86

2

complexity does not affect this as the format of the csv will always remain same.. – Hemant Metalia Jun 29 '12 at 06:38
2

have you checked http://stackoverflow.com/questions/4130849/convert-json-format-to-csv-format-for-ms-excel ? – Hemant Metalia Jun 29 '12 at 06:39
1

Will this include a comma in a value? – Sunil Feb 22 '14 at 08:37
json is comma separated value it will not consider comma as value. you need to use some trick for that. – Hemant Metalia Feb 24 '14 at 04:29
This should be extended to be RFC4180 compliant, specifically to enclose in double quotes strings that may contain commas or line breaks, and escape any embedded double quotes. See [json2csv](https://github.com/zemirco/json2csv) – prototype Apr 22 '15 at 21:43
enclose every value in string to escape commas.. `"value", "value", "value"....\n` – Muhammad Umer Apr 02 '19 at 16:03

Eesa · Answer 2 · 2017-10-26T07:52:57.550

21

Here is my solution

function arrayToCSV(objArray) {
     const array = typeof objArray !== 'object' ? JSON.parse(objArray) : objArray;
     let str = `${Object.keys(array[0]).map(value => `"${value}"`).join(",")}` + '\r\n';

     return array.reduce((str, next) => {
         str += `${Object.values(next).map(value => `"${value}"`).join(",")}` + '\r\n';
         return str;
        }, str);
 }

Example:

let arr = [{name: "Essa", age: 25}];
console.log(arrayToCSV(arr));

edited Oct 26 '17 at 07:52

answered Oct 26 '17 at 07:32

Eesa

2,288
2
24
46

this escapes comma separated values inside columns – RisingSun Aug 27 '19 at 22:16
@RisingSun no it doesn't – Eesa Nov 26 '19 at 08:29

mightybruno · Answer 3 · 2021-04-07T13:06:44.970

15

Probably more elegant and the simplest solution

function convertToCSV(arr) {
  const array = [Object.keys(arr[0])].concat(arr)

  return array.map(it => {
    return Object.values(it).toString()
  }).join('\n')
}


console.log(
  convertToCSV(
    [
      {
        id: 1,
        name: 'Foo',
        timestamp: new Date()
      },
      {
        id: 2,
        name: 'Bar',
        timestamp: new Date()
      },
      {
        id: 3,
        name: 'Baz',
        timestamp: new Date()
      }
    ]
  )
)

edited Apr 07 '21 at 13:06

answered Nov 08 '19 at 15:34

mightybruno

1,117
5
11

Thank you, this is exactly the solution I need. I believe this to be the best answer. – Tyler Miles Mar 09 '20 at 17:52

score 6 · Answer 4 · answered Nov 20 '20 at 11:52

Here's a solution similar to mightybruno's answer that handles strings containing commas. None of the other answers seem to take this in to consideration.

function objectsToCSV(arr) {
    const array = [Object.keys(arr[0])].concat(arr)
    return array.map(row => {
        return Object.values(row).map(value => {
            return typeof value === 'string' ? JSON.stringify(value) : value
        }).toString()
    }).join('\n')
}

score 1 · Answer 5 · answered Jan 20 '16 at 08:55

This is my solution

https://jsfiddle.net/dhou6y3o/

function iterateObject(obj) {
  var value = '', header = '';
          for (name in obj) {
            if (obj.hasOwnProperty(name)) {
              if (isObject(obj[name])) {
                var out = iterateObject(obj[name]);
                value += out.value;
                header += out.header;
              } else {
                value += removeNewLine(obj[name]) + '; ';
                header += name + '; ';
              }
            }
          }
  return {
    "value":value,
    "header":header
  };
}
function isObject(obj) {
  return (typeof obj === 'object');
}
function removeNewLine(item) {
  return item.toString().replace(/(\r\n|\n|\r)/gm,"");
}

score 1 · Answer 6 · answered May 04 '19 at 14:12

1

This is a quick & dirty, but probably works for most cases:

const headers = Object.keys(objAry[0])
console.log(headers.join())

objAry.forEach(r => console.log(
   Object.values(r)
   .map(c => Array.isArray(c)? `"${c.join()}"` : c)
   .join())
)

answered May 04 '19 at 14:12

Jeff Lowery

1,953
24
34

score 1 · Answer 7 · answered Sep 01 '20 at 19:13

1

Use papaparse library to convert JSON to CSV and Vice Versa. Refer to this link - https://www.papaparse.com/

answered Sep 01 '20 at 19:13

prakhar goyal

13
4

score 1 · Answer 8 · answered Nov 03 '20 at 13:14

Below code will convert and download JSON array to csv as a file.

 function exportJSONToCSV(objArray) {
    var arr = typeof objArray !== 'object' ? JSON.parse(objArray) : objArray;
    var str =
      `${Object.keys(arr[0])
        .map((value) => `"${value}"`)
        .join(',')}` + '\r\n';
    var csvContent = arr.reduce((st, next) => {
      st +=
        `${Object.values(next)
          .map((value) => `"${value}"`)
          .join(',')}` + '\r\n';
      return st;
    }, str);
    var element = document.createElement('a');
    element.href = 'data:text/csv;charset=utf-8,' + encodeURI(csvContent);
    element.target = '_blank';
    element.download = 'export.csv';
    element.click();
  }

score 0 · Answer 9 · answered Sep 18 '20 at 00:31

Similar to mightybruno's answer but this would allow separate access to the headers and content (by moving the join statements to later in the function) if desired.

function objToCsv(data) {
    const headers = Object.keys(data[0]).join();
    const content = data.map(r => Object.values(r).join());
    return [headers].concat(content).join("\n");
}

Converting JSON object to CSV format in JavaScript

9 Answers9

Linked