JSON → TSV

script

const selected = editor.getSelectedText();
let query = '';
let string = '';

if (!selected || selected.length === 0){
   query = editor.getText();
}else{
   query = selected;
}

const items = JSON.parse(query);
const replacer = (key, value) => value === null ? '' : value;
const header = Object.keys(items[0]);
const csv = [
  header.join('\t'), // header row first
  ...items.map(row => header.map(fieldName => JSON.stringify(row[fieldName], replacer)).join('\t'))
].join('\r\n')

string = csv;

if (!selected || selected.length === 0){
	editor.setText(string);
}else{
	editor.setSelectedText(string);
}

clipboard

[[draft]]