i am new to Shopify-Excel App and doing something wrong. When i import products from a file with a column collection, every product is placed in a new collection while lots of them has the same collection name in the file.
From about 15 days ago Collections is explicitly separated into Custom and Smart (auto) collections. If you had file exported before it may be that you have smart collections in the values so it suggests to create custom collections with that name.
If you did not change anything regarding collections you can just un-tick collection filed on second import screen to omit it,.