Creating a CSV File for Download from a JavaScript Array

Question

Creating a CSV File for Download from a JavaScript Array

I have the information stored in a specific structure:

var nicedata =[{...}, {...}, {...}, {...}, {...}, {...}, {...}, {...}, {...}, {...}]

each individual object has this format:

0:{1: "1", Affiliate Name: "AName", Brand1: "Bname", Business type: "Company Stores", Calendar Month Year: "mm/dd/yyyy", Category: "Null", ...}

1:{1: "1", Affiliate Name: "AName", Brand1: "Bname", Business type: "Company Stores", Calendar Month Year: "mm/dd/yyyy", Category: "Null", ...}

I am attempting to export this data into a CSV file, but my current attempt using alaSQL is not producing the desired output.

alasql("SELECT * INTO CSV('DataExport.csv',{headers:true}) FROM ?", [niceData]);

Although I can successfully download the data, each row's entire content is being inserted into a single cell.

My goal is to generate a proper CSV file with headers and corresponding values. Can anyone provide assistance with achieving this?

javascript arrays dictionary export-to-csv

Answer 1

Answer №1

Imagine a comma-separated text as nothing more than a transformed table. This transformation can be achieved by using a combination of for loops, as demonstrated in the code snippet below.

var array = [{
 a:'11',
 b:'12',
 c:'13'
}, {
 a:'21',
 b:'22',
 c:'23'
}, {
 a:'31',
 b:'32',
 c:'33'
}];

var csv = '';
for(var row of array){
  for(var prop in row){
    var cellVal = row[prop];
    csv += '"' + cellVal + '", '
  }
  csv += '\n';
}

console.log(csv);

Answer 2

Imagine a comma-separated text as nothing more than a transformed table. This transformation can be achieved by using a combination of for loops, as demonstrated in the code snippet below.

var array = [{
 a:'11',
 b:'12',
 c:'13'
}, {
 a:'21',
 b:'22',
 c:'23'
}, {
 a:'31',
 b:'32',
 c:'33'
}];

var csv = '';
for(var row of array){
  for(var prop in row){
    var cellVal = row[prop];
    csv += '"' + cellVal + '", '
  }
  csv += '\n';
}

console.log(csv);

Creating a CSV File for Download from a JavaScript Array

Answer №1

Similar questions

Tips for inserting a variable into an attribute value when creating it using TypeScript

Is there a way to change ngx-timeago language when the button is pressed?

Trouble retrieving information from cloud function through https callable connection

What's the scoop on NodeJS, Express, Nginx, and Jade?

Executing multiple commands within a single child process in Node.js

What methods can I use to evaluate my Angular scope functions in karma and jasmine?

Utilizing SVG icons with AngularJS for optimal compatibility in Firefox

"Mastering the art of event delegation: A guide to effectively engaging with various

Having difficulty resetting the form post-login in Ionic

Discover the nodes with the highest connections in a D3 Force Graph

What is the reason for recursion not producing a new object as output?

What is the formula to determine the sizes of grandchildren div containers?

Using JQuery to extract information from a JSON file

Tips for managing multiple controlled tooltip components in Material UI

Implementing selective input element disabling within a form using jQuery

Trouble with Express.js and Mongoose: Issue with find() method not returning results for specified variable

Matching current URL and links by checking the div class

JavaScript function to add or subtract

Adding a dynamic row to ag-grid with customizable columns on the fly

The barcode is not displaying when using javascript:window.print() to print