Understanding File Paths

Written by Allen Wyatt (last updated September 2, 2019)

1

You already know that information is stored on your disk drive in a series of files. You may also know that those files can be organized using folders, and that folders can exist within other folders. All this organization has a slight drawback, however—it can make locating a particular file a bit tricky.

This is where file paths come into play. A file path can be viewed as an address for your house; it provides detailed information (in a standardized format) for locating any given file on a disk drive. The file path starts with the drive letter of the disk drive, such as C:. To this beginning is appended the "path" of folders that are traversed to get to the file. Each item in the file path is separated from other items by a single backslash, in this manner:

c:\My Files\Budgets\Current Year\Research\budget.xlsx

This particular example shows that the file budget.xlsx (an Excel file) is stored within the Research folder, which in turn is stored in the Current Year folder, which is within the Budgets folder, which resides in the My Files folder.

Every path name—when fully qualified so it includes both the drive letter and the file name—is unique and unambiguous; there cannot be a duplicate path name for that unique file.

You should note that Windows places a limit on the length of path names—260 characters. This may seem like a lot of characters, but it is relatively easy to exceed. For example, the fully qualified path example earlier in this tip takes up 53 characters. With a few more subfolder "levels" added or a few more verbose folder names, the limit would be easy to reach. The rule here is to make sure that you name your folder and structure your hierarchy such that you lessen the risk of hitting this 260-character length limit.

 This tip (6818) applies to Windows 7, 8, and 10.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Strip Trailing Spaces

If you get tired of documents that always seem to have extra spaces at the end of lines, here's a quick way to get rid of ...

Discover More

Running Macros on Hidden Worksheets

Excel allows you to hide worksheets so that they aren't visible to those using your workbook. Hiding worksheets has a ...

Discover More

Conditional Formatting for Errant Phone Numbers

Conditional formatting can be used to draw attention to all sorts of data based upon the criteria you specify. Here's how ...

Discover More
More WindowsTips

Making a File Read-Only

If you have an important file that you want to be sure doesn't get accidentally edited, you can set it to read-only. This ...

Discover More

Removing Temporary Files

Windows provides a workspace for programs to create temporary files, the Temporary folder. You can remove files from the ...

Discover More

Undoing a System Restore

Having the ability to restore your system back to when it was working properly is great, but what if, for some reason, ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine more than 6?

2019-09-03 20:25:42

Alex B

If you find you can't open an Excel file, the filepath & name length can be an issue, a workaround (especially for network drives) is to map the fully specified path to a Drive letter. The more levels you include in the mapping the shorter the full name.
Your colleagues needing to access the file would need to do it too though.

OneDrive is causing me a lot of grief. I store the file path for various reasons and want the OneDrive path not the C Drive location that the file is synching too.
Love to hear any suggestions on how to get OneDrive path without having to go through a browser to get it.


Newest Tips