Skip to main content

Questions tagged [export-to-excel]

The tag has no usage guidance.

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

Sharepoint Links in Excel break upon copying to new sheet

I have an Excel sheet with about 500 links (created using the copy link button on the browser UI) to various files stored on a company-provided sharepoint account. When I try to copy the sheet ...
salmonlawyer's user avatar
1 vote
0 answers
76 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 ...
Hes JvR's user avatar
  • 89
0 votes
0 answers
331 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, ...
Novice's user avatar
  • 139
0 votes
1 answer
985 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 ...
Mike O's user avatar
  • 3
0 votes
1 answer
111 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 ...
Simone Grant's user avatar
0 votes
1 answer
610 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 ...
Lokesh Thakur's user avatar
0 votes
1 answer
869 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
129 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
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 ...
SLM's user avatar
  • 21
1 vote
1 answer
656 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 ...
Scott Davis's user avatar
1 vote
1 answer
842 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? ...
Curtica's user avatar
  • 11
0 votes
2 answers
865 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 ...
Gokulnath K's user avatar
1 vote
1 answer
630 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-...
cjs's user avatar
  • 1,214
0 votes
1 answer
325 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 ...
seaandtea's user avatar
0 votes
1 answer
260 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 ...
Mohsen Sichani's user avatar
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 ...
naijacoder's user avatar
  • 4,282
0 votes
1 answer
233 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 ...
John John's user avatar
0 votes
1 answer
41 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 ...
John's user avatar
  • 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}...
Burre Ifort's user avatar
  • 1,339
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 ...
George's user avatar
  • 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 ...
kahalstead's user avatar
0 votes
2 answers
201 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 ...
Nuno Barbosa's user avatar
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 ...
George's user avatar
  • 1,522
0 votes
3 answers
968 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.
Kfajar's user avatar
  • 1
3 votes
1 answer
925 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?
Norbert's user avatar
  • 133
0 votes
1 answer
258 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?
garvon-77's user avatar
  • 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 ...
Adriana's user avatar
  • 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?
Strykermmoak's user avatar
0 votes
1 answer
373 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. ...
Christopher's user avatar
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#
jijo's user avatar
  • 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 .
jijo's user avatar
  • 13
1 vote
1 answer
158 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'...
adams-j's user avatar
  • 317
-1 votes
1 answer
443 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 ...
Hes JvR's user avatar
  • 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 ...
khops's user avatar
  • 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 ...
Mike's user avatar
  • 1
0 votes
1 answer
934 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 ...
Sol Web Solutions's user avatar
0 votes
0 answers
164 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 ...
Vaso Miruashvili's user avatar