Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Notes: To create and upload files and folders in a library, you must have contributor permissions to the library. If you're not sure what permissions you have, contact your SharePoint Admin. …