Text Import Wizard, Step 3 (converting .tsv file to Excel)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello -
I hope I am posting this to the correct discussion group.

When converting a .tsv file to Excel using the Text Import Wizard > Column
Data Format > Step 3, which is "Do not import column (Skip)," is there any
way I can globally exclude columns? I have 50 columns to exclude, and
clicking each column individually and excluding each column one-by-one takes
a lot of time. In other words, is there a way I can exclude columns in
groups vs. one at a time?

My .tsv files are too large to convert to Excel and delete the columns there.

Thanks a lot in advance,
 
Are you always excluding the same columns? If so record a macro and do it.
If the columns are contiguous you can hold down shift and click first and
last to select those you don't want
 
Thanks for responding, Peo. Yes, I am always excluding the same columns but
not all are contiguous. Holding the shift key helps quite a bit. I don't
know where first and last is in Step 3? I may be missing something though?

I don't know anything about macros. I guess I will have to learn.

Thanks again,
Eve
 
Back
Top