What is wrong with the Sharepoint Migration Tool and CSV Imports

ComputerHabit 571 Reputation points
2022-04-07T16:19:53.447+00:00

I absolutely cannot seem to get the CSV import to work with SharePoint migration. I have used this tool for a while now and it has worked but now for some reason I'm stumped. It just won't work.

If I walk through the wizard it works for all paths I'm defining in the CSV.

If I export the wizard settings I can use those and they work.

The CSV with the exact same paths and settings gives a source error every time.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,812 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,120 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ComputerHabit 571 Reputation points
    2022-04-07T16:29:51.677+00:00

    Why the f do you even include it if you then have to remove it...!!!

    Just flipping program the headers into the program. So stupid.

    Do not include a header row in your CSV file. The example shown above included headers to demonstrate the order of the fields.

    0 comments
  2. Yi Lu_MSFT 17,271 Reputation points
    2022-04-11T16:41:22.947+00:00

    Hi @ComputerHabit
    Column header in csv file is not a necessary option. There are six columns needed in your CSV file -- the first three are your source values, each providing detail about where your data is currently located. The remaining three columns indicate the site, document library and optional sub-folder to where you are migrating your data. All six columns must be accounted for in the file, even if you are not needing a value for a given field.

    Column A: Enter a file share path. Required.
    Column B: Leave this column blank. This column does not apply to file share migration.
    Column C: Leave this column blank. This column does not apply to file share migration.
    Column D: Enter the SharePoint site URL or OneDrive email/URL where the files are to be migrated. Required.
    Column E: Enter the name of the document library in the SharePoint site where the files are to be migrated. Required.
    Column F: Enter the name of the subfolder in the document library. If this column is left empty then the files will be moved to the root level. Optional.

    For more information about using a comma-separated value (CSV) file for bulk upload, you could refer to:
    https://learn.microsoft.com/en-us/sharepointmigration/mm-bulk-upload-format-csv-json#using-a-comma-separated-value-csv-file-for-bulk-upload
    https://learn.microsoft.com/da-dk/sharepointmigration/how-to-format-your-csv-file-for-data-content-migration#use-a-csv-file-for-bulk-upload

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.