Share via

How do I get the csv import working for Sharepoint lists

Anonymous
2023-02-08T19:41:03+00:00

I have a simple list used for calendar function, with a few rows created manually. I have a CSV with data from another similar list that I want to import.

Using the standard Import CSV data button.

I select the file and select the Preview button and it shows the expected data in the expected columns, Title is the one system column in common and I have that 1st.

I hit the Import button, and get a new screen with a spinning circle, that will run for hours and I have to close the screen to crash it out.

Why is there not better error trapping to tell me what the issue is? or a cancel button to be able to abandon the import cleanly.

Do I need to get the columns in a different order?

Any tips for how to get this working?

Thanks

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-09T00:37:43+00:00

    Dear Astrid,

    Good day! Thank you for posting your query in our community.

    Based on your description, you can't import a CSV file to create a list successfully. Generally, we create a list based on the CSV file via the "From CSV" option when you create a new list, you can check the following image. And from the screenshot you provided, may I confirm whether you add the "Import CSV Data" button additionally in SharePoint Online?

    Image

    However, when I tested the above "From CSV" option on my side, I will be stuck on the blank page of the file upload. And I also tested on the different tenants and different devices, the same results.

    Given this situation, we assume the problem may be related to the SharePoint backend. And about this behavior, we haven't received any report about it so far. Since we can reproduce a similar situation as yours. We suggest you contact the administrator in your company if you aren’t the administrator and follow the steps in the article to open a ticket to double confirm this behavior. The engineers in the related team have higher permission and resources than us to help check the root cause from the background. 

    Appreciate your understanding.

    Sincerely,

    Jazlyn | Microsoft Community Moderator

    0 comments