Consume remote CSV files via jQuery?

Question

I have a CSV file hosted on a remote server. Is there a way for jQuery to consume that file so it can be converted to a jQuery array? Would I still be facing cross-site scripting problems?

Try this: stackoverflow.com/a/12289296/761963

Jorge Orpinel Pérez
– Jorge Orpinel Pérez

2016-07-08 07:29:09 +00:00
Commented Jul 8, 2016 at 7:29 — Jorge Orpinel Pérez
– Jorge Orpinel Pérez, Commented Jul 8, 2016 at 7:29

vzwick · Accepted Answer · 2011-10-26 00:21:46Z

4

You'll be running into restrictions imposed by the Same Origin Policy. In short, AJAX calls to a different domain are prohibited and will always (but for very very rare exceptions) fail, no matter what the content is.

You need to either use JSONP (mostly applicable to data returned by APIs) or proxy the request through your own server/domain.

Consuming the CSV itself is rather trivial:

csv_arr = csvstring.split(/\n/);
$.each(csv_arr, function(i,e){
    csv_arr[i] = e.split(',');
});

Edit: Caution, as @echoback mentioned, I have missed the possibility of quoted values.

Luckily, there's an awesome plugin that turns CSV into JSON. Just like that.

edited Oct 26, 2011 at 0:21

answered Oct 26, 2011 at 0:00

vzwick

11.1k5 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

wersimmon Over a year ago

Remember to consider quoted strings. "hello, world", 1234 is two elements, not three.

vzwick Over a year ago

@echoback Thanks, I had missed that. Updated the answer accordingly.

Jorge Orpinel Pérez Over a year ago

csonv.js doesn't seem to work properly for me (on Firefox). I'm going to try D3: learnjsdata.com/read_data.html

vzwick · Accepted Answer · 2011-10-26 00:13:46Z

1

Yes, you'd still have to solve cross domain issues. Your best approach is to use web services on the other end and consume via JSONP and callbacks.

edited Oct 26, 2011 at 0:13

vzwick

11.1k5 gold badges47 silver badges63 bronze badges

answered Oct 25, 2011 at 23:36

Moin Zaman

25.5k6 gold badges74 silver badges74 bronze badges

Comments

seanb · Accepted Answer · 2011-10-25 23:51:01Z

0

Am not sure on the cross domain issues - but have used jquery ajax to fetch csv files from same domain, then just use javascript split() on line breaks and commas to make arrays.

answered Oct 25, 2011 at 23:51

seanb

6,9642 gold badges35 silver badges34 bronze badges

Collectives™ on Stack Overflow

Consume remote CSV files via jQuery?

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related