Hi Jordan!
That is a lot of columns and sounds tedious. We definitely want to help make this easier! First, you may already know these tips below, but here are some existing techniques that might help.
From the Column List: What I typically do is highlight multiple columns in the column list, click the data group icon or select Edit > Group, and then uncheck Include on the group to hide columns in bulk. If the columns are sequential in the column list this can be very fast, as you can click the white space to the right of the list and drag to highlight multiple columns.
From the Data Table: Another thought is that you can select just the columns in the data table you want to export. Again if the columns are sequential this can be very fast as you only have to click the first column header and last column header while holding the shift key. Then when you select File > Export Data, it will only export the selected columns.
Another thought is that is might make sense to create an Import Special method to only import the data you need. Do you use all 500 columns? Does the file always have the same format?
If the data is the always in the same format this is possible. If the format varies that could be a problem. ImportSpecial is also a very fast method of importing large datasets, so that is another advantage of using this approach.
Let us know if anything here sounds promising, and we can go from there.