I checked out the Views CSV Source module recently during @drupaleasy Office Hours and we were impressed! It handled a file with 200k+ rows and worked as advertised!

If you have a .csv file that you want to display with #drupal Views (including filters!), check it out:

https://www.drupal.org/project/views_csv_source

Thanks to @andileco for the nudge!