Yes, you can export tab-separated data from Excel, but the usual CSV option does not normally create a tab-delimited file. In Excel for Microsoft 365 on Windows, choose File > Save As, then select Text (Tab delimited) (*.txt); use the .tsv extension for a clearly labeled tab-separated file, or rename it to .csv only if a system specifically requires that extension.
What CSV and tab-delimited mean
CSV stands for comma-separated values. It is a plain-text format in which commas commonly separate fields and line breaks separate records. A tab-delimited file uses the same general row-and-column idea, but a tab character separates fields. The term TSV, or tab-separated values, is a more informative name for this second format.
Both formats are text, not Excel workbooks. They do not retain workbook features such as cell colors, formulas as editable formulas, multiple worksheets, charts, or column widths. They are designed to move table-shaped data between applications. Although people sometimes use “CSV” loosely to mean any delimited text file, a recipient may expect commas when they see a .csv filename. The delimiter in the file matters more than its extension to software that reads the content, but some programs use the extension to decide how to open it.
How Excel’s CSV export works
Excel’s Save As formats include CSV options and a separate tab-delimited text option. Choosing CSV (Comma delimited) or CSV UTF-8 (Comma delimited) creates comma-separated output in the usual configuration. The precise separator can depend on regional settings: Excel may use the Windows list separator, which can be a semicolon in some locales. That does not make the ordinary CSV option a reliable way to request tabs.
The built-in tab-delimited choice is labeled Text (Tab delimited) (*.txt). It writes tab characters between fields, but the suggested filename extension is .txt rather than .csv. That is why the practical answer is “yes, with a different Save As format,” rather than “select CSV and change a checkbox.” The standard Save As dialog does not provide a general delimiter box for choosing tabs while saving as CSV.
Excel’s text export is also limited to the active worksheet. If a workbook contains several sheets, save each required sheet separately, or assemble the needed data on one sheet first. The export is not a copy of the whole workbook; it is a plain-text representation of the current sheet’s tabular contents.
Export a tab-delimited file in Excel for Windows
To create a straightforward tab-separated export in Microsoft 365 for Windows, follow these steps:
- Open the workbook and select the worksheet you want to export. Confirm that it contains the intended rows and columns.
- Select File > Save As > Browse to open the Save As dialog.
- Open the Save as type list and select Text (Tab delimited) (*.txt).
- Choose a location and filename, then select Save.
- If Excel warns that the selected format does not support multiple sheets or workbook features, confirm the export. Only the active sheet is written to the text file.
- If the receiving system accepts TSV, change the exported file’s extension from .txt to .tsv in File Explorer. If it explicitly requires a .csv name, change the extension only after confirming that the system accepts tabs as delimiters.
Changing the extension does not convert the contents. A file renamed from .txt to .csv still contains tabs. That is fine when the target application is configured to read tabs, but it can confuse a person who expects a conventional comma-separated CSV. If the destination lets you specify a delimiter, choose Tab when importing.
Excel for Mac also offers text export formats through File > Save As, although the dialog and format labels can differ by version. Choose the tab-delimited text format if it is listed; do not assume that a CSV selection means tabs. Excel for the web has fewer export controls, so use the desktop app when you need this specific tab-delimited Save As format.
When a .csv extension is required
Some upload portals and older business systems insist on a filename ending in .csv even though their instructions ask for tab-separated columns. In that case, the content can still be tab-delimited: export using Text (Tab delimited), then rename the file to the required extension. Before uploading, check the recipient’s instructions or test with a small file. The extension describes a naming convention; it does not change commas into tabs or tabs into commas.
If the receiving program rejects a tab-delimited file named .csv, use its import settings or ask which format it actually expects. A system may use the extension to choose a parser and then interpret tabs as part of a single field. Conversely, some tools inspect the content or offer a delimiter choice, so they can read tab-separated text regardless of whether the name ends in .txt, .tsv, or .csv.
When you control both ends of the exchange, .tsv is generally the clearest extension for tab-separated values. It reduces ambiguity for colleagues and makes it easier to distinguish the file from a comma-separated CSV. Follow a recipient’s exact specification, however, if its software requires a different extension.
Check the data before exporting
A delimited text file has no Excel cell types in the workbook sense. Dates, numbers, and identifiers are represented as text characters, and the receiving program may interpret them differently when it opens the file. Review the sheet before saving, especially if it includes leading zeros, long numbers, dates, or values whose display depends on cell formatting.
- Identifiers: Postal codes, product codes, and account numbers can lose leading zeros if a receiving application treats them as numbers. Keep such values as text where appropriate and check them after import.
- Dates: A date displayed as 03/04/2026 can be read as March 4 or April 3 depending on regional conventions. If the file will travel between systems, agree on an unambiguous date format with the recipient.
- Formulas: A text export is for data exchange, not for transferring a live formula system. The receiving file will not contain the original Excel formulas as working formulas. Check the exported results if calculated values are important.
- Formatting: Colors, borders, merged-cell layout, and column widths are not carried over as workbook formatting. A text file represents rows and fields, not how the worksheet looks on screen.
- Blank cells and extra columns: Remove unintended notes or data far to the right or below the table. Confirm the exported range is clean so the recipient does not receive irrelevant fields or records.
Also inspect fields that contain tab characters or line breaks. A tab inside a field can be mistaken for a field boundary, and a line break inside a value can look like a new record to a simple text reader. If those characters occur in the source data, check how the destination’s importer handles them rather than assuming that a plain text export will preserve every field unambiguously.
Encoding and special characters
Delimiter and character encoding are separate choices. The delimiter determines where columns divide; encoding determines how letters and symbols are stored as bytes. If the file contains accented names, non-Latin writing, or symbols, verify that the destination can read the encoding produced by the selected Excel text format. A file that has the right tabs can still display garbled characters if its encoding is interpreted incorrectly.
Excel’s CSV UTF-8 option is useful when a recipient needs UTF-8 comma-separated data, but it does not make the separator a tab. The basic Text (Tab delimited) option and Unicode Text option are distinct formats, and their availability and encoding behavior should be checked against the destination’s requirements. If a system specifies both UTF-8 and tab delimiters, use a workflow that explicitly produces both, then test the result in a text editor or the recipient’s import screen. Do not infer encoding just from a .txt or .tsv filename.
Import the file without losing columns
Opening a tab-delimited file by double-clicking may work when the operating system or application recognizes its format. If all the data appears in one Excel column, import it with an explicit delimiter instead of repeatedly opening and resaving the file. In desktop Excel for Windows, use Data > From Text/CSV, select the file, and check the preview and delimiter setting before loading. Choose Tab if Excel has not detected it correctly.
Importing is especially important for identifiers and dates. The preview gives you a chance to check whether columns split correctly and whether values are being interpreted as intended. Where the import interface offers data type controls, set sensitive fields such as codes to text rather than allowing automatic number conversion. The exact controls can vary with Excel updates and the file’s encoding.
For other spreadsheet applications, look for an import option that lets you choose the separator. Select Tab, inspect the preview, and confirm that each expected field lands in its own column. This is safer than assuming that every program uses the filename extension or regional settings in the same way Excel does.
Choosing between CSV, TSV, and other options
Choose the format based on the receiving application’s specification, not simply on which option sounds familiar. CSV is a sensible choice when the recipient expects comma-separated data. TSV is a clearer choice when tabs are the required separator and the recipient accepts a .tsv file. A tab-delimited .txt file is also valid plain text, but its extension alone tells the recipient less about the structure.
- Use CSV when the receiving system expects commas or specifically requests CSV UTF-8.
- Use TSV when the system expects tabs and accepts the .tsv extension.
- Use tab-delimited .txt when the recipient asks for a text file or Excel’s built-in tab-delimited export is the required route.
- Keep an .xlsx copy when you need to preserve formulas, formatting, multiple worksheets, or other workbook features.
For repeated exports, a manual Save As process can be error-prone because it is easy to select the wrong sheet or format. Document the expected extension, delimiter, encoding, and date conventions for the workflow. If an automated system needs a specific combination, use a tested export process designed for that system rather than relying on a filename change alone.
Frequently Asked Questions
Can I save a tab-delimited file with a .csv extension?
Yes. Export it using Text (Tab delimited), then rename the file if the recipient requires .csv. Renaming changes the filename only, not the tab characters inside the file, so confirm the recipient can parse tabs.
Why does my CSV use semicolons instead of commas?
Excel can use the Windows regional list separator when creating delimited files. In some regional configurations that separator is a semicolon. This is separate from the tab-delimited Text format.
Does tab-delimited export save every worksheet?
No. Excel’s text export writes the active worksheet, not every sheet in the workbook. Export additional sheets separately if the recipient needs them.
Why does everything open in one column?
The program may be treating the file as comma-separated, or it may not have detected the tab delimiter. Import the file and explicitly select Tab, then check the preview before loading.
Does Excel’s CSV UTF-8 option create a tab-delimited file?
No. CSV UTF-8 concerns character encoding and ordinarily creates comma-separated output. Use the tab-delimited text format when tabs are required, and verify the encoding separately.
Related
- Analysis Report in Excel: How to Build a Useful Report
- Analysis Tab in Excel: Where It Is and What It Does
- Analysis Group in Excel: Where It Is and How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Workbook Sheet Limit: What Sets the Maximum?Modern Microsoft Excel for Microsoft 365 on Windows has no fixed maximum number of sheets in a workbook:…
- How to Embed a Video in PowerPointTo embed a video clip in PowerPoint for Microsoft 365 on Windows, open the slide where it should…
- Excel Cell Width in Inches: What the Number Really MeansExcel does not measure column width directly in inches: its width setting is based on the number of…
- Vacation Meal Planning Template Excel: Plan Every DayYes. A useful vacation meal planning template in Excel has a daily menu, a grocery list with quantities…
- Insert Rows in Excel Multiple Times: A Step-by-Step GuideTo insert several rows in Excel at once, select the same number of row headers as the number…
- Excel Slicer Slider: Range Filters and AlternativesNo—Excel’s standard slicers do not have a slider for choosing a continuous numeric range. For dates, a PivotTable…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.