A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
1answer
35 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
34 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 ...
1
vote
1answer
1k 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
173 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
11 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
0answers
13 views

Web Form with unique ID to CSV

I have a big question, I just joined a project for work about sharepoint. They threw me in there with knowing that I dont have any SharePoint knowledge. I dont want to let my first project down so i'...
0
votes
2answers
72 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
68 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
116 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
633 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
313 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
515 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
1k 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
54 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
631 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
510 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
57 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
585 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
1k 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
230 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
444 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
33 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
43 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
60 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
162 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
484 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
1k 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
108 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
41 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
2k 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
820 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
9k 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
42 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
72 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 ...
2
votes
2answers
3k views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
2
votes
2answers
3k views

There is already a term with the same default label and parent term

I am using SP2013 on-premise standard edition and we tried to update the user profile with a PowerShell script. Unfortately, part of profiles cannot be updated. The exception is "There is already a ...
0
votes
3answers
266 views

How can I include site admins in a csv list of site collections?

I'm building a PowerShell script to export a list of all the site collections in a particular web application. So far I have this: Get-SpWebApplication http://www.contoso.com | Get-SPSite -Limit All ...
0
votes
1answer
268 views

How to export sharepoint management scripts' result to csv/text file

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null function EnumerateUserRolesPermissions ([string]$webURL){ $site = new-object Microsoft.SharePoint.SPSite($webURL) ...
0
votes
1answer
2k views

Simple Powershell script to import TermSet file into Group

I am looking for simple powerhell script to import termSet .csv file into TermGroup. What will be the simple script to accomplish this?
0
votes
1answer
41 views

How do I edit an Imported List?

I've imported an CSV file as a list to SharePoint. I need to update the links in the list now since the links in file mapped to another CMS. How can I edit this list now that it's in SharePoint? ...
0
votes
1answer
18 views

Foreach not recognizing close

I am trying to add items to a list from a CSV script. I have imported the code and established the variables and even test to ensure that the SP information is accurate. The following code does not ...
1
vote
1answer
31k views

Powershell - get a list of all the document libraries for a web application including content types - output to csv

I have following code and it works great. However, business unit now wants to see content types for each document library. Most document libraries come with Document and Folder content types. Now, ...
2
votes
1answer
1k views

Import-csv command to read a CSV from Document Library is giving error

I am trying to read a CSV file from a SharePoint 2013 Document Library. I am using following Powershell command for this. Import-csv "\\ServerName\sites\SiteName\MyDocumentLibrary\MyCSVFile.csv" ...