I created an Import Spreadsheet list in order to import a list of excel data into my list, now the list have some new custom columns independent to the actual default site columns. Now I want to create a view filtering on that particular custom column, which obviously isn't available in the filter column list. How can I do this?


Importing from Excel always re-create columns starting with headers (if any or use Column 1,2,3) and ignore any site columns you might have defined. Columns will be bound to the List which also means that you seem like filtering your site column which actually is not.

There is no way to directly import from Excel into an existing list but you could have a console application doing it for you or simply use the datasheet view and copy&paste.

Hope it helps, C:\Marius


Filtering is supported for both, site or list level columns.It is not necessary to have custom columns as site columns for that.

  • if that is the case I can't see that particular column which came from the excel in my list filter.
    – GSK
    Nov 18 '11 at 15:18
  • not sure why but it appears... in my case I see Nov 18 '11 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.