Questions tagged [csv]
CSV is an acronym for Comma-Separated Values and is a file extension over a text file.
87
questions
0
votes
1
answer
11
views
Get-Team cmdlet runs but returns no data
I attempting to create a PowerShell script which will return a complete list of Teams in an M365 Tenancy as a csv file. My script appears to run successfully but it does not return the expected data.
...
- 764
0
votes
0
answers
26
views
How can I bulk delete 1800 folders?
I have a colleague who has written a powershell script to read URLs from a CSV file and create empty folders at those locations... 1800 of them. The problem is they used their own named developer ...
- 764
0
votes
1
answer
19
views
How can I change the Created By field for 1800 folders?
I have a colleague who has written a powershell script to read URLs from a CSV file and create empty folders at those locations... 1800 of them.
The problem is they used their own named developer ...
- 764
0
votes
0
answers
108
views
Export SharePoint List to csv with Attachments included
I have a list in SharePoint Online with an attachments column containing related PDF files.
Right now when I export the list data to Excel or as a CSV (in order to transfer them to an Azure ...
- 1
0
votes
0
answers
80
views
EXPORT LIST IN SHAREPOINT TO CSV
"I have a list in SharePoint with a column named 'DateTime'. When I export the list to Excel, the 'DateTime' column is displayed correctly in the format 'dd/mm/yyyy hh:mm'. However, when I export ...
0
votes
1
answer
393
views
How to read the csv file having more than 20k records using Power automate?
I am having the CSV file in my SharePoint library. Using power automate trying to read the csv data and will update the values to the SharePoint list.
Initially with 200 rows the flow ran successfully....
- 369
0
votes
1
answer
95
views
Update lookup column via CSV. Powershell Erro
Using SharePoint 2016
I am trying to update lookup column in a document library via CSV using below PowerShell:
it only updating few and giving below error on rest of the items. The CSV and Doc ...
- 1,204
0
votes
0
answers
256
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
2k
views
Simple JSON to CSV in MS Power Automate problem
I am trying to convert the following JSON using the URL: https://api0.solar.sheffield.ac.uk/pvlive/v3/pes/0 to CSV vis MS Power Automate.
I use HTTP to get the response from above URL.
And this is ...
- 1
0
votes
1
answer
423
views
PnP Powershell - Export list of folders
I need to export a list of all the folders, sitting under all the sites associated with a HUB Site, which are modified between a specific date range into a CSV file. Could I please get some help?
- 1
0
votes
2
answers
957
views
Create list columns in SharePoint Online site through SharePoint Online Management Shell
I have a requirement to create large number of columns in a SharePoint Online custom list through SharePoint Online Management Shell.
I can't find any script to get this done. I want the PowerShell ...
- 3,650
0
votes
1
answer
114
views
SP2013 and Powershell : Export mapping between SPContentDatabase and Sites to CSV
TL;DR :
I'm trying to get all the SPSites (preferably only the URLs) contained by each SPContentDatabases mounted on each one of my WebApps into a csv.
In the edit, I explain how I could break the ...
- 592
0
votes
1
answer
315
views
How to get big CSV files data into SharePoint Online list
I have big CSV files on my local storage that I receive from an old system.
I would like to get all of this into the SharePoint Online list.
There is a way to paste everything with Quick Edit, but I ...
- 115
0
votes
2
answers
206
views
Export to CSV file
I am able to read the SharePoint web part properties and values using below code and able to export it. But after exporting, when i open the file could not find exact values.
Find the code below:
$...
- 77
0
votes
2
answers
2k
views
Read the web part properties from page using Power Shell
I have on prime SharePoint 2016 site which has couple of web part on the homepage.I want to read the web part properties from the page and Export the data to CSV file using Power Shell commands.
- 77
0
votes
1
answer
79
views
Assign multiple words as input from a CSV file without Quotes
I am running the below script to add users to SharePoint group in SPO sites:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$users= ""
$users = import-csv D:\User.csv
...
- 1,512
1
vote
2
answers
109
views
Export to CSV | DefaultLinkType value of all the sites in Tenant
Is there any SharePoint Online PowerShell script available to export the value of "DefaultLinkType" of all the sites in Tenant to a CSV?
I am not able to find one.
- 1,512
0
votes
1
answer
385
views
How to loop through this csv file with multiple values in one column
I'm trying to get the following code (originally taken from https://gallery.technet.microsoft.com/office/SharePoint-online-57f24eca) to read through a CSV file where one of the columns has two user ...
- 3
1
vote
1
answer
2k
views
Compare 2 CSV files using MS Powershell [closed]
I have 2 CSV files generated as outputs from 2 different Powershell scripts.
CSV 1 - has 2 columns Record ID and Account Name.
CSV 2 - has 2 columns Account Name and Path
I now have to compare the ...
- 1,512
0
votes
0
answers
85
views
Sharepoint 2016 list update with CSV
I am stuck with an import to a SharePoint List from CSV.
The goal is to update only certain columns according to the value of another column.
IE:
If Colum A has value X then update Colum B and get ...
- 1
0
votes
1
answer
464
views
Document Library column header copy
For a Document Library I would like to copy all the column headers including the managed metadata column headers and past them in another site's Document Library.
- 5
1
vote
1
answer
842
views
Powershell to export SharePoint version history
I have followed the following link to successfully export SharePoint list data to a csv format with Version History intact.
How can we read version history of document library and update particular ...
- 31
2
votes
2
answers
13k
views
Conversion of csv file to xlsx via Flow or SharePoint
I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how ...
- 21
0
votes
1
answer
937
views
Can you export data from PnP PowerShell into Excel?
I'm exporting data from PnP PowerShell to a csv file:
Export-Csv -NoTypeInformation -Path "C:\Users\wxmuldom\Documents\Data\TELLDocuments.csv"
There doesn't seem to be any way that I can control the ...
- 930
0
votes
1
answer
46
views
CSV upload into SharePoint list from Ubuntu
I have a csv file in Ubuntu 16.04 version. I want it to be upload into SharePoint list via power shell.
I come to know that powershell core is avalable for this Ubuntu version... But I am not able ...
- 1,204
0
votes
2
answers
340
views
Exporting a list to csv from a custom page
I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013).
This filtered list needs to ...
1
vote
0
answers
244
views
CSV bulk file migration; additional columns for meta data
Similar to this post I have a number of local files, with associated metadata in an Excel sheet, that I would like to migrate to SharePoint. With inspiration from Microsofts own article on bulk CSV ...
- 11
0
votes
1
answer
561
views
Extracting SharePoint data on daily basis
I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as "Dataname_yyyyMMdd". As per my below script, it need to export data from the ...
- 105
1
vote
2
answers
2k
views
extract data from SharePoint document library to CSV using powershell
i am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
- 105
0
votes
1
answer
1k
views
import terms with other labels (synonyms) from CSV file using powershell
I have a CSV file with ~2000 terms and other labels (synonyms). There are some scripts online that do this however they show an error when they hit a term that doesn't have any other labels. Any ideas ...
- 78
0
votes
1
answer
911
views
Sharepoint 2016 Powershell Script to export all fields to csv - including Created and Modified Fields
I am attempting to dump all data from my Sharepoint Lists to csv. I seem to have the code working at about 95% the way I want it, but I am missing the Created By, Created On, Modified By, and ...
3
votes
1
answer
2k
views
Using Powershell to update an Office 365 List with lookup column
I am wondering if anyone has seen an issue when updating an Office 365 list that contains a lookup column? I have 2 Lists in my SharePoint Online site, the first List is my lookup list that maps ...
0
votes
1
answer
75
views
SharePoint 2016 Managed Navigation Import CSV Parameter Mapping
I am interested in importing my managed navigation information from an existing site into another sharepoint site (we are creating environments for testing and production, so we want them to mirror ...
1
vote
1
answer
1k
views
SharePoint - Powershell - Export Rich Text content to CSV
Below is my code to export rich text content to a .CSV file. The content comes from a SharePoint list. I am using CAML to fetch the content and adding it to $Content.
This code exports the data but ...
- 431
0
votes
1
answer
748
views
Error Importing CSV list into Office 365 Sharepoint
I'm trying to add a list to the Office 365 SharePoint application by importing a CSV. After selecting my range of cells and starting the import, I am thrown this error:
cannot connect to the server ...
2
votes
1
answer
109
views
Update (not add) List Item with PowerShell
I have managed to work a PS Script that added circa 9k items from a CSV file. After working some parsing issues with date/time, People fields etc. It's finally worked and all 9k items now sit on the ...
- 45
1
vote
1
answer
1k
views
Export sharepoint list with lookup values using powershell
I need to export the SharePoint list in CSV format for which I am using following code. It works fine except the "Project Name" Field which gives "microsoft.sharepoint.client.fieldlookupvalue" output ...
- 13
1
vote
1
answer
3k
views
Create and update list items from csv file
I have below scripts to import a CSV file into SharePoint list. I found the scripts from this link https://www.linkedin.com/pulse/auto-sync-external-data-native-sharepoint-list-lukasz-latynski i made ...
- 81
2
votes
0
answers
281
views
How to get metadata term by tag when creating this document set
i got this code, what this does, is that it takes a .csv file, and converts into json(used papaparce.js to convert csv into json) and with that data i create and populate a new document set fields, my ...
- 103
1
vote
2
answers
5k
views
Auto-Sync CSV file into SharePoint list?
Is it possible to auto-sync a CSV File with a SharePoint Online List without needing to create an automated PowerShell script (or something similar)?
For example, I have a People.csv in my C: . Is it ...
- 539
0
votes
1
answer
870
views
Bulk upload documents and apply metadata from CSV
I have a weekly export in CSV format that contains employee information from another system.
I would like to loop through the CSV and upload X number of documents to a permanent document library on a ...
- 11
1
vote
1
answer
3k
views
Export SharePoint Libraries to CSV via jQuery
I have a requirement to allow users to export data into a csv file from a few different document libraries. The data will be a select number of columns and filtered based on if the document is new or ...
- 396
1
vote
0
answers
35
views
CSV object as parameter
Description
I have written a PowerShell script that loops for all the documents and folders in a web application. The script write specific information about those documents and folders into a ...
- 643
1
vote
1
answer
66
views
I am having a Database or csv file and i have to export that to SharePoint Document Library can it be achieved by Powershell
Is there any automated way to create SharePoint Document Library with the data's present in Database or CSV files. In that DB Table there is one column as link with Documents in it , will have to ...
- 1,151
3
votes
2
answers
3k
views
Exporting ALL fields and contents in a List to .CSV in Powershell
So I've been trying for the past 4 days now to write a full automated Powershell script that will connect to SharePoint Online, automatically login with credentials (with password located in a file), ...
- 31
1
vote
1
answer
174
views
Generateing a public csv file on sharepoint (will be downloaded by a linux server)
Last year we made a solution for a customers website (on a linuxserver). They also have a sharepointserver, where they update some numbers daily in an excel sheet, and use a macro to generate a public ...
0
votes
0
answers
297
views
SharePoint Online: Can't open a CSV File
SharePoint Online with Office 2013
A user was working on a spreadsheet, which was accidently saved as a CSV. We can't see it in SharePoint either in the browser or via Explorer view but it shows ...
- 1,020
1
vote
0
answers
51
views
How to Make Lotus Notes Items Display In InfoPath
I'm taking on a task from someone else and I'm trying to understand how this was done.
The old contractor took data from Lotus Notes ranging from MT No 803-809 (there are thousands of items and I'm ...
- 935
1
vote
1
answer
1k
views
Automated process for using .csv to create a chart/graph then embed to SharePoint site
Disclaimer: First, I am a student worker that has limited experience with coding. I am not sure how much of this process can be solved this way. Second, I recently started using SharePoint so I'm ...
0
votes
1
answer
75
views
Export to CSV and format in a table
I am using this code but I would like to view in a table and export as a CSV but all my attempts have failed. Where does the code go?
$siteUrl = "URL"
$site = Get-SPSite $siteUrl
$site.RootWeb....
- 875