you can set the filter to view in-active products. click the magnifying glass with the plus in the middle, then drop down the filter and click archived.

Note that setting a Boolean field like active to empty is equivalent to false as 0= false.

PS: if you imported the products without an export ID multiple times, then those products will be duplicated. I suggest you filter on list view and delete the duplicates if there are any.

Active field was left blank in the CSV file. I was able to see products on screen after updating the field to TRUE in CSV file and importing again. I wonder, however, if it is a design flaw that it doesn't seem to be possible to see imported records anywhere from user interface in case Active=FALSE. I updated the field value from FALSE to TRUE in product_product using pgAdmin so I could see those records on OE screen for deletion.