How to Add Tags in Excel

Tags in Excel are document properties — keywords stored in the file’s metadata that describe what the workbook is about. You add them on Windows through File → Info → Properties (or in the Save As dialog), and once saved they make the file findable when you search by keyword in File Explorer, OneDrive, or SharePoint.

A common misconception is that “tagging” means typing labels into cells, like a #Region marker in the grid. That is just text in a worksheet — Excel does not treat it as metadata. Real tags live at the file level, alongside properties such as Title, Author, and Categories. This guide covers adding them on Windows and Mac, where the feature is genuinely limited, and the common confusion about what tags are and are not.

What “tags” actually mean in Excel

When Excel and Windows talk about tags, they mean the Keywords field of the file’s document properties. “Tags” and “Keywords” are the same thing — the modern Backstage view labels the field “Tags,” while the older Advanced Properties dialog calls it “Keywords.” Either way, the data is stored inside the workbook file and travels with it.

These tags are searchable. Windows Search and File Explorer index document keywords, so a file tagged budget; 2026; quarterly is found by typing tags:budget into the File Explorer search box. The same indexing powers OneDrive and SharePoint, which is why tags matter for teams storing many workbooks in a shared library. Sitting next to Tags is Categories, a separate free-text field often used to group files by project or department. Because all of this is metadata, none of it changes a single cell in your spreadsheet — if you need labels inside the grid, see the section on what tags are not.

How to add tags in Excel on Windows

There are three places to add tags on Windows, and they all write to the same field.

Method 1: File → Info → Properties (the main route)

1. Click the File tab to enter the Backstage view, then select Info.
2. On the right, find the Properties panel and the Tags field (it shows the placeholder “Add a tag”).
3. Click into the field and type your keywords, separating multiple tags with a semicolon, like forecast; finance; 2026.
4. Click outside the field, then save the workbook (Ctrl+S). The tags are now stored in the file.

The same panel shows Categories just below Tags — fill it the same way if you want a second grouping dimension.

Method 2: The Save As dialog

The Save As dialog includes an Add a tag field directly beneath the file name (use the full dialog, not the quick Backstage save). Type your keywords there before clicking Save and they are baked into the file as you create it — handy when filing a workbook for the first time. You can also carry tags into a saved template so every new file inherits sensible keywords.

Method 3: The Advanced (Document) Properties panel

For the complete set of fields, go to File → Info → Properties → Advanced Properties. On the Summary tab you will find Keywords (the same field as Tags), plus Categories, Title, Subject, Author, and Comments. Type your keywords, click OK, then save. This is the same dialog Word and PowerPoint use, so keywords behave consistently across Office. The dedicated walkthroughs for how to display document properties and how to edit document properties cover this panel in more depth.

Why tags help on Windows

Once a file carries tags, they pay off in search. In File Explorer, type tags:invoice to list every tagged file in a folder tree. In OneDrive and SharePoint, keywords feed the search index so colleagues can find your workbook without knowing its file name, and SharePoint can build views and filters around that metadata. This makes tags a quiet but powerful organizing tool when you are storing many workbooks and relying on search rather than folder structure to find them later.

How to add tags to an Excel file on a Mac

This is where expectations need adjusting. Excel for Mac does not expose a Tags (Keywords) field the way Windows does. Open File → Properties in Excel for Mac and you will find Title, Author, Subject, and Comments — but not the dedicated keywords field Windows surfaces so prominently. The alternative is to tag the file through macOS itself, using Finder tags and Spotlight Comments.

Finder tags

1. Quit or save your workbook, then locate the .xlsx file in Finder.
2. Right-click (or Control-click) the file and choose Tags…, or select the file and click the tag area in the Get Info window (Command+I).
3. Type a tag name or pick a colored tag. Finder tags are searchable through Spotlight and the Finder sidebar.

Spotlight Comments

In the same Get Info window (Command+I), the Comments field at the bottom lets you type free-text keywords. Spotlight indexes this text, so you can find the file by searching for those words.

The important distinction: Finder tags and Spotlight Comments are stored by macOS, not inside the Excel file. They generally do not travel with the workbook — email the file to a Windows colleague and those tags usually will not show up as searchable document keywords. For cross-platform, in-file tags, set them on a Windows machine, since that keyword metadata is part of the Office file format and is then readable everywhere.

What tags are not (don’t confuse these)

Because “tag” is such a loose word, it is easy to reach for the wrong feature. Tags are file-level metadata — they are not any of these in-sheet tools:

• Cell comments / notes annotate a specific cell, not the file. A note attached to a value is a printable comment, not a tag.
• Named ranges give a block of cells a friendly name for use in formulas. If you want to “tag” a range to refer to it, you want a named range.
• Table names identify an Excel Table; renaming one is covered in how to name a table.
• Sheet headers print text at the top of a page and are set up by adding a header.

Tags describe the whole file for search; the tools above describe parts of the worksheet.

Troubleshooting tags in Excel

The Tags field is greyed out or read-only

The most common cause is that the file is marked Final (File → Info → Protect Workbook → Mark as Final), which makes the whole workbook read-only — turn that off and the field becomes editable. A file opened in Protected View (downloaded from the internet or email) also blocks edits until you click Enable Editing. And if the file lives on a network share or cloud folder that someone else has open, you may have a read-only copy; close and reopen once it is free.

Tags aren’t showing up in search

Windows Search relies on its index. If a tagged file does not appear, the folder may not be included in indexing (check Indexing Options in Control Panel) or the index may not have caught up yet. Make sure you actually saved the workbook after adding the tag — tags typed but not saved are never written to the file. For OneDrive and SharePoint, allow a few minutes for the cloud index to refresh.

Tags disappear when saving to an older format or CSV

Tags are stored in the modern .xlsx format. Save to a different format and the metadata may be dropped. CSV carries no metadata at all — it is plain text with no document properties, so tags are lost the moment you save as CSV (expected behavior, not a bug). Older .xls uses a different property structure and may not preserve keywords reliably. Keep the file as .xlsx to retain tags; when you must hand off a CSV, treat the tagged .xlsx as your master copy. The same caution applies if you make a copy of the workbook in another format.

Tags vanish after locking or sharing the file

Locking cell contents to protect formulas while allowing input does not remove tags — sheet protection and file metadata are independent. But re-saving through a tool or script that rewrites the file (some PDF or compression utilities) can strip properties. If you routinely compress or zip a workbook for emailing, confirm the tags survived after you unzip it on the other side.

Frequently Asked Questions

How do I add tags to an Excel file?

On Windows, go to File → Info → Properties, type your keywords into the Tags field (separate them with semicolons), and save. You can also use the Add a tag field in the Save As dialog, or the Keywords field in Advanced Properties. On a Mac, use Finder tags or Spotlight Comments instead, since Excel for Mac does not expose the same Tags field.

What are Excel file tags and where are they stored?

Excel file tags are keywords stored in the workbook’s document metadata, not in any worksheet cell. They live inside the .xlsx file alongside properties like Title, Author, and Categories, and travel with the file. Windows, OneDrive, and SharePoint all index these keywords so the file turns up when you search for them.

How do I add keywords to an Excel file for search?

Add keywords through File → Info → Properties → Tags (or Advanced Properties → Keywords) and save the file as .xlsx. Once saved and indexed, find the file in File Explorer by typing tags:yourkeyword in the search box, or by searching the keyword in OneDrive or SharePoint.

How do I tag an Excel spreadsheet on a Mac?

Excel for Mac has no built-in Tags field, so tag the file through macOS. In Finder, right-click the file and choose Tags…, or open Get Info (Command+I) to add a colored tag or type keywords into Spotlight Comments. These are stored by macOS and searchable on your Mac, but they do not embed inside the Excel file the way Windows document keywords do.

Why aren’t my Excel tags searchable?

Usually the file was not saved after the tag was added, the folder is not included in Windows indexing, or the index has not refreshed yet (OneDrive and SharePoint can take a few minutes). Also confirm the file is .xlsx — a CSV stores no metadata, so tags saved to CSV are simply gone.

Can I add tags to cells inside the worksheet instead of the file?

Excel has no cell-level “tag” feature. To label data within the grid, use a dedicated column of text you can filter, attach a cell comment, or define a named range. File tags are strictly document metadata and describe the whole workbook, not individual cells.