Questions tagged [csv]

CSV is an acronym for Comma-Separated Values and is a file extension over a text file.

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

How to replace the special character in CSV file single column

I have retrieved the content editor XML web part properties and stored inside the CSV file which has multiple property columns in file. Content column has multiple special characters (?,&). I want ...
0
votes
2answers
59 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: $...
0
votes
2answers
48 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.
0
votes
0answers
15 views

MS FLOW TO PULL INFORMATION FROM CSV BASED OF INFORMATION ENTERED IN TO SEPARATE FORM SHAREPOINT ONLINE

I have a CSV of user email addresses and EIDs in a SharePoint document. I also have a list I'm building that will hopefully reference it. What I'm trying to accomplish is, When a user goes to fill ...
0
votes
1answer
22 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
vote
2answers
40 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.
0
votes
1answer
37 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 ...
1
vote
1answer
53 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 ...
0
votes
0answers
41 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 ...
0
votes
1answer
56 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.
0
votes
1answer
69 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 ...
2
votes
2answers
4k 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 ...
0
votes
1answer
270 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 ...
0
votes
1answer
13 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 ...
0
votes
2answers
141 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
0answers
103 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 ...
0
votes
1answer
195 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 ...
1
vote
2answers
807 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 ...
0
votes
1answer
393 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 ...
0
votes
1answer
637 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
1answer
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
1answer
58 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
1answer
739 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 ...
0
votes
1answer
576 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
1answer
68 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 ...
1
vote
1answer
687 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 ...
1
vote
1answer
2k 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 ...
2
votes
0answers
243 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 ...
1
vote
2answers
3k 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 ...
0
votes
1answer
502 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 ...
1
vote
1answer
2k 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 ...
1
vote
0answers
34 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 ...
1
vote
1answer
50 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 ...
2
votes
1answer
2k 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), ...
1
vote
1answer
69 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
0answers
189 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
vote
0answers
49 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 ...
1
vote
1answer
560 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
1answer
61 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....
3
votes
3answers
7k views

Add multiple users, groups and groups permission from *csv file to SharePoint 2013 using powershell

I am looking for script to add multiple users and multiple groups to SharePoint 2013. I have CSV file with cointains two columns with header "user" login and "group" name with are separated by (;) as ...
2
votes
1answer
2k views

how to export in csv format instead of .iqy

By default export to spreadsheet showing owssvr.iqy , we need to have owssvr.csv Please help.
1
vote
0answers
117 views

How to return only one user and date for Created By and Created Date column using PowerShell

I have a script that outputs to CSV all items and files from Libraries and Lists in a Site shown below: Add-PSSnapin microsoft.sharepoint.powershell $excludeLists = @("Master Page Gallery", ...
0
votes
1answer
42 views

Export to CSV on custom application results in that nothing works on the page anymore

i have a simple custom application which fetches records from a lists by a caml query and through an export button the user is able to get a csv file with the data. Generally the export works fine. ...
0
votes
4answers
3k views

Display Correct Modified By and Modified times and dates using Powershell

I have a script that outputs to CSV all items from all Lists and all files from all Libraries below: function Get-DocInventory([string]$siteUrl) { #$site = New-Object Microsoft.SharePoint.SPSite $...
1
vote
1answer
858 views

List Item Name not populating - PowerShell

I have a PowerShell script that outputs to a CSV file all items from all Lists and all files from all Document Libraries in a Site shown below: function Get-DocInventory([string]$siteUrl) { $web = ...
2
votes
1answer
10k views

How to export list to csv using PowerShell

I have a Powershell script that outputs data from all libraries in a site shown below: Add-PSSnapin Microsoft.sharepoint.powershell $url = "http://contoso.com" $site = New-Object Microsoft....
0
votes
1answer
1k views

How to output all previous versions of a file using Powershell

I have a script that displays multiple columns and outputs to CSV file below: Add-PSSnapin Microsoft.sharepoint.powershell $url = "http://contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($...
0
votes
1answer
43 views

Powershell script duplicating files and displaying incorrect URL of the file's location

I have a powershell script that display a list of files that are checked out all users in a site and exports the output as a csv file: Add-PSSnapin Microsoft.Sharepoint.Powershell $url = "contoso....
0
votes
0answers
74 views

How to email csv file to Owners group using powershell

I have a script that exports data to a csv file listed below: $url = "http://portal.contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($url) $web = $site.OpenWeb() $list = $web.Lists ...