The parsing would usually be synchronous (unless you’re parsing huge files using service workers), but the loading would usually be asynchronous. I’d strongly advise you to reconsider if you’re thinking about loading synchronously — generally not a good idea if you care even slightly about user experience.
In any case,
$.get() doesn’t have the ability to parse CSV files.
If this is for learning purposes, I’d recommend you first try writing your own parsing function. CSV is a relatively simple spec, so it’s a good challenge to set yourself as a learner.
If it’s for production code, on the other hand, I’d recommend just using whichever CSV-parsing library has the most stars on github or the most daily downloads on NPM.