Table of Contents:Does a straight method exist?Method 1: Download and  upload as ExcelMethod 2: Share link to Google SheetsMethod 3: Use third-party tools for bulk migration Want to save your Google Sheets? In this guide, I will show you some methods you can use to save your Google Sheets file to Sharepoint. Let’s get started. Does a straight method exist? Unfortunately, there isn’t a direct method out-of-the-box that will enable you to move Google Sheets to SharePoint. But some alternatives exist: While these work, there’s no fully seamless process for transferring a Google Sheets file to SharePoint Online in native […]

Table of Contents:Link Two Words on the Same SharePoint PageStep 1: View the SharePoint pageStep 2: Select the source word/wordsStep 3: Create the anchorWhat are internal links in SharePoint? Want to link different words? In this guide, I will show you how to link two words on the same page in SharePoint Online quite easily. Let’s get started. Link Two Words on the Same SharePoint Page Okay, I’ve got a bad news and a good news. The bad news is, although you can technically link two “regular” words on the same page, it won’t anchor or scroll through. The good

Table of Contents:What is the SharePoint guest expiration policy?How Expiration Policies Work at the Tenant and Site LevelsHow to Extend External User Access in SharePointStep 1: Site permissionsStep 2: Extend buttonCommon Issues and How to Resolve Them Got some guests whose access is expiring soon? In this guide, I will show you how to easily extend the SharePoint external user access for those nearing expiration. Let’s get started. What is the SharePoint guest expiration policy? The short of it is that this policy is designed to manage the access of external users who are invited to collaborate on content. Here’s

Table of Contents:What is the user information list?How are users added to the list?How to Access the Hidden User Information ListMethod 1: Direct URLMethod 2: Site settingsUser Information List in Different SharePoint Versions Want to know more about this list? In this guide, let’s talk about the user information list in SharePoint, what it does, and how to access it. Let’s get started. What is the user information list? Basically, this user information list is a hidden list that stores basic details about users who interact with a SharePoint site. It contains the following information: This list is also automatically

Table of Contents:What’s in the list settings?Normal Way of Accessing the List SettingsWhat if you can’t access the toolbar?Accessing List Settings Using the List GUIDDon’t Panic Right Away What if you can’t access the gear icon? In this guide, I’ll show you how you can get to the list settings page of any list in SharePoint Online. Let’s get started. What’s in the list settings? As you already know, the list settings provide important tools for managing and customizing the lists. Here are the main options you will find: These will help you adjust your lists to meet specific needs.

Table of Contents:From the SharePoint List View (Standard Method)Automatic Export Process with Power AutomateHow about exporting large SharePoint lists?Differences Between Exporting to Excel and CSVExporting Data to Excel Want to view your data in Excel instead? In this guide, I will walk you through different methods of exporting data from a SharePoint list to Excel. Let’s get started. From the SharePoint List View (Standard Method) What’s nice here is that the process is simple and quick. Simply access the list in the SharePoint site where it’s located, and click the export option from the command bar. Once you click export,

Table of Contents:What does exporting a library mean?Method 1: Export to ExcelMethod 2: Excel’s Data Tab for Metadata ExportPractical Use Cases Can you export a library to Excel? In this guide, I will show you how you can easily export a document library from SharePoint Online to Excel. Let’s get started. What does exporting a library mean? Basically, it allows you to take the data stored in the library and view it in an Excel workbook. Here’s what’s included in the export data: It’s important to note that exporting a library doesn’t include document contents or file versions. In a

Table of Contents:Prepare the WorkbookHow to Publish the WorkbookMethod 1: Save directly to SharePointMethod 2: Uploading via SharePoint LibraryWhy Publish the  Workbook Want to publish directly to SharePoint? In this guide, I will give you a walkthrough on publishing an entire workbook straight to a SharePoint site. Let’s get started. Prepare the Workbook Before you can publish your workbook, you need to prepare it first. 🙂 Here’s what you need to do: Even if you limit what people can see in the browser, the entire Excel file is still saved on the SharePoint server. For this reason, always check that

Table of Contents:What are SharePoint lists?What methods can you use to create lists?Step-by-Step Guide to Creating a ListStep 1: New listStep 2: Select the methodStep 3: Name your list and add a descriptionCustomizing the List1. Adding and modifying columns2. Conditional formattingHow to Add Data to Your List1. Manually adding items2. Edit in grid view3. Using forms to add dataManaging List ViewsAdditional List Features1. Version control2. Approval settings3. Task automationUsing a List in SharePoint Online Not sure how to create a list? In this guide, I will walk you through creating a list in SharePoint Online and how to add data