Data import from Excel spreadsheet to SharePoint list

We would like to show you how to import your data within Excel spreadsheet into a SharePoint list.

It’s quite simple. Follow the instructions:

1. Login to your SharePoint site. Click Settings, click Site Content

Data_import_from_Excel_spreadsheet_to_SharePoint_list_1

2. Click “Add an app”

Data_import_from_Excel_spreadsheet_to_SharePoint_list_2

3. Type “excel” in the Find an app textbox. Click Import Spreadseet

Data_import_from_Excel_spreadsheet_to_SharePoint_list_3

4. Type the name for the new list, description. Click Browse button and select your Excel spreadsheet file. Click Import button

Data_import_from_Excel_spreadsheet_to_SharePoint_list_4

5. Select the Range type and select the range for the data. Click Import button

Data_import_from_Excel_spreadsheet_to_SharePoint_list_5

6. Now you can see your new list with the data that was imported from Excel spreadsheet

Data_import_from_Excel_spreadsheet_to_SharePoint_list_6

 

How to reset a user password in Sharepoint 2013

We would like to show you how to reset a user password in Sharepoint 2013

You need to perform the following steps:

1. To open Active Directory Users and Computers, click Start, click Control Panel, double-click Administrative Tools , and then double-click Active Directory Users and Computers.

2. In the console tree, click Users or, click the folder that contains the user account.

AD_Pass_Reset_1
3. In the details pane, right-click the user whose password you want to reset, and then click Reset Password.

AD_Reset_Pass_2
4. Type and confirm the password.

AD_Pass_Reset_3

 

AD_Pass_Reset_4

 

To start using it check our Sharepoint Enterprise Plan (Public Sites Included):

https://plexhosted.com/services/hosted-sharepoint-2013/hosted-sharepoint-enterprise-2013.html

How to publish Access 2013 database on a SharePoint 2013 Enterprise site

We show you how to publish Access 2013 database on your SharePoint 2013 Enterprise site.

Start Access 2013. Open an existing database or create a new database. To create new database go to the New tab in the left navigation pane and then select Blank desktop database from the templates

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_1

2. Specify the name of the database and click Create

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_2

3. Edit your database tables as required

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_3

4. Select the table name and right mouse click. Select Export at the drop-down menu and then select SharePoint List

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_4

5. Specify a SharePoint site URL. Specify a name for a new list, check the box Open the list when finished and then click OK

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_5

6. Your new database list will open in browser. Click on Stop to stop editing this list and to finish publishing the database

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_6

To start using it check our Sharepoint Enterprise Plan (Public Sites Included):

https://plexhosted.com/services/hosted-sharepoint-2013/hosted-sharepoint-enterprise-2013.html