I am looking to import certain information from a CSV file that is 4GB in size (first row is the header row). Rather than import the entire CSV file, I only want to import certain rows that meet a certain criteria. In this case, all rows that contain the value "AZ" in a column labeled "Provider Business Practice Location Address State Name". I am working in Excel 2010. Any ideas how to create a macro to do it? Thanks.