how to import data either via CSV, JSON or Spreadsheet

Lumigraphics,

thank you! i included a snippet of code that worked for me in the post above

Thank you very much i was able to find a snippet of code that worked for me. I'll place it below incase someone wants to know.  But yes it seems like you have to just read the file and use the .split() method to split by line and by commas in a Comma Seperated Value (.CSV) file.  It wasnt too hard to find out after.  Thanks for your help

var scriptRoot = app.activeDocument.path;
var fileCsv = File(scriptRoot + "/data.csv");

function csv2obj() {
    fileCsv.encoding = "utf-8";
    fileCsv.lineFeed = 'Macintosh';
    fileCsv.open('r', undefined, undefined);
    var content = fileCsv.read();
    fileCsv.close();
    var lines = content.split('\n');
    var csvArrObjs = [];
    var keys = lines[0].split(',')

    for (var i = 1; i < lines.length; i++) {
        var cells = lines[i].split(',');
        var obj = {};
        for (var k = 0; k < cells.length; k++) {
            obj[keys[k]] = cells[k].replace(/\s*/gm, '');
        }
        csvArrObjs.push(obj);
    }
    return csvArrObjs;
}

var csvObj = csv2obj(fileCsv);