Questions tagged [export-to-excel]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 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 ...
0
votes
0answers
14 views

How to generate token for long time in PNP Online PowerShell?

I am trying to export a list with 28000 records into CSV file using this blog. I am using the PNP PowerShell approach. The issue I am facing is it breaks the session with below error: Unable to ...
0
votes
0answers
30 views

Export to Excel displays no results

I am new to SharePoint (2007 version) so please excuse any basic errors. I have created a survey in SharePoint that has a mixture of yes/no, multiple choice and free form text answers. Prior to ...
0
votes
1answer
16 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}...
0
votes
1answer
94 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 ...
0
votes
0answers
93 views

Cannot open IQY file in excel

After I export a list from Sharepoint and try to open up the iqy file I receive and error with the following:
0
votes
2answers
61 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
2answers
31 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 ...
0
votes
2answers
237 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 ...
0
votes
0answers
27 views

Can I write an export to excel query that automatically creates a raw data table and a pivot table?

Is it possible to write a query from a SharePoint .iqy that automatically gives me a tab that shows the raw data as well as a table with a pivot table? The pivot table always needs to have "Employee ...
0
votes
3answers
106 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.
2
votes
1answer
51 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?
0
votes
1answer
68 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?
1
vote
0answers
32 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 ...
0
votes
0answers
9 views

SharePoint 2013 Survey not showing answers on Excel

I've created a survey (in SharePoint 2013) where I'm trying to export the survey results in Excel. The problem is, when I export, none of the survey's answers show up. I've tried changing the view, ...
0
votes
3answers
184 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
1answer
53 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. ...
0
votes
1answer
210 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#
0
votes
0answers
3 views

Export items within lookup to excel in sharepoint list can't showed up

I tried to export data from list to excel with default button in sharepoint. I got it but I have a problem. There're many of looks up in my list table and they are not showed up in my excel. How to ...
-1
votes
1answer
600 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 .
1
vote
1answer
44 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'...
-1
votes
1answer
46 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 ...
1
vote
0answers
99 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 ...
0
votes
2answers
932 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 ...
0
votes
1answer
433 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
0answers
83 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 ...