Skip to main content
10 votes

Exporting SharePoint Members into Excel

Below worked for me: Steps: 1) Open Excel File. 2) Go to ribbon, select DATA and select From Other Sources, and click on From OData Data Feed. 3) In ‘Data Connection Wizard’ form, provide ...
Amay Kulkarni's user avatar
10 votes
Accepted

Are there any risks of doing an Export/Import for a document library between 2 farms, where these 2 farms have different farm build numbers

First, you should specify what's the type of risk that you expect when you try to export and import a library from one farm to another with different build number Will the cmdlet be worked and ...
Mohamed El-Qassas MVP's user avatar
6 votes

Unable to find the export web part option

Edit the page in the browser Inspect the DOM to find the div containing your web part Change the allowexport property to true <div ... webpartid="my-web-part-id" allowexport="false"> becomes &...
Joseph Shannon's user avatar
4 votes

Unable to find the export web part option

I found another way to export a web part. There is a hidden page in SharePoint that takes a couple of query strings for the web part Id and the page URL and generates a file with the exported web ...
Vivek Ayer's user avatar
4 votes
Accepted

Import-SPWeb can not find my .cmp folder

This issue occurs in case you are using -NoFileCompression parameter in the Export-SPWeb cmdlet. In this case, the cmdlet will export the files with no compression in a Folder instead of one file ...
Mohamed El-Qassas MVP's user avatar
4 votes

Migrating our SharePoint 2013 on-premises farm to an Office 365

Suggestion for your second question, Better to use web-hooks instead of remote event receivers. Web hooks support only asynchronous -ed events (like updated, deleted, etc). Assess the requirements ...
mohd tahir's user avatar
  • 2,406
4 votes

Choice field data contains # when exported to excel

I am not 100% sure if this should be posted as an answer or a comment (but the question doesn't include a question). You can't get it without the #. The separator is actually ",#": a comma followed ...
Antoine Driard's user avatar
3 votes
Accepted

Missing some documents after import-spweb for a document library

looks like you have 29 documents that are checked out. Make sure that all documents are checked in first. when performing a export-spweb it does it on the checked in version. if it doesn't have one ...
Ali Jafer's user avatar
  • 17.8k
3 votes
Accepted

Export libraries and documents into filesystem preserving fields

You can go for custom development, as it is free but required efforts from you. With Open with explorer, you will not retain all the metadata and it is also slow, but you can keep the structure. ...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes

Export all Events in .ical format from SharePoint Calendar list

For what I have experienced, this isn't directly possible. There's a suggested programmatical approach to this problem which should export all of the calendar's events in an ICS format: StringBuilder ...
moe's user avatar
  • 5,267
3 votes

Migrating our SharePoint 2013 on-premises farm to an Office 365

MIGRATION To Migrate the whole site collection with sub-site and contents you need to use the third party tool like share-gate , metalogix etc. However it depends on the size of site collection if ...
Ramesh's user avatar
  • 574
3 votes
Accepted

Exporting item version check in comments

You can use this parameter$($version['Check In Comment']) in the PowerShell script to get the 'Check In Comment'. but unfortunately, it gets only the comment of the current item (last version). So to ...
Mohamed El-Qassas MVP's user avatar
2 votes

Are there list view url parameters to export to Excel?

I tried and the below URL made dynamically can help you to get excel imported. https://test.sharepoint.com/_vti_bin/owssvr.dll?CS=65001&Using=_layouts/15/query.iqy&List={F3A732BB-355B-42BE-...
Farshid Mahdavipour's user avatar
2 votes

Are there list view url parameters to export to Excel?

List views can be export to excel by passing List GUID & List View GUID with the URL as mentioned below : https://<siteurl>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={&...
Vishnu PS's user avatar
  • 467
2 votes
Accepted

SP07 - Export to word, problem with Response-encoding

HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default; This solve my problem :)
Goshky's user avatar
  • 2,058
2 votes
Accepted

Sharepoint 2010 how to export item URL to Excel?

You can't do it directly , but you can do the following workaround At your list View , Make sure that it contains the ID of the item. After you export your list from the ribbon . Open excel sheet > ...
Mohamed El-Qassas MVP's user avatar
2 votes
Accepted

Exporting data out of SharePoint into Excel

You can try creating a filtered view in your SharePoint list that narrows down the result set for you, then connect to this view in Excel to pull the data for whatever you need.
Eric Alexander's user avatar
2 votes
Accepted

SP2013 - export custom list attachments with power shell

Refer How to use PowerShell to download attachments Also this Question has some details for the same.
John Zachariah's user avatar
2 votes
Accepted

How to export blog posts from sharepoint 2010 and import them in new blog in sharepoint 2016

I did the things in this way: Exporting the posts using Central Administration https://technet.microsoft.com/en-us/library/ee428301.aspx After that I used SharePoint Management shell in order to ...
Toni's user avatar
  • 77
2 votes
Accepted

How to migrate project from one project server 2010 to another?

There is no way in Project Server that you can perform import/export operation for few sets of Project Plan. As mentioned by Tarun you can migrate entire Project Database along with all Project Plan. ...
Apps4Rent Guru's user avatar
2 votes

Error when export to Excel in SharePoint

The problem is that your computer is running out of memory and cannot complete the job. Reboot your computer, close any apps and programs that are not required, so you have the most memory available. ...
teylyn's user avatar
  • 8,959
2 votes

Error when export to Excel in SharePoint

I suspect that you have excel 86x. Your excel can only call so much memory (2gb if you have a 86x windows or 4gb if its 64x windows version off the top of my head) so while your computer may be fine, ...
SamKayPharma's user avatar
2 votes

Error when export to Excel in SharePoint

Microsoft offers several explanations as well as troubleshooting steps for this error here: https://support.microsoft.com/en-us/help/2779852/how-to-troubleshoot-available-resources-errors-in-excel I ...
Robert Woods's user avatar
2 votes

Office 365 SharePoint Online list export

One possibility could be since you are on the SharePoint online is to, automatically get data from the list to CSV file through MS Flow. Here are the steps: Schedule a task (for example every day or ...
SharePointer's user avatar
  • 3,046
2 votes

How to populate sharepoint list with excel data?

Go to your list Create a view with same columns than your Excel In this view, go to Ribbon / List / Quick Edit Copy your data from Excel Paste your data in SharePoint using Quick Edit
Juan Pablo Pussacq Laborde's user avatar
2 votes
Accepted

Requirements and effect of Export/Import lists and documents from one farm to another

Import and export operation required both farm should be same SharePoint version i.e. 2010 to 2010. But you can go lower build to higher build number within same SharePoint version. Both site ...
Waqas Sarwar MVP's user avatar
  • 56.9k
2 votes

How to delete Lookup columns

Go to: List Settings: Go to: Columns>search for any lookup columns (See under 'Type' column)>select & delete
Tally's user avatar
  • 2,253
2 votes
Accepted

Append to existing text - Exporting to Excel

Exporting to excel will only send the current version of all the items to excel. Having appending text in a multiple line of text field only works when version history is on. Therefore if someone ...
Chris G's user avatar
  • 1,282
2 votes

How to export an Excel sheet automatically from a SharePoint list or library?

What you have to do is, you have to build a Timer Job to do this job automatically on behalf of you. The timer job can be scheduled to run daily or weekly or any scheduled time. To know about timer ...
Aakash Maurya's user avatar
2 votes
Accepted

How do I move SharePoint Lists including metadata

In the import command, I had to append -IncludeUserSecurity: Import-SPWeb "NewSiteURL" -Path "PathToExportFile" -IncludeUserSecurity
dimitrisd's user avatar
  • 289

Only top scored, non community-wiki answers of a minimum length are eligible