Skip to main content
Share Your Experience: Take the 2024 Developer Survey
10 votes

Exporting SharePoint Members into Excel

Below worked for me: Steps: 1) Open Excel File. 2) Go to ribbon, select DATA and select From Other Sources, and click on From OData Data Feed. 3) In ‘Data Connection Wizard’ form, provide ...
Amay Kulkarni's user avatar
6 votes

Generating excel file from SharePoint list

Use export to excel option. The list will be downloaded as an excel file. Open the file and provide your sharepoint credentials. You are good to go.
Vainktesh Kumar's user avatar
5 votes

Ping from SharePoint list

I don't think this is a good use case for SharePoint. You're talking about running a "ping" from a web page but JavaScript running in a web page cannot do this - it only speaks HTTP. So you can issue ...
Derek Gusoff's user avatar
  • 8,026
5 votes
Accepted

SharePoint 2013 list does not export all data to Excel

Can you check if there is filter applied on the view from where you are exporting the excel? Try opening allitems.aspx (hope this view is not filtered) else you can create brand new view (without any ...
Rohit's user avatar
  • 1,051
5 votes
Accepted

Is there a shorthand way to save a sharepoint list as csv

As a short answer: No. There is no such parameter to export a list or Library to Excel / CSV from URL. Behind clicking on Export List to Excel from the above ribbon, you will get a URL like http://...
Mohamed El-Qassas MVP's user avatar
4 votes

Programmatically read Excel file in SharePoint 2013 sandbox solution gives permission error

APPROACH 1 First add reference of two COM components. Microsoft Office Object Library Microsoft Excel Object Library excel = new ApplicationClass(); excel.Visible = false; string workbookPath = url;...
Karthik Jaganathan's user avatar
4 votes
Accepted

Excel file corrupted after uploading to Sharepoint with Python

Figured out the problem with my original code: needed to provide data kwarg and NOT files kwarg: import requests from requests_ntlm import HttpNtlmAuth session = requests.Session() session.auth = ...
mechanical_meat's user avatar
4 votes
Accepted

Import/Copy/Paste Data from Excel into Existing SharePoint List

The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as ...
Chiramisu's user avatar
  • 243
4 votes
Accepted

Browser freezing when pasting large data?

I tried to do the same as you (1000+ rows) and the behavior of the browser was exactly the same. After reading more carefully the documentation Software boundaries and limits for SharePoint 2013 I ...
Elitza Atanasova's user avatar
4 votes

Choice field data contains # when exported to excel

I am not 100% sure if this should be posted as an answer or a comment (but the question doesn't include a question). You can't get it without the #. The separator is actually ",#": a comma followed ...
Antoine Driard's user avatar
3 votes
Accepted

Import Spreadsheet with field name listed vertically/per row

SharePoint won't be able to create a list from a spreadsheet in that format. Nor will you be able to copy and paste it into quick edit mode. (Theoretically you would be able to copy and paste it, but ...
Christoffer's user avatar
  • 9,781
3 votes

Unable to refresh data in Excel Online connected using Power Query

Clearest answer I've found to this is here: SharePoint doesn't support refreshing Power Query data sources at the present time. Although it's true that SharePoint and SharePoint Online don't ...
Alex's user avatar
  • 235
3 votes

Not clickable cells with excel web part

Yes there is. Open your spreadsheet in Excel client application. Select the cells you want to disable from clicking. Go to the review tab, and select protect sheet. Uncheck the "Select locked cells" ...
Benny Skogberg's user avatar
  • 25.5k
3 votes

Prevent user from saving file on local hard drive

If a user has Read permissions to a file, then they will be able to download it. You can specify 'View Only' permissions, which will prevent a report (rdl) from being downloaded, but won't stop a ...
Jack's user avatar
  • 261
3 votes

Open a specific Workbook in Excel online using the URL in SharePoint online Excel Workbook

/_layouts/15/WopiFrame.aspx?sourcedoc=ID&file=filename.xlsx&action=default replace "action=default" with "activeCell=%27sheetname%27!A1" set active cell in the link, and specify sheet and ...
rrr's user avatar
  • 337
3 votes

Ping from SharePoint list

If I'm sure, you're using SharePoint Online, so your only possibility is to use a client-side option. I think that you can actually do this using Client-Side Rendering (JSLink) in your list, or just ...
Sergio's user avatar
  • 608
3 votes

open excel file from spfx onclick

You should append the query string ?web=1 to the ServerRelativeUrl. It will open the file in the browser instead of downloading the file. Modify your method as below: window.open(d....
Gautam Sheth's user avatar
  • 30.9k
3 votes
Accepted

Exporting item version check in comments

You can use this parameter$($version['Check In Comment']) in the PowerShell script to get the 'Check In Comment'. but unfortunately, it gets only the comment of the current item (last version). So to ...
Mohamed El-Qassas MVP's user avatar
3 votes

unable to refresh data in excel from sharepoint

Please go to excel > data > connections > connections to see if there is your connection (its name should be same with your file name) in this windows. If yes, please double click it and select ...
user23's user avatar
  • 107
3 votes
Accepted

How can I download an Excel 365 document that is stored on SharePoint and over 100 MB, without having to install the Excel desktop program?

You could use the OneDrive for Business app to store the file locally on your machine: Sync SharePoint files and folders or you can download the file to store it outside of SharePoint. Use the ...
Callum Crowley's user avatar
2 votes
Accepted

Error "Method Post of object IOWSPostData failed" when import Excel as new list

It happened to be an old bug (or old design) of SharePoint. The site collection with import problem have URL http://sharepoint.com/sites/ABC/. It happened that every site collections under same web ...
Mark L's user avatar
  • 4,065
2 votes
Accepted

How to import excel in SharePoint List programatically

Fist you convert List Data into DataTable by SPListItemCollection, Then do Something like this using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat....
Jayakumar Kulkarni's user avatar
2 votes

Are there list view url parameters to export to Excel?

I tried and the below URL made dynamically can help you to get excel imported. https://test.sharepoint.com/_vti_bin/owssvr.dll?CS=65001&Using=_layouts/15/query.iqy&List={F3A732BB-355B-42BE-...
Farshid Mahdavipour's user avatar
2 votes

Are there list view url parameters to export to Excel?

List views can be export to excel by passing List GUID & List View GUID with the URL as mentioned below : https://<siteurl>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={&...
Vishnu PS's user avatar
  • 467
2 votes

Open new item direct with excel

Go to your Library Settings -> Advanced Settings For 'Opening Documents in the Browser' choose 'Open in the client application'
Gintas K's user avatar
  • 1,237
2 votes
Accepted

SharePoint Date Formula

You can try below formula =YEAR([DateField]) + MONTH([DateField]) OR =TEXT([DateField], "YYYYMM")
Amal Hashim's user avatar
  • 28.3k
2 votes
Accepted

Sharepoint 2010 how to export item URL to Excel?

You can't do it directly , but you can do the following workaround At your list View , Make sure that it contains the ID of the item. After you export your list from the ribbon . Open excel sheet > ...
Mohamed El-Qassas MVP's user avatar
2 votes

Files don't open in browser

I found my Happiness on this link; https://technet.microsoft.com/en-us/library/e4d51dc4-6460-437d-aa8e-0ae4d3aa8cc5#singleHTTPS I did not installed OFFICE WEB APP SERVER.
Adam Miklaszewski's user avatar
2 votes

Granting permission to a single document when access is denied to Sharepoint

As far as I know, access to SharePoint will trump access to a document or file that is IN SharePoint. Of course, this is for access to SharePoint at the root level. If you have access to SharePoint ...
hoffie4's user avatar
  • 2,346

Only top scored, non community-wiki answers of a minimum length are eligible