Questions tagged [export-to-excel]
The export-to-excel tag has no usage guidance.
36
questions
1
vote
0
answers
69
views
Export Sharepoint 2016 list to excel that contain managed metadata
Good day, my client wants to export a custom list in SharePoint 2016 that contains managed metadata.
When I export the list, it shows the 'id;# with name' value e.g. '35;#Legal Department' in the ...
- 89
0
votes
0
answers
302
views
Power flow to create a CSV table from two sharepoint lists based on a reference
I have two lists in sharepoint, need export but problem is with data from second list. Export needs datas from both lists.
LIST A contains Name, Surname, Age
LIST B contains Name, Hobbies, Sports, ...
- 139
0
votes
1
answer
971
views
Is it possible to Import Data to a Multiple Choices Field Column in a SharePoint List?
I am currently in the process of migrating data from a previous SharePoint list to a new SharePoint list outside our organization's network. One of the fields in the original list is multiple choice ...
- 3
0
votes
1
answer
108
views
SharePoint Calculated Field Formula List Generation
I have a SharePoint list content type made in legacy SharePoint. There are 143 calculated fields in this list. Is there a way to extract a complete list of all the calculations in all the columns at ...
0
votes
1
answer
563
views
Sharepoint 2016 .iqy file keep asking for login
One of my client is using sharepoint 2016 and he wants to export the sharepoint 2016 list to excel, so From couple of days, i'm facing issue of exporting sharepoint 2016 list to excel using there ...
0
votes
1
answer
842
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 ...
- 21
1
vote
2
answers
126
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 ...
- 21
2
votes
2
answers
3k
views
Show Attachment File Names in a List View
I'm trying to replace the SharePoint 2013 attachment paperclip icons with the actual NAME of the attached document.
When I export a SharePoint (2013) list to an Excel spreadsheet, instead of listing ...
- 21
1
vote
1
answer
607
views
Inserting data into Excel from PowerApps
I have a PowerApps app that is fronting a SharePoint data source. My customer has an Excel spreadsheet they use for reporting purposes and would like to be able to export data from the PowerApps ...
- 107
1
vote
1
answer
747
views
Exporting a SharePoint list to Excel is exporting the entire list, not just the view I want
Exporting from SharePoint Online list should only include the items in the view. However, when I export, I am getting all the items in the list. I tried various browsers. Anyone know a workaround? ...
- 11
0
votes
2
answers
809
views
Export SharePoint calendar to excel in same calendar format
I want to export the calendar list into excel, I am aware of list ribbon - export to excel.
Its exporting all events in list format,
I want the exported excel to be in month view with all the dates ...
- 13
1
vote
1
answer
611
views
Excel export with Image thumbnails
I have a solution on SharePoint Online, in which I using multiple list to read the data from, and I have built a custom button on web page to export/download an excel having transactional data (from 2-...
- 1,204
0
votes
1
answer
314
views
.cvs export of sharepoint list removes leading zero's
My site includes functionality that exports a list as a .csv file. I can't change the fact that the list is being exported as a .csv.
The problem is that when the list is exported, the leading zeros ...
- 71
0
votes
1
answer
248
views
Save the output of "Export to Excel" as xlsx and make it portable
This is my scenario:
I have an SP list that is shared with several members, and I would like to download the data, customize the schema (i.e. add more columns to it), and then share it with the rest ...
- 425
0
votes
1
answer
4k
views
How can I export a sharepoint online list with version history enabled to excel?
I have enabled version history on my custom list.
Now when i do an export to excel all the multiple text fields don't show any data at all.
How can i get it to export all the fields with data and the ...
- 4,272
0
votes
1
answer
225
views
Why Rich Text fields which have "Append changes to existing Test" will show empty cell when i export our custom list to excel
We have an online classic team site and inside this site we have created a custom list, which contain 2 fields of type rich text + have "Append changes to existing text" set to yes ,as ...
0
votes
1
answer
40
views
SharePoint List exporting differently to excel display
We have recently upgraded to SP 2016.
Our excel reports extract data from linked SharePoint lists.
Following the upgrade, the lists display fine in SharePoint, however are disjointed in excel with ...
- 1
0
votes
1
answer
53
views
Exporting Calendar to Excel throws an error
I am trying to export a calendar with a list view in chrome,however I am getting the following error:
WEB
1
https://[site]/_vti_bin/owssvr.dll?XMLDATA=1&List={3552683E-AA60-440B-BE31-015A31B047D2}...
- 1,337
0
votes
1
answer
1k
views
SP Online Export to Excel displays error
In On-Prem sites, Export to Excel is working fine.
But in SP Online sites, Export to Excel displays the below error:
"the server you are trying to access is using an authentication protocol not ...
- 1,522
0
votes
2
answers
1k
views
How can I use export to excel and get the full file path?
In the past when I used export to excel the full path was shown as
"../../../../../../../../Departments/EIDepartment/Shared Documents/Area Class Reference/FIGURE 2.pdf", which I could use as a ...
0
votes
2
answers
200
views
Complex list Export to excel
I have a complex list with more than 100 columns and around 55 lookups.
I need to export the list containing all the fields to an Excel File.
How can i do this considering this error: This view cannot ...
- 41
1
vote
2
answers
1k
views
Export to Excel erroring when connected to VPN
In SPO, when I use the "Export to excel" functionality when connected to VPN, I receive the below error.
"The server you are trying to access is using an authentication protocol not supported by this ...
- 1,522
0
votes
3
answers
955
views
How to click export to excel in SharePoint Online
I have 3 lists in SharePoint. But in 2 lists different button "Export to Excel" can be click. but in 1 list, it cannot be click.
- 1
3
votes
1
answer
882
views
Is there a shorthand way to save a sharepoint list as csv
With Google sheets one can save a (single) tab from the sheet as csv by adding ?format.csv to the document url. Is there a similar way for sharepoint lists?
- 133
0
votes
1
answer
251
views
Sharepoint 2013 - How to export Most Popular Items to excel?
I am not aware of an OOTB feature to export the Most Popular Items search query to excel.
How may this be achieved?
- 589
1
vote
0
answers
41
views
Problems with exporting a list to Excel
I have modified my view and selected just the columns that i want to show. But when I export the content to excel I can see more columns. (In my nomal view I am not seeing them, just when I export it ...
- 11
0
votes
3
answers
1k
views
SharePoint Custom List with Multiple choices columns export to Excel
Is it possible to export multiple choices columns in a SharePoint custom list to an excel spreadsheet and that the list keeps its values in a multiple choice format?
0
votes
1
answer
350
views
Export SharePoint List to Excel
I have been getting an error when I try to export a Contacts list from our SharePoint online environment to excel. It downloads a query file but says "Cannot connect to the server at this time. ...
- 152
0
votes
1
answer
1k
views
How to export SharePoint list to excel and save it in a sharepoint list
I want to export sharepoint list in a excel and save it in a sharepoint list.I am able to save it in local.So I am looking to generate excel and save the same in sharepoint list by csom c#
- 13
-1
votes
1
answer
2k
views
Exporting sharepoint list items to excel by csom c# [duplicate]
I am getting items from a list using caml query. After that I need to export to excel by csom (c#). I dont want to use pnp .
- 13
1
vote
1
answer
156
views
Import Spreadsheet to Datasheet SharePoint with calculating columns
Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it'...
- 307
-1
votes
1
answer
431
views
Limit of items selected in SharePoint list
I have found and deployed a nice .wsp package that allow you to select items in a sharepoint list or filter a list and it will only export the selected/filtered items. The catch is, you have to ...
- 89
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 ...
- 31
0
votes
2
answers
4k
views
Error while trying to "Export to Excel" a custom list in SharePoint Online
I am using SharePoint Online and Excel 2016. When I try to "Export to Excel" a custom list, I get the following errors:
My version of Excel 2016 comes from Microsoft Office Professional Plus 2016.
I ...
- 1
0
votes
1
answer
915
views
PNP script for all users with Full Control within a Site collection's sub-sites
Via PNP/CMOS, we are looking to export all users that are of Full Control permission level in an on-premise site collection. This site collection could have 300+ sub-sites.
We are trying to figure ...
0
votes
0
answers
163
views
Export SharePoint 2013 list big data to Excel
I have a SharePoint list with 13879 items, so when I am trying to export the list to Excel, data doesn't export.
It is blank sheet and looks like this. (where column1, column2... are SharePoint list ...
- 113