SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

share|improve this answer

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

share|improve this answer
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 – Amit Kumawat Nov 18 '11 at 15:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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