Fix Excel SharePoint Folder Connection Error Caused by Invalid CRLF Characters
Question details
The user needs to connect Excel Power Query directly to a SharePoint folder without an invalid CRLF character error.

- Product
- Microsoft Excel Power Query SharePoint Folder connector
- Device & OS
- not provided
- Scenario
- The workbook can retrieve a SharePoint file through OneDrive, but the user wants to connect directly through Data > Get Data > From SharePoint Folder.
- Observed behavior
- The direct connection reports that the value contains invalid CRLF characters, even though the user is a SharePoint member rather than a guest.
Find the SharePoint site address and confirm which Microsoft 365 account you use to access it. Use the site URL, not a link to a document library or an individual file.
Reconnect Excel using a clean SharePoint site URL
Use this method to correct a malformed URL or replace saved credentials that may be interfering with the connection.
Copy only the SharePoint site URL, such as https://tenant.sharepoint.com/sites/SiteName. Do not include a document library path or file name.
Paste the address into a plain-text editor or retype it, then remove any line breaks, trailing spaces, or other unintended characters. CRLF characters are carriage-return and line-feed characters.
In Excel, open File > Account and verify that you are signed in with the Microsoft 365 account used to access the SharePoint site.
Open Data > Get Data > Data Source Settings. Select the relevant SharePoint site under Global permissions and choose Clear Permissions.
Choose Data > Get Data > From Online Services > From SharePoint Folder, enter the clean site URL, and sign in with your organizational account when prompted.

Test the SharePoint connection in a new workbook and update Office
Use this check if the clean site URL and renewed credentials do not resolve the error.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with existing spreadsheets. It can help you move between office suites, but it does not fix Microsoft Excel’s SharePoint Folder connector.

Frequently Asked Questions
What URL should I enter for the SharePoint Folder connector?
Enter the SharePoint site address, such as https://tenant.sharepoint.com/sites/SiteName, rather than a document-library or individual file URL.
What does an invalid CRLF character error mean?
CRLF refers to carriage-return and line-feed characters. Check the pasted site URL for hidden line breaks, extra spaces, or other unintended characters, and retype it if necessary.
How do I change the account used for the SharePoint connection?
Go to Data > Get Data > Data Source Settings, select the relevant site under Global permissions, and choose Clear Permissions. Reconnect and sign in with the organizational account used for SharePoint.
Why can I open the file through OneDrive but not connect through SharePoint Folder?
The two connection paths can use different URLs or saved permissions. Check the site URL and credentials used by the SharePoint Folder connector rather than assuming the working OneDrive connection uses the same settings.
What should I do if the error persists after reconnecting?
Try Data > Get Data > From SharePoint Folder in a new workbook. Also check File > Account > Update Options for Office updates, if that option is available.




