Depending on exactly what you want, you may be able to use the Contributions and Membership report, filtering on Finance type for membership and then exporting as CSV. But you'd need to do a bit of work in it as the contact info isn't shown on every line.
You may need to run below query to disable the field so that they don't appear on screen. Deleting the field is little risky as you may end up creating screwing financial data.
UPDATE civicrm_price_field cpf
INNER JOIN civicrm_price_set_entity cpse
ON cpse.entity_table = 'civicrm_contribution_page'
AND cpse.price_set_id = cpf.price_set_id
If a membership is auto-renew than it should be linked to recurring contribution(See under contribution tab >> recurring tab).
To turn off auto-renew for a membership, you can either
Cancel the recurring, that should cancel ongoing recurring payment and also membership renewal
Run Below query to only turn off membership renewal
Sorry for the confusion here folks, I was mixing 'profiles' with 'custom field sets'.
My membership profile contained custom membership fields and this profile wasn't available when editing or creating some specific membership types.
However, what I didn't realise was that when setting up custom membership fields you must choose which memberships you want ...