Exporting Data to CSV file NodejS Express

So, after a lot of struggling, I will share my main insights, that are not that obvious to whom who are making their first steps in web development.

Exporting to CSV can be divided into two main steps: 1. Arranging your Data into CSV structure/model. 2. Exporting the data / make it be downloaded on the client side.

So I'll break it down. The first step - Arranging your Data into CSV structure/model: To get your data into CSV structure, most likely you can find a library that takes the data you want to export and format it into CSV. If your data model is as complexed as mine, you will have to create a custom function. Either way, that shouldn't be too complicated. an example of such function that I used:

// The function gets a list of objects ('dataList' arg), each one would be a single row in the future-to-be CSV file
// The headers to the columns would be sent in an array ('headers' args). It is taken as the second arg
function dataToCSV(dataList,headers){
    var allObjects = [];
    // Pushing the headers, as the first arr in the 2-dimensional array 'allObjects' would be the first row
    allObjects.push(headers);

    //Now iterating through the list and build up an array that contains the data of every object in the list, in the same order of the headers
    dataList.forEach(function(object){
        var arr = [];
        arr.push(object.id);
        arr.push(object.term);
        arr.push(object.Date);

        // Adding the array as additional element to the 2-dimensional array. It will evantually be converted to a single row
        allObjects.push(arr)
    });

   // Initializing the output in a new variable 'csvContent'
    var csvContent = "";

    // The code below takes two-dimensional array and converts it to be strctured as CSV
    // *** It can be taken apart from the function, if all you need is to convert an array to CSV
    allObjects.forEach(function(infoArray, index){
      var dataString = infoArray.join(",");
      csvContent += index < allObjects.length ? dataString+ "\n" : dataString;
    }); 

    // Returning the CSV output
    return csvContent;
}

Now, the second step - Exporting the data: In order to export the data, after examining few options, I found that the most convenient (for me), was to sent the data over the HTTP header and make the browser to download the file and parse it as CSV. That I made with the following code:

//this statement tells the browser what type of data is supposed to download and force it to download
    res.writeHead(200, {
        'Content-Type': 'text/csv',
        'Content-Disposition': 'attachment; filename=*custom_name*.csv'
    });
// whereas this part is in charge of telling what data should be parsed and be downloaded
    res.end(dataToCSV(dataList,["ID","Name","Date"]),"binary");

In conclusion, I made this post so others won't struggle like I did when it comes to exporting CSV using nodejs and express. If you find any errors, or you think that some of the written above should be explained more thoroughly, please let me know and I'll make the necessary changes.

Kind Regards.