Parse CSV from URL into Array using Javascript

Question

I'm relatively new to javascript but I want to get some data from a csv file that is saved online and gets updated each hour.

The data should be displayed on a table later on but I have some problems with saving it to an array. The csv file is comma seperated, has 9 columns, over 6000 rows and is a long string of text, so no linebreaks. The first row contains usernames and each username with special characters is conclosed with quotation marks.

I've tried several codes over the past few days, but none worked. Can I parse a online CSV file into an array at all? Is there an alternative like with SQL or saving the file to my server?

Remember: The file gets updated each hour..

NOTE: There are not really problems with the codes I've found, all of these were tested by others and seemed to work. But only for local files, not actual URLs!

Why don't you share what you've worked on so we can help you from there? — Indigo, Jun 22 '15 at 19:31
possible duplicate of [Javascript code to parse CSV data](http://stackoverflow.com/questions/1293147/javascript-code-to-parse-csv-data) — scribblemaniac, Jun 22 '15 at 19:48
my string looks like: username1, adress1, age1, children1, "u╣ername2", adress2, age2, children2,... — Innerwolf, Jun 23 '15 at 08:38

score 1 · Answer 1 · edited May 23 '17 at 12:29

1

You can use this https://code.google.com/p/jquery-csv/ plugin and it is possible to convert multi-line csv into 2D-array using $.csv.toArrays(csv) or to an object using $.csv.toObjects(csv). Check this post or this one for more info

$.ajax({
    url: "urlto/filename.csv",
    success: function (data) {
        var arr = $.csvtoArray(data);
        _oncomplete(arr);
    },
    dataType: "text",
    });

_oncomplete: function (arr) {
    //Your array here
    }

edited May 23 '17 at 12:29

Community

1
1

answered Jun 22 '15 at 19:37

meteor

2,518
4
38
52

does it support online links as source? – Innerwolf Jun 23 '15 at 08:43
yes it does as mentioned in http://stackoverflow.com/a/23763523/909535! check the updated answer – meteor Jun 23 '15 at 12:49
but it's not a multi line csv! – Innerwolf Jun 23 '15 at 13:59
Then you can use `csv.toArray(csv)` to Parse a single entry string to an array – meteor Jun 23 '15 at 14:03
could you do a quick jsfiddle with an example csv? with just an output of the array, i would appreciate this really much! – Innerwolf Jun 23 '15 at 14:40
There is one already provided as demo http://jquery-csv.googlecode.com/git/examples/basic-usage.html – meteor Jun 23 '15 at 14:51
It doesn't work for me somehow, not even for local files. What am I doing wrong? Followed each step – Innerwolf Jun 23 '15 at 20:23
You should learn to use the developer tools of your web browser. Your ajax request fails: `{"error": "Please use POST request"}` – Mehdi Jun 25 '15 at 21:05

score 0 · Answer 2 · answered Jun 22 '15 at 19:52

You can have a look at papaparse for a solid and full-featured CSV parsing library.

setInterval javascript function lets you update the data every hour, in case you decide to develop this part on the client.

Is there an alternative like with SQL or saving the file to my server?

Yes there are alternatives, the right architecture depends on your use case. How many visitors will go to your web page and view the results, how critical your application is, how reliable the data source is, etc. If you're not sure about these you should talk to a web developer with more experience around these questions.

You may want to parse the CSV file every hour on the server and store a copy of the data there, to serve to your visitors. This way, if the upstream data source is unavailable, you still have a copy of the data from the past.

P.S.:

I've tried several codes over the past few days, but none worked

stackOverflow is about this: getting help about specific problems in your code, rather than asking general questions (answer to those can be found easily using a search engine).

The data is not critical at all and the source is very reliable, so saving it to my server is not really necessary. There are not really problems with the codes I've found, all of these were tested by others and seemed to work. But only for local files, not actual URLs! — Innerwolf, Jun 23 '15 at 08:42

Parse CSV from URL into Array using Javascript

2 Answers2