Export To SharePoint List - An Unexpected Error has occurred

Hello,

I wasn't sure if I should create this topic in SharePoint section but since I'm getting this error on Excel, I've decided to create it here.

I'm trying to get started with SharePoint lists. However, I have hit a road block before even starting.

I've googled extensively before creating this thread. None of the articles were helpful and I gave up on Google.

Details:

I created a dummy file with a dummy table. No special characters anywhere. Uploaded it my SP. This is the error I get when I try to export the table to SP Lists.

I then contacted my IT to check if I had permission. I didn't. Then I was granted permission. I can create lists manually on SP. I can even import Excel files with tables through the browser.

However, I still get the same error using Excel. Since the error doesn't indicate anything else I couldn't expand my research.

What I've tried so far:

• Sign out and sign in.
• Removed my credentials from Credentials Manager on Windows and sign in again
• Tried changing file format to XLSM or XLSX
• Made sure there are no special characters in the table headers.
• Validated my SharePoint address through my IT. I can also access my SP using PowerQuery with the same URL.
• Unmarked "Ignore other applications that use Dynamic Data Exchange (DDE)" in Excel options
• Ran gpupdate /force through elevated command prompt.

Note:

I'm accessing my SharePoint using OneDrive.

I'm in need your assistance.

Thanks.