It's quite a common operation, file size doesn't really matter. I do it with 20GB CSV files sometimes.
I use undatum cmd tool created initially for JSON lines processing but it works with CSV files too.
Example of the command to get a list of headers fields
undatum headers budgetreg_domains.csv
It will provide a list of field names from the file first line