Questions tagged [export-to-excel]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
43 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 ...
0
votes
0answers
9 views

Export data from Multiline text field with append option enabled

I have a Sharepoint 2013 List, with a Multiline Text Field (enhanced rich text) with Append option enabled - let´s call it field A. However i can find no way to export the data from A to an excel file,...
1
vote
1answer
40 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 ...
1
vote
1answer
35 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? ...
0
votes
2answers
55 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 ...
1
vote
1answer
83 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-...
0
votes
1answer
41 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 ...
0
votes
1answer
45 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 ...
0
votes
1answer
477 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 ...
0
votes
1answer
70 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
0answers
13 views

Interview Question (Need suggestions)

The scenario is that there is a Sharepoint 2013 List that has 200-250 items on the list. every Saturday, these items should be sent to a specific user/group in email as an attachment. how we can do it?...
0
votes
1answer
25 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
1answer
22 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
467 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
2answers
604 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
88 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 ...
1
vote
2answers
774 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
3answers
426 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
128 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
157 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
35 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
3answers
585 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
97 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
780 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#
-1
votes
1answer
1k 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
77 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
135 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
227 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
2k 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
600 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
105 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 ...