To display superscript in an Excel export, use an .xlsx file and apply superscript character formatting in desktop Excel, or make sure the software creating the export writes rich-text formatting. CSV files cannot preserve superscript styling: they contain plain text and values, not Excel font effects. If only the appearance matters, Unicode characters such as ² can be an alternative, but they are not the same as Excel formatting.
What superscript means in an Excel cell
Superscript is a visual style that raises selected characters above the normal text line and usually makes them smaller. It is useful for footnote markers, units such as square metres (m²), chemical notation, and mathematical expressions. Excel can store character-level formatting in a text cell, so the “2” in a label such as Area m2 can be raised without raising the other characters.
That formatting is different from a number format. Number formats control how a value is displayed as a whole, for example as a date, currency, or percentage. They do not provide a general way to raise one digit within a numeric value. If a cell must remain a true number for calculations, do not assume you can superscript only one of its digits while preserving its numeric behavior. Mixed formatting is principally suited to text content.
It is also different from inserting a superscript Unicode character. A formatted 2 remains the ordinary character “2” with a font effect; the character ² is a distinct symbol. The two may look alike, but they can behave differently in searches, formulas, copy-and-paste operations, and downstream systems.
Apply superscript in desktop Excel
In Microsoft Excel for Microsoft 365 on Windows, you can format selected characters inside a text cell. Enter or edit the text, select just the characters to raise, and turn on the Superscript effect in the Font settings:
- Double-click the cell, or select it and press F2, to edit its contents. You can also edit in the formula bar.
- With the insertion point active, drag across the specific character or characters. For a footnote marker, select only the marker, not the whole label.
- Press Ctrl+1 to open Format Cells, choose the Font tab, check Superscript under Effects, and select OK.
- Press Enter to finish editing. Check that the selected characters appear raised and that the rest of the cell remains unchanged.
You can reach the same font settings from Home > Font using the small dialog box launcher in the lower-right corner of the Font group, then choose the Font tab and Superscript. Excel does not provide a standard one-keystroke shortcut that directly toggles superscript for selected cell characters; Ctrl+1 opens the formatting dialog, where you choose the effect.
In Excel for Mac, the Format Cells dialog is generally opened with Command+1. The selection process is otherwise similar: edit the text, select the characters, open the Font settings, and choose Superscript. Ribbon labels and dialog layout can vary slightly by Excel release. Excel for the web has fewer rich-text editing options than the desktop app; if you need to create or adjust character-level superscript and cannot find the effect, open the workbook in desktop Excel.
What happens when you export
The word “export” can describe different operations. Saving an Excel workbook as an .xlsx file preserves supported cell formatting, including rich-text effects such as superscript. If the workbook is being produced by another application, the result depends on whether its export feature writes that formatting into the workbook. A column that looks correct in the source application may arrive as ordinary text if the exporter sends only the cell value.
CSV is different. A CSV file stores rows of text separated by delimiters; it has no fields for font face, font size, color, or superscript. When Excel saves a workbook as CSV, it retains the text or value but discards cell formatting. Reopening that CSV in Excel will not restore the superscript effect. If the file is intended for another system that accepts only CSV, ask whether it supports a markup convention or use a suitable text representation rather than expecting visual formatting to survive.
Other output types have their own trade-offs. A PDF can preserve the visual appearance of a worksheet for reading or printing, but it is not an editable spreadsheet export. HTML may represent raised text with markup or styling if the exporting application supports it, but support depends on the software and the receiving application. Older Excel workbook formats may retain many familiar font effects, but .xlsx is usually the more suitable choice for current Excel workbooks.
When the export is generated by software
If a report, database, website, or business application creates the Excel file, formatting must be added during export or in a later Excel step. Look for settings with names such as rich text, character formatting, inline formatting, or cell font effects. A setting that applies a font to an entire cell is not necessarily enough to superscript only part of the cell.
For a mixed label such as “Revenue1”, the exporter must represent the cell as text with separately formatted character runs: ordinary text for “Revenue” and a superscript run for “1”. Not every spreadsheet-writing tool supports rich text runs. Some can set a font style for a whole cell but cannot assign different font effects to different characters within it. In that case, the output may need to be post-processed in Excel, generated with a tool that supports rich text, or changed to use a plain-text notation.
When investigating an export, check the actual downloaded .xlsx file rather than relying only on the source system’s preview. Open it in desktop Excel and inspect the cell. If the entire cell is formatted uniformly, the exporter may have applied cell-level formatting instead of character-level formatting. If the text is correct but the marker is not raised, the export likely omitted the rich-text effect. A file extension alone does not guarantee that a specific application wrote the formatting you expected.
Unicode superscript characters as an alternative
Unicode includes familiar superscript symbols such as ² and ³, as well as several superscript letters and digits. Typing or pasting the actual symbol into a cell can make it look raised without relying on rich-text formatting. This can be useful when a value must travel through plain text or CSV and the receiving system can display the character.
However, Unicode superscripts are characters, not formatting instructions. For example, 10² contains the superscript-two symbol, not the ordinary digit 2 raised by Excel. A formula that expects ordinary digits may not treat the symbol as a number, and searches for “10^2” or “102” may not find the same text. Coverage and appearance also depend on the font and the software displaying the file. Some superscript forms are not available for every letter or symbol, and the glyph may look different across devices.
For a label such as m², the Unicode symbol is often a practical plain-text choice. For a scientific expression, a footnote marker that must be separately editable, or content that must retain exact character identity, confirm what the recipient expects before choosing between a Unicode symbol and formatted ordinary text.
Common problems and checks
Superscript can appear to vanish for several different reasons. The first check is the file type: if the file was converted to CSV or another plain-text format, the loss is expected. If it remains an .xlsx file, check whether the effect was applied to the selected characters rather than to a different cell or to no selection at all.
- The whole cell changed: Reopen the cell for editing and select only the marker before changing the Font effect. Applying Superscript from the cell’s general formatting controls can affect the whole cell rather than only the intended characters.
- The export looks right in one program but not another: The receiving application may not support the same rich-text details or may substitute fonts. Open the workbook in Excel desktop to distinguish a display issue from missing formatting.
- The marker is plain text after reopening: Confirm that the file is .xlsx and that the export process supports character-level formatting. Re-saving a CSV as .xlsx does not recreate formatting that was already discarded.
- The text no longer behaves as expected: Check whether the cell contains a text string or a numeric value. Mixed formatting is not a replacement for numeric formatting, and converting a number to text can affect sorting, calculations, and other operations.
- The symbol looks like a different size or shape: Try a font that supports the character, and verify the result in the application and on the device where the file will be used.
For a reliable handoff, save a copy as .xlsx, close it, reopen it, and inspect representative cells. If the recipient needs a print-ready copy as well, export a separate PDF and treat it as a visual document rather than as a substitute for the workbook.
Choosing the right approach
The best method depends on what the recipient needs to do with the data, not just what looks best on your screen. Use Excel rich-text superscript when the workbook is meant to remain an editable Excel document and the particular characters need formatting. Use Unicode superscript when a plain-text export must carry a recognizable raised character and the symbol is available and acceptable. Use a PDF when preserving the page’s appearance is more important than editing individual cells.
Before distributing an export, consider these questions:
- Does the recipient need to calculate with the cell contents, or are they labels and notes?
- Will the receiving system accept .xlsx, or does it require CSV or another format?
- Must the raised character remain a normal digit or letter for searching and data processing?
- Does the exporter support formatting individual characters, or only entire cells?
If the content is a footnote marker, another robust design is to keep the data plain and put the explanatory note in a separate column or a dedicated notes section. That may be easier to process than depending on rich text, especially when files pass through several systems. It is a content-design choice, not a requirement: use it when it makes the workbook clearer or more compatible.
Frequently Asked Questions
Can I use a custom number format to superscript one digit?
No. Excel number formats can change how a whole numeric value is displayed, but they do not provide general character-by-character superscript styling. Use text with rich-text formatting for a visual label, or use a Unicode character if plain text is required.
Does superscript survive saving as CSV?
No. CSV does not store Excel font formatting. The cell’s text or value may remain, but the superscript effect is removed. Keep an .xlsx copy if the formatting must remain.
Can I superscript only one character in a cell?
Yes, for text in desktop Excel: edit the cell, select the character, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then select Superscript on the Font tab. The effect is character-level, not a special number format.
Why does superscript disappear in an Excel export from another system?
The exporting software may send plain cell values or whole-cell styles without rich-text runs. Check its export settings or documentation for character-level formatting support, and inspect the downloaded .xlsx file in desktop Excel.
Are ² and formatted 2 interchangeable?
No. They may look similar, but ² is a distinct Unicode character, while a formatted 2 remains an ordinary digit with a visual effect. Choose based on whether appearance, editing, searching, or downstream processing matters most.
Related
- Convert Text to Numbers in Excel: Methods That Work
- Convert Excel to ZIP: How to Compress and Share a Workbook
- Convert an Excel Binary Worksheet (.XLSB) to Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Always Not Responding? Causes and FixesNo—Excel does not always freeze because the program is broken. A Not Responding message usually means Windows is…
- Remove Duplicate Names in Excel: Step-by-Step InstructionsTo remove duplicate names in Excel, select the name list or the entire related dataset, then choose Data…
- Splunk Split Command: How to Use ItThe split command in Splunk divides the values of a single multivalue field into separate events, or splits…
- Google Sheets Growth Percentage Formula: How It Works and ExamplesTo calculate growth percentage in Google Sheets, subtract the earlier value from the later value, divide by the…
- How to Find Duplicates in Excel Quickly and AccuratelyTo find duplicate values in Excel, select the cells you want to check, then choose Home > Conditional…
- Excel File Corrupted? Recovery Steps That WorkIf an Excel file is corrupted and cannot be repaired, stop working on the original, make a separate…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.