Skip to main content
SharePoint Knowledge Base

Posts Tagged "Excel"

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 >

Advantages and Limitations of using Office Online in SharePoint and OneDrive

One of the biggest draws of SharePoint Online and Office 365 is the ability to access the files anytime, anywhere. An added benefit, that in my opinion is somewhat of a revolution in collaboration world, is the ability to open and edit documents in Word, Excel and PowerPoint right in the browser. That means that you can work with those file types without… keep reading >

How to export SharePoint to Excel

“Can you export this to Excel?” I bet you hear this request all the time. If you are an avid Excel user or just prefer to visualize things in Excel, you are in luck. Being a Microsoft product, SharePoint has native integration with Excel. And any content can easily be exported to Excel. What can I export from SharePoint to Excel? Any information… keep reading >

Need SharePoint Help?

Hourly consulting, training and configuration services are available

Learn More