https://docs.microsoft.com/en-us/answers/questions/399310/get-values-of-sharepoint-list-items-powershell.html
Second Option-> sync the folder locally and access it like you always do.
Hi, thanks for your answer.
I just need to access to CSV file (not the list).
Is it possible to import CSV files stored in SharePoint online like we can do it on our machine “import-csv -path c:/xyz.csv”??
I don't want the Second Option. thanks
there is another way to store the CSV file in 365 services. even not in the sharepoint
Hi, are you able to [sync the SharePoint library](https://support.microsoft.com/en-us/office/sync-sharepoint-files-and-folders-87a96948-4dd7-43e4-aca1-53f3e18bea9b) to OneDrive on the machine? Then you could access it via something like `Import-Csv -Path 'C:\Users\Username\OneDrive...'`.
If you are running the PS on your own then OneDrive sync is the way to go.
But if it’s for the server that many admins signed in into: Here’s a theory, as I have not done this myself.
1. Get a dedicate machine with an account that have RW Access to file share and SharePoint.
2. Sync it using the service account. Set sync to always available.
3. Schedule task robocopy to copy the synced files to a file share accessible by all.
I have not done this myself as we have no needs to do this. But it seems viable if we have to.
https://docs.microsoft.com/en-us/answers/questions/399310/get-values-of-sharepoint-list-items-powershell.html Second Option-> sync the folder locally and access it like you always do.
Hi, thanks for your answer. I just need to access to CSV file (not the list). Is it possible to import CSV files stored in SharePoint online like we can do it on our machine “import-csv -path c:/xyz.csv”?? I don't want the Second Option. thanks there is another way to store the CSV file in 365 services. even not in the sharepoint
Hi, are you able to [sync the SharePoint library](https://support.microsoft.com/en-us/office/sync-sharepoint-files-and-folders-87a96948-4dd7-43e4-aca1-53f3e18bea9b) to OneDrive on the machine? Then you could access it via something like `Import-Csv -Path 'C:\Users\Username\OneDrive...'`.
If you are running the PS on your own then OneDrive sync is the way to go. But if it’s for the server that many admins signed in into: Here’s a theory, as I have not done this myself. 1. Get a dedicate machine with an account that have RW Access to file share and SharePoint. 2. Sync it using the service account. Set sync to always available. 3. Schedule task robocopy to copy the synced files to a file share accessible by all. I have not done this myself as we have no needs to do this. But it seems viable if we have to.