You can do it Tableau Prep without generating any worksheets
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
If you hide all of your unused columns in your view before publishing and have the user export the full data, all of the additional columns not in the view will come with it as long as they are not hidden.