Advice requested for uploading metadata in bulk to a Sharepoint Online document library (including managed metadata fields)

Question

I have a 4000+ item Sharepoint Online document library, and an excel sheet containing associated metadata. Some of the columns have multiple entries per field, and I would like to use Managed Metadata term sets for those columns (so that I can set up filters later). The solution presented in another thread here does not work, because it is not possible to paste data into Managed Metadata fields using the Quick Edit feature. Is there any way to use excel or csv to upload the metadata, and map the associated data to the term set terms? Even if I end up not using the managed metadata, is there a straightforward way to upload bulk metadata from csv (or by any other method) to a Sharepoint Online document library, other than Quick Edit?

Answer 1

I don’t think it is possible to upload column metadata to a document library via Excel spreadsheet, neither managed metadata column values nor other types of column values.

There are several third-party tools that provide bulk-tag or bulk-edit functions, which might do some help. Please see the links below.

References:

HOW TO BULK-TAG A SHAREPOINT LIBRARY TO ASSIGN MANAGED METADATA TO ALL DOCUMENTS AUTOMATICALLY?

Bulk Edit SharePoint Metadata: The Basics.

Data / Document Importer For SharePoint.

Answer 2

It is still possible to import a spreadsheet to SharePoint (including SharePoint Online) to create a list with basic metadata columns. Here is Microsoft's article on how to do it. I performed the steps in SharePoint Online and it worked. I doubt this can be used for Managed Metadata, however.

Create a List Based on a Spreadsheet