将大型Excel导入SharePoint [英] Import a big excel into SharePoint

问题描述

大家好，

我有一张包含9张的excel文件。我需要将3张表中的数据导入SharePoint列表。 3张数据的总数量为1.9M。

当我尝试将其导入导入电子表格列表时，它只能用于一张而不是用于其中3张。

那么有一种方法可以在excel文件中获得一个包含3张数据的SharePoint列表吗？

谢谢。

解决方案

3张图纸是否具有相同的架构？

您可以先将它们合并为一张，然后尝试导入。

Hi Guys,

I have an excel file with 9 sheets. I need to import data from 3 sheets into a SharePoint list. The total count of data is 1.9M in 3 sheets.

When I am trying to import it into an import-spreadsheet list it is only doing it for one sheet not for 3 of them.

So is there a way I can get one SharePoint list with data from 3 sheets in an excel file?

Thanks.

解决方案

Do the 3 sheets have the same schema?

You can merge them into one sheet first and then try import.

这篇关于将大型Excel导入SharePoint的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！