I had a bad csv file upload of members. I changed them all to Unsubscribed, but how do I delete these from my members list?
one approach is to create a smart campaign that will delete the unsubscribed persons (everybody who has a field "Unsubscribed" set to True).
Set the conditions in the campaign "Unsubscribed" is "True". If you want to remove just those that you uploaded, you may need to add additional criteria to sort them out., like Person was Created or Created at". And then in the flow step select "Delete person".
But caution: this will delete all these people from the Marketo! (not just remove them from the lists)
That depends on whether you want to (a) delete them from your Marketo instance, or (b) remove them from your list, but leave them in Marketo. As always, there is more than one way to skin a cat - it just depends on whether you want a (digital) paper trail or not.
Deleting them from Marketo entirely
Remove from list only, and keep in Marketo
I hope that helps!
There's something else to consider beyond Diana's and Matjaž's responses.
If by "bad CSV" you mean people you did not ever have permission to email at all -- as in, a purchased list that someone uploaded illicitly -- and you never spammed them, then you should set Unsubscribed back to true just before deleting them.
Otherwise, Marketo will remember that they were Unsubscribed when they later reenter your system via a totally legit route like filling out a form.
Under other circumstances, you would want the Unsubscribed value to be durable, because someone's contact preference must persist even if you delete them. But in this case they didn't actually Unsubscribe, so even though you must get rid of them, you're not under an obligation to remember that you can't contact them.
(Please change your name on the Community by the way, you're supposed to use a real name.)