Skip to main content
Search My Knowledge Base

or browse by Topic instead

Lists

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 >

3 ways to notify a user of changes in a SharePoint list

SharePoint lists are great at storing non-document content like issues, tasks, events, contacts or any other info via a custom list. So here is a typical business scenario. Say, you add some content to the list and want to notify a user of changes in a SharePoint list. How do you make this happen? This post will explain the available options. 1. Alert… keep reading >

Why you should never attach documents in a SharePoint list

I see this happening again and again – users attach documents in a SharePoint list. Yes, you can do it – but that is not what SharePoint list was designed for. It is like making pancakes with an iron. As a matter of fact – there are some very strong reasons for you not to continue this poor business practice. Let me… keep reading >

How to hide rows in a SharePoint list

Some time ago I published a post on item-level permissions on a list. The functionality allows you to set read or edit permissions to an item in a list based on whether or not the item was created by the individual trying to access it. But what if you want to hide certain rows in a SharePoint list? In other words, have… keep reading >