Skip to main content
Search My Knowledge Base

or browse by Topic instead

Lists

3 ways to create custom lists in SharePoint

I love custom lists! They are a great way to organize non-document information. Whether it is a list of issues, a list of projects, or a list of vacation requests – lists allow for a great web-based alternative to Excel. By the way, I compared the two in the past. Over the years, lists evolved, and we now have several ways to… keep reading >

How to hide a field in SharePoint lists and libraries with the conditional formula

Working with SharePoint reminds me of watching James Bond movies – you think you have seen them all and know all the cool spy gadgets, yet, a new movie comes out, and there is a set of the new tricks in the book. The same with SharePoint – it is like a goldmine of cool stuff. Recently, I learned a cool trick,… keep reading >

How to create a custom list in SharePoint by copying an existing custom list

We always had various ways to create custom lists in SharePoint: we could create one manually, import from Excel, and we could also create one a custom list by copying an existing list. That last option was there but required a bit of manipulation and luck. Fortunately, with the introduction of modern SharePoint lists, we now have a much easier way to… keep reading >

How to import an Excel spreadsheet to a SharePoint custom list

Importing Excel to SharePoint has always been somewhat of a matzo ball. We had a few options available, but each one came with a long list of quirks that made the whole process and result less than desirable. Recently, Microsoft has added a new capability to SharePoint Lists, where users can import Excel spreadsheets to a SharePoint Custom list, and the whole… keep reading >

SharePoint Custom list vs. Excel

Quite often, I am asked by my clients and blog followers, whether or not it makes sense to transition information from Excel to SharePoint custom lists. As with many things in life, the answer is “It depends.” Let me list the advantages of both, which hopefully will help you make the right decision. I assume you have an idea of what Excel… keep reading >

3 ways to import Excel to SharePoint

A while back, I published a post where I explained how to export SharePoint lists from SharePoint to Excel. Today, I am going to cover the opposite of this – how to import Excel to SharePoint. Say, you have an Excel list/table and want to bring it to SharePoint (because SharePoint custom list kicks ass!). How do you achieve this? Well, let… keep reading >

How to create a custom list in SharePoint

We have lots of out of the box web parts at our disposal in SharePoint. We have Tasks for task management, issues for issues management, a calendar for events, and so on. But what if you want to create a custom list in SharePoint with your own custom columns and replicate, say an Excel spreadsheet? It is not that hard at all… keep reading >