While doing the tutorial, I tried to copy and paste the link of an existing SharePoint list into the window instead of the link to the SharePoint site, to see if this would result in the data from the CSV file being imported into that existing Sharepoint list. When you enter your SharePoint site, your exported file can now be found as a SharePoint list Error message when importing into an existing SharePoint listĪs mentioned previously, this method is specifically for importing an Excel or CSV file into a new SharePoint file.
Once this small window appears, it means that your file was successfully imported into your chosen SharePoint site as a new SharePoint list. If you are happy with this, click on ‘Finish’ at the bottom of the window. The next window explains how the column and the data will be displayed once your Excel/ CSV file is imported as a SharePoint list. I have named my file ‘exportdemo’ as an example, you may name your file whatever you likeĪt the bottom of the window, click on ‘Next’ For the purpose of this demonstration, I will be using an example ‘Blog Demo’ site. Sign into SharePoint if you haven’t already and enter the SharePoint site where you would like the Excel/ CSV file to be imported to. When the suggestions appear, Click on ‘Export data’ and then select ‘Export table to SharePoint list’ from the drop down list on the right.
While that data in your table is still highlighted, search ‘export’ in the search box in the top panel report this ad When the small window appears asking where the data for your table is, click on ‘OK’ at the bottom.
For the purpose of this demonstration, I have created an example CSV file called ‘ExcelDemo’įrom the left hand side on the top panel, click on ‘Home’įrom the panel at the top, select ‘Format as a table’ and choose any design of your choice Open up the Excel/ CSV file you want to import into a new SharePoint list and highlight all the data you want to import. Step by step process to import data from a CSV file into a new SharePoint List: Please note that this method only works if you are trying to create a new list from your Excel/ CSV file, not if you are trying to export it into an existing SharePoint list. Open up your SharePoint site, your file should appear inside.When the small window appears, click ‘OK’.Go to your SharePoint site and copy the link.Click on ‘Export data’ and then select ‘Export table to SharePoint list’.Then, click in the search box and type ‘export’.Click on ‘Format as a table’ and select any design of your choice.
Highlight the data in your spreadsheet/ CSV file.Importing data from a CSV file into a new SharePoint List: In this particular blog post, I will be demonstrating how you can import data from a CSV file into a new SharePoint list.
There are a number of ways this can be done depending on 1) if you’d like to import data from a CSV file into a new SharePoint list, 2) If you’d like to import data from a CSV file into an existing SharePoint list, and 3) if you have SharePoint Online Global Admin rights in order to install and use PowerShell PnP library. If you have data in an Excel spreadsheet or saved as a CSV, there may be times where you’d like to import your Excel file into a SharePoint list in order to keep all the elements of a certain project together in the same place.