For extremely large CSVs I use Emeditor (windows / paid). It also works with JSON, but never had to handle large JSONs