Rainbow CSV is an extension for VSCode that makes working with CSV fields in that editor a lot more bearable.

Not only, as you’d guess from its name, does it colour code things - but you can also run pseudo-SQL commands against the file’s contents to get some quick answers right there and then. Use the RBQL command in VSCode to do that.

Syntax is a little bit different to typical SQL, but easy to pickup. This for instance counts records of a certain value:

select count(a.customer_id) where a.meets_criteria == 'TRUE'