SOLVED

Importing column names and choices into SharePoint document library

%3CLINGO-SUB%20id%3D%22lingo-sub-2619076%22%20slang%3D%22en-US%22%3EImporting%20column%20names%20and%20choices%20into%20SharePoint%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2619076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20at%20setting%20up%20a%20document%20library%20within%20SharePoint.%20I%20have%20an%20excel%20spreadsheet%20with%20the%20columns%20that%20we%20want%20in%2C%20as%20well%20as%20the%20choices%20that%20we%20want%20people%20to%20be%20able%20to%20choose%20from.%20Since%20I%20already%20have%20that%2C%20I%20was%20wondering%20if%20there%20is%20a%20way%20to%20import%20this%20instead%20of%20doing%20it%20manually%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2619076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2620954%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20column%20names%20and%20choices%20into%20SharePoint%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620954%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122075%22%20target%3D%22_blank%22%3E%40LeeWhittaker%3C%2FA%3E%26nbsp%3Bif%20it%20was%20a%20list%20then%20it%20can%20be%20created%20from%20an%20Excel%20document%2C%20but%20there%20isn't%20the%20same%20functionality%20for%20a%20document%20library%20so%20you'd%20need%20to%20do%20it%20manually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi,

 

I'm looking at setting up a document library within SharePoint. I have an excel spreadsheet with the columns that we want in, as well as the choices that we want people to be able to choose from. Since I already have that, I was wondering if there is a way to import this instead of doing it manually?

1 Reply
best response confirmed by LeeWhittaker (Visitor)
Solution

@LeeWhittaker if it was a list then it can be created from an Excel document, but there isn't the same functionality for a document library so you'd need to do it manually.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)