Power Query Problems

Fix Excel SharePoint Folder Connection Error Caused by Invalid CRLF Characters

Olivia MillerOlivia Miller Nov 18, 2026 869 views

Question details

The user needs to connect Excel Power Query directly to a SharePoint folder without an invalid CRLF character error.

Fix the Excel SharePoint Folder Invalid CRLF Connection 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.
Before you start

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.

Solution 1Recommended

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.

1
Check the site address

Copy only the SharePoint site URL, such as https://tenant.sharepoint.com/sites/SiteName. Do not include a document library path or file name.

2
Remove hidden line breaks

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.

3
Check your Excel account

In Excel, open File > Account and verify that you are signed in with the Microsoft 365 account used to access the SharePoint site.

4
Clear saved permissions

Open Data > Get Data > Data Source Settings. Select the relevant SharePoint site under Global permissions and choose Clear Permissions.

5
Connect again

Choose Data > Get Data > From Online Services > From SharePoint Folder, enter the clean site URL, and sign in with your organizational account when prompted.

Reconnect Excel using a clean SharePoint site URL
Clearing permissions: Excel will ask you to authenticate again when you next connect to the cleared data source.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX filesWork with spreadsheet data in a familiar interfaceUse a lightweight office suite with a free versionMove existing Office documents into a compatible workspace
microsoft office alternative - wps office

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.