I am brand spanking new to SharePoint.  I have been tasked with developing a SharePoint site that will facilitate finding documents, and better organize them than they currently are on our network drives.  I am now trying to set up a specifications library.

there are:

 - Specifications
 - Standard Specifications Exceptions
 - Non Standard Specification Exceptions

The non standard specification exceptions are also broken into 4 regions where the same exemption file name can have different contents.

Originally I was planning on uploading everything into one Library and using different views to see the information.  But after reading another question on here, it sounds like a separate library for each is the better approach.

In the end I will have probably about 3K +/- documents to upload.  They will be a mix of PDF, XML, DOC, and DWG.  Every file will have a unique name.  Some of the file formats will be:

    NSP BIRD.XML
    NSP 001A820.XML
    NSP 100F08M.xml
    OPSS 0202.pdf
    OPSS 0304.pdf
    SSP 101F23.xml
    SSP 102S05.xml
    MTOD 0101.0700.dwg
    MTOD 0202.0400.dwg
    OPSD 0100.0100.dwg
    OPSD 0100.0110.dwg
    SSD 0002.0001.dwg
    SSD 0005.0002.dwg

Currently each of the type defined by the first 3-4 characters is in its own directory.  Also each directory has an excel file which holds an index.  Which are all similar, but column names, count and position may vary slightly from one index to the next.

An example index would look like:

[![enter image description here][1]][1]

Based on this table I know that SSD 0002.0001.dwg has the title:

    Structural Standard Drawings Layering Structure

And that its Status is:

    Active

While I can drag an drop 100 files at a time and manually go into the library an and fill in the column information for each file it is rather time consuming.

**Is there a way for the files to be uploaded and have the appropriate column information pulled from the index file?**

As a followup question is there a better way of doing this?  Previously I just made a hyperlink formula in each index that linked to the file on the network drive.

No clue what to tag this as either so some assistance with that would be appreciated.


  [1]: https://i.sstatic.net/qckBq.png