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
0 answers
41 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 ...
user avatar
  • 1
0 votes
0 answers
15 views

When myself and a colleague are both opening a CSV file, my colleague sees it as empty

When myself and a colleague are both opening a CSV file, my colleague sees it as empty. Does this have to have to do with regions being incompatible on SharePoint? We cannot share CSV files between ...
user avatar
  • 1
0 votes
1 answer
218 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?
user avatar
  • 1
0 votes
2 answers
503 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 ...
user avatar
  • 3,630
0 votes
1 answer
57 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 ...
user avatar
  • 572
0 votes
1 answer
181 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 ...
user avatar
  • 85
0 votes
2 answers
142 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: $...
user avatar
  • 77
0 votes
2 answers
980 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.
user avatar
  • 77
0 votes
1 answer
33 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 ...
user avatar
  • 1,460
1 vote
2 answers
72 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.
user avatar
  • 1,460
0 votes
1 answer
77 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 ...
user avatar
  • 3
1 vote
1 answer
980 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 ...
user avatar
  • 1,460
0 votes
0 answers
67 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 ...
user avatar
0 votes
1 answer
243 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.
user avatar
0 votes
1 answer
505 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 ...
user avatar
2 votes
2 answers
12k 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 ...
user avatar
0 votes
1 answer
574 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 ...
user avatar
0 votes
1 answer
29 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 ...
user avatar
  • 1,203
0 votes
2 answers
278 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 ...
user avatar
1 vote
0 answers
181 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 ...
user avatar
0 votes
1 answer
444 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 ...
user avatar
1 vote
2 answers
1k 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 ...
user avatar
0 votes
1 answer
768 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 ...
user avatar
  • 68
0 votes
1 answer
792 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
71 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
688 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 ...
user avatar
2 votes
1 answer
92 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 ...
user avatar
1 vote
1 answer
962 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 ...
user avatar
  • 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 ...
user avatar
  • 81
2 votes
0 answers
263 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 ...
user avatar
  • 103
1 vote
2 answers
4k 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 ...
user avatar
  • 539
0 votes
1 answer
691 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
1 vote
1 answer
64 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 ...
user avatar
2 votes
1 answer
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), ...
user avatar
  • 21
1 vote
1 answer
142 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 ...
user avatar
0 votes
0 answers
250 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 ...
user avatar
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 ...
user avatar
  • 935
1 vote
1 answer
905 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 ...
user avatar
0 votes
1 answer
72 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....
user avatar
3 votes
3 answers
8k 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 ...
user avatar
2 votes
1 answer
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.
user avatar
1 vote
0 answers
130 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", ...
user avatar
  • 935
0 votes
1 answer
54 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. ...
user avatar
  • 614
0 votes
4 answers
4k 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 $...
user avatar
  • 935
1 vote
1 answer
1k 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 = ...
user avatar
  • 935
2 votes
1 answer
13k 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....
user avatar
  • 935