Skip to main content

Questions tagged [export]

Export of data is the automated or semi-automated output of data sets between different software applications. It involves "translating" from the format used in one application into that used by the other.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 views

SharePoint Export to Excel removes spaces

I have a Glossary I created as a List in SharePoint in Microsoft 365. There are nearly 1000 entries, and I used SharePoint's "classic experience" to add links between terms. It looks and ...
Lissa B's user avatar
0 votes
0 answers
13 views

Canvas App Export Error

I am fairly new to canvas apps and I am facing an error there. I want to migrate Canvas apps so trying to export it. But I am running into an error : Has any one come across this? Kindly help me if ...
Prajakta Agte's user avatar
0 votes
0 answers
278 views

Export SharePoint List to csv with Attachments included

I have a list in SharePoint Online with an attachments column containing related PDF files. Right now when I export the list data to Excel or as a CSV (in order to transfer them to an Azure ...
HER_CDM's user avatar
0 votes
1 answer
174 views

What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?

I've run across many descriptions on how to effectively/efficiently set up a click event that pulls data from a single SharePoint list and then exports the data to Excel in a Vue.js environment. So ...
readytodrum's user avatar
2 votes
1 answer
922 views

SharePoint List export option:"export to csv" gives me "Sorry, you don't have access. " but not "export to excel"

"Export to csv" in sharepoint list gives our customer the message of "Sorry, you don't have access." while "Export to Excel" works for the same user. The main concern is ...
MirSa's user avatar
  • 21
0 votes
1 answer
876 views

SharePoint Online List View Filter makes excel export cap at 30,000 rows

I'm using SharePoint online and my users and myself (SharePoint admin) are unable to export a list with more than 30,000 items if the list has a list view filter on it. My users (standard O365 ...
AutomeShane's user avatar
1 vote
2 answers
131 views

How to style Excel sheet in SharePoint online

I am trying to export the list using export to excel option. I want to style the excel sheet (Bold the header, Apply background color) while download itself. How to apply styling to the file ...
Preethi's user avatar
  • 21
2 votes
1 answer
1k views

How to export powerapp solution (.Zip file) using powershell or pnp script?

I need to download the PowerApps(canvas app) solution package(.Zip file) by using PowerApps PowerShell script or pnp script. Anyone suggest me if it is possible.
PGP's user avatar
  • 1,125
0 votes
1 answer
548 views

Export Security group using PowerShell

I have SharePoint 2013 sites. I want to export all the security group in Csv file. I want the security group name and the principle type of the group. Also, it is located in site level or subsite ...
Liz's user avatar
  • 77
0 votes
2 answers
354 views

SharePoint 2010 Export Search Results of Document Library

We get the correct results from our Search in SP2010 but want to export just those files. How do we do this in a non manual way? Powershell?
burckhartkenton9's user avatar
1 vote
1 answer
142 views

Can ExportWeb (from sites.asmx) be performed in SharePoint Online?

I'm a global administrator, and I'm trying to run the ExportWeb method from https://mytenant-admin.sharepoint.com/_vti_bin/sites.asmx in SharePoint Online. When I run the following script, I get the ...
spDevAdmin's user avatar
0 votes
1 answer
216 views

The version of the package is different from the current version this program supports

Goog day, I have the problem with site import between two site collections. SharePoint 2016. The site collections are from same SP Farm. I exported the site "http://Coll1.xxx.com/career" using the ...
Anonymous's user avatar
2 votes
2 answers
6k views

Can we move/copy a customized list forms (using power app) from one tenant to another

I have a communication SharePoint online site collection inside tenantA, the site collection has 3 power-apps which were used to customize its list forms. now i used those 2 commands to re-create the ...
John John's user avatar
1 vote
1 answer
2k views

export sharepoint site collection and subsites structure without content

I would like to export SharePoint site collection and its subsites, but the structure only and NOT the content. Then I would like to import it to another SP Server. Export-SPWeb exports it with the ...
Burre Ifort's user avatar
  • 1,339
0 votes
1 answer
142 views

I can't see my image attachments (even url) when i export a list from sharepoint to excel

I have been trying to export a sharepoint list. The list has a column with image attachment, ( the images were loaded from powerapps linked to that particular sharepoint list). The issue is that when ...
Awaka's user avatar
  • 1
1 vote
1 answer
871 views

Get a specific file with PnP Powershell

I need to get a specific file in the SitePages of a SharePoint Online site collection. I know how to get all pages with PnP (see code below), but I need only one specific. Export & Import of all ...
Patrick's user avatar
  • 3,193
1 vote
1 answer
382 views

Export SharePoint Blog Posts to SharePoint Online Pages OR Word/PDF

SharePoint 2016 offered the blog site template to share knowledge and other stuff. When migrating to SharePoint Online this content can be a problem - how to export the content and transfer it to ...
PhilFancy's user avatar
  • 1,107
0 votes
2 answers
81 views

Export data from Sharepoint to excel

I have a little trouble with export data from SharePoint 2010 and Excel, i need get data from a SharePoint list, to do a sum of certain fields that are in the list. I prove the Power Query option for ...
Hernan's user avatar
  • 45
0 votes
1 answer
95 views

Deleted? Items show up in Export

I export a list from my sharepoint and items in the excel show up that are not in the list, where are these coming from?
user86831's user avatar
0 votes
1 answer
265 views

Items showing up in export that aren't in the list

When I export my list from SharePoint, there are extra items showing up in the excel sheet that are not in the list. Why is this?
Patrick Schindel's user avatar
1 vote
1 answer
155 views

Is there any way of exporting each entry in SharePoint list to PDF/word?

Is there any way of exporting each entry in SharePoint list to PDF/word. A scenario for example is "A SharePoint list contains the list of Participants for an event, I would like to export the each ...
Deepak Nagaraj's user avatar
0 votes
0 answers
327 views

Is it possible to export a Sharepoint site to a format that another Wiki can use?

I am trying to export from Sharepoint to Confluence. When I use the Get-PnPProvisioningTemplate command I get XML that seems very SharePoint specific. The same can be said for the HTML source of any ...
Claire Gribbin's user avatar
0 votes
1 answer
33 views

Is there a way to export ALL files attached to a SharePoint 2016 list at once?

I want to export all the files that are attached to all list items in SharePoint 2016. Is there a way to do this all at once, or does it have to be done one-by-one?
lmharmon's user avatar
  • 111
2 votes
1 answer
5k views

How to export SharePoint Online list and import into a new tennant

Is there any way to export SharePoint Online lists and import into an another site? There was an option for that in on-prem installations but I did not find any in SherPoint Online. (I need ...
Gable's user avatar
  • 87
1 vote
0 answers
307 views

Filtered, large list exporting

I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
khops's user avatar
  • 31
0 votes
1 answer
2k views

Export List of File Names and URLs

Using either Powershell or other method, I need to export a list of titles of files, their filenames with extensions, their locations, and their URLs into a text or Excel file. This is what I have ...
lemonbars's user avatar
0 votes
2 answers
359 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
masterofz's user avatar
1 vote
1 answer
678 views

How to export content of blog posts for future migration?

I would like to export the content of all blogs (excluding personal blogs) in SharePoint 2013 on prems. The purpose of that is to migrate later in a different platform. Is there any out of the box ...
dimitrisd's user avatar
  • 289
0 votes
1 answer
848 views

Permission Level Use Client Integration Features is not available

I have enabled the Client Integration Features like this: Central Admin > Manage Web applications > Select Web app > Ribbon: Authentication Providers > click Default Zone > Client Integration = "Yes" ...
Aslan's user avatar
  • 532
0 votes
1 answer
87 views

How do I move SharePoint Lists including metadata

on sharepoint 2013 on-prem, I would like to migrate a a few lists in the same site collection to a different subsite using powershell. I tried the following commands: Export-SPWeb "SiteURL" -ItemUrl "...
dimitrisd's user avatar
  • 289
1 vote
2 answers
5k views

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

We have a SharePoint library on a central location. I would need to know if there is any way to export the Excel sheet automatically (without OOB solution)?
Guido Matis's user avatar
2 votes
1 answer
148 views

How to move a document library with item level permissions from one site collection to other site collection?

I have a document library with item level permissions. how to export the complete document library with item level permissions from one site collection to another site collection?
Achiever SP's user avatar
  • 1,915
1 vote
1 answer
3k views

Append to existing text - Exporting to Excel

I have been looking online and can't really seem to find any clear information relating to this so thought I would pick all of your brains. I have a custom list with a multiple lines of text column ...
Kirito's user avatar
  • 187
0 votes
1 answer
602 views

Extracting SharePoint data on daily basis

I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as "Dataname_yyyyMMdd". As per my below script, it need to export data from the ...
murali kuruva's user avatar
1 vote
2 answers
2k views

extract data from SharePoint document library to CSV using powershell

i am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
murali kuruva's user avatar
2 votes
1 answer
1k views

Exporting item version check in comments

I have followed this answer to extract the list of versions in my document library to excel: However, while the table lists all the versions it only displays (and repeats) the most recent check-in a ...
MAJ742's user avatar
  • 143
0 votes
1 answer
232 views

Scheduled Automated Data Export SharePoint Online

We are currently migrating our SharePoint 2010 site to SharePoint O365. We have a SharePoint list in our on prem solution that takes part numbers out of our ERP systems database. The users then can ...
Tim's user avatar
  • 3
1 vote
3 answers
203 views

Export data from Excel to an existing list in SharePoint Server 2016

What is the best method in SharePoint to export data from Excel to an existing list in SharePoint Server 2016?
Zakir HC's user avatar
  • 3,650
2 votes
0 answers
249 views

Private view exported to excel-- how can other users refresh the data

My problem is we are not allowed to create a public view that shows all the data since there are a lot of confidential items in that site. In order for me to make all data available in excel, I have ...
Frances Ouano Ponce's user avatar
0 votes
1 answer
1k views

How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?

I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list. ...
Mark Johnston's user avatar
2 votes
1 answer
278 views

View and/or Export all versions of a SharePoint List

I'm using SharePoint 2016 and need to analyze all the versions of a list. How do I export all the versions into an excel file or access the versions in another way to do some analysis (using PowerBI)?...
Tara's user avatar
  • 21
4 votes
3 answers
3k views

Move specific folder in a document library

UPDATE 1: I have the following script, but it's not working correctly: Add-PSSnapin Microsoft.SharePoint.PowerShell #input = https://sharepoint.oshirowanen.com/sites/oshdev $websiteurl = read-host "...
oshirowanen's user avatar
1 vote
0 answers
159 views

InfoPath button for Excel export

I want to add a button in InfoPath that will allow me to export the form into Excel. Is this possible? This is a requirement that client needs, and I have no idea how to do it without just saving the ...
Hardik Oza's user avatar
1 vote
0 answers
310 views

PowerShell to Export Sites and Subsides with security groups

I'm attempting to come up with a powershell script that would allow me to export a list of sites and subsides and the permission groups there in to a CSV. I'm familiar with using the cmdlts but not ...
Mile T.'s user avatar
  • 155
1 vote
2 answers
409 views

Export/import SPWeb to rootweb of new SPSite results in empty + missing groups

We exported a SubSite using Export-SPWeb with IncludeUserSecurity and versions. Subsequently we imported the export to the root of a newly created SiteCollection on the same WebApp (SharePoint 2016). ...
Swimburger's user avatar
1 vote
1 answer
2k views

Choice field data contains # when exported to excel

I have a choice field(checkbox, multiple values) in a SharePoint List. In SharePoint values are displayed as Choice1, Choice2. When exported to Excel the format used in Excel is Choice1,#Choice2 I ...
Joy D'souza's user avatar
0 votes
1 answer
49 views

How to migrate 1000 list items from List1 in Site1 to List2 in Site2 Using Powershell

I'm using Microsoft.SharePoint.Deployment.SPExportSettings/SPImportSettings class to migrate 1 listitem successfully. But I need to migrate only 1000 listitems. Thanks in Advance:)
raju's user avatar
  • 153
1 vote
1 answer
5k views

Export Sharepoint List to MS SQL Database

We would like to export our SharePoint Content to MS SQL Database. Do you please know about any tool that allow so? The purpose of this is to use MS SQL DB in our reporting tool which is easier and ...
Jim87's user avatar
  • 53
0 votes
3 answers
5k views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
Catalin's user avatar
  • 27
6 votes
2 answers
613 views

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

I have worked on many SharePoint 2013 & SharePoint 2016 on-premises farms. and currently one of our customer who uses SP 2013 on-premises, want to migrate SharePoint to Office 365 (SP online). now ...
John John's user avatar

1
2 3 4 5
8