Publish excel worksheet as SharePoint List

By
In this article, we  are going to demonstrate easiest way to create SharePoint List using your Excel Workbook. The SharePoint List comes handy to maintain your data as it allows great flexibility and collaboration to manage the content, modify, etc.

Step 1: Select the worksheet from your excel workbook which you want to publish as SharePoint List and then format it as HTML.

Excel to SharePoint List

Step 2: Once the data in worksheet is formatted as table, select the table and go to Table Design Menu and then select Export Table To SharePoint List. In the dialog box as below, enter the Address - URL of the SharePoint site where you want the List to be Created and then Finish. This shall publish the Excel Table to SharePoint List and done. 


Step 3: Visit your SharePoint List on the SharePoint and set the data fields as needed.


Comments

Post a Comment

Popular posts from this blog

How to retrieve texts from Html SharePoint List source in Power BI

By
Image
Recently I have been put in to a scenario where I need data from SharePoint list to be published into Power BI Report. The columns used in SharePoint list where of type Multi Line Text and contained HTML tags. Up here I am going to show how to consume HTML in Power BI reports, Power BI itself offers way to clean your HTML text allowing you to use only text from it. Step 1: Connect to SharePoint List  using PowerBI Step 2: Select Transform Data Step 3: Find column FieldValueAsHtml, click to expand and select the column with Html data and click ok. This will extract the column data and create a new column with only texts extracted from Html. This new column will be called FieldValueAsHtml.YourColName. Enjoy.
Read more

Simplifying Data Migration: Debezium for Moving Data from Oracle to SQL Server

By
 Introduction In today's data-driven world, organizations rely on databases to store, manage, and analyze vast amounts of information. Over time, businesses may need to change database systems for various reasons, such as cost-efficiency, performance improvements, or compatibility with new applications. One common migration scenario is moving data from Oracle, a popular relational database, to SQL Server, another widely used database system. While data migration can be a complex task, tools like Debezium have emerged to simplify and streamline the process. What is Debezium? Debezium is an open-source, distributed platform for change data capture (CDC). It captures changes to database data in real-time, making it an excellent choice for scenarios like Oracle to SQL Server data migration. Debezium works by monitoring the database's transaction log and recording any changes made to the data, such as inserts, updates, and deletes. This captured data is then made available in a form...
Read more

Installing MariaDB on Ubuntu using SUDO

By
This article demonstrate steps to install MariaDB/MySQL on Ubuntu using sudo. This is part of our getting started journey to learn MariaDB/MySQL. I will be covering PostgreSQL in another article. Before we get started, very first step would be to install MariaDB/MySQL Server and client. You can install any of these RDBMS on Windows but this blog will mostly be following Ubuntu OS. There are various tools to access MariaDB/MySQL Server, we are going to use mysqlclient and Heidisql. Lets get started with installation of MariaDB. Step 1: Open your Ubuntu terminal window or bash and run following cmd. This step is going to check if mariadb-server is already installed and is going to remove it. You can either continue using the current setup or go to next step to do a fresh installation sudo apt-get remove mariadb-server Step 2: run sudo apt-get install software-properties-common Step 3: Check for Ubuntu updates sudo apt-get updates Step 4: Install Ubuntu updates sudo ...
Read more