Trying to export single column's data from large CSV file

I'd suggest you check out TextQ (disclaimer - I'm its developer). It can import big CSV files and allows you to manage its schema/structure (e.g. rename or hide columns)

You can perform queries via a UI Query Builder or SQL.

You can then export the data to a CSV file, which can be imported in MS Excel or others.

You can get it from the Mac App Store or Microsoft Store (soon).