Convert TSV to CSV on Mac and Windows — Without Terminal or Import Wizards

Converting a TSV file to CSV on Mac typically gets solved by pointing people to Terminal commands. On Windows, the answer is usually a PowerShell script or Notepad++. Both of those work — but neither is the fastest option if you have a file in front of you right now.

The browser converter approach is the same on both platforms: open the tool in Safari or Chrome, drop your file, download the CSV. No commands, no wizard, no install. This guide also covers the native platform options for when you need them.

Converting TSV to CSV on Mac — Three Options

Option 1: Browser tool (fastest)

Open the TSV to CSV converter in Safari or Chrome on your Mac. Drag your .tsv file into the drop zone (or click to select it). Click "Convert to CSV" and then "Download CSV." The entire process runs in the browser tab — no upload to any server, nothing installed. Safari, Chrome, and Firefox all work correctly on Mac.

Option 2: Numbers

Numbers handles TSV natively. Open the .tsv file in Numbers (right-click > Open With > Numbers if it does not open automatically). Numbers detects the tab delimiter and shows the data in columns. To export as CSV: File > Export To > CSV, leave the default settings, and save. The resulting CSV opens in Excel, Google Sheets, or anywhere else without any configuration.

Option 3: LibreOffice Calc

Free download, available on Mac. Drag the .tsv file onto the Calc window. LibreOffice auto-detects tab-separated files and shows an import dialog. Confirm the tab delimiter, finish the import, then File > Save As and choose CSV. LibreOffice gives you more control over encoding and quoting than Numbers.

The Mac Terminal Approach — Useful But Incomplete

If you prefer the Terminal, the sed approach is fast:

sed 's/	/,/g' data.tsv > data.csv

And the Python approach handles quoting correctly:

python3 -c "
import csv, sys
r = csv.reader(open('data.tsv'), delimiter='\t')
w = csv.writer(open('data.csv', 'w', newline=''))
w.writerows(r)
"

The limitation of sed: it does not add CSV quoting for fields that contain commas. If your TSV has an address field like "Portland, OR" or a description with a comma, the sed output will have a malformed column. The Python one-liner solves this but requires knowing how to paste multi-line commands into Terminal.

For most TSV files with clean data, sed works fine. For anything with commas in the field values, use the browser tool or Python.

Sell Custom Apparel — We Handle Printing & Free Shipping

Converting TSV to CSV on Windows — Three Options

Option 1: Browser tool (fastest)

Open the converter in Chrome or Edge on Windows. Drop the file, download the CSV. Same steps as Mac — the tool is cross-platform. Edge (which comes pre-installed on Windows 10 and 11) works fine.

Option 2: Excel import wizard

This is the native Windows approach and produces a correct CSV — it just takes more steps. Open Excel, go to File > Open > Browse, change the filter to All Files, select the .tsv file. The Text Import Wizard opens — choose Delimited, select Tab, finish. Then File > Save As and choose CSV. If you deal with TSV files regularly and already have Excel open, this is a reasonable workflow.

Option 3: Rename and import

Rename the .tsv file to .txt (right-click > Rename in File Explorer, change the extension). Double-click the .txt file — if Excel is the default for .txt, it will launch the import wizard automatically. Select Tab as the delimiter. Save as CSV. This approach skips the "All Files" filter step and can be slightly faster.

The Windows PowerShell Approach — For Automation

PowerShell can convert TSV to CSV with proper quoting using the Import-Csv and Export-Csv cmdlets:

Import-Csv -Path "data.tsv" -Delimiter ([char]9) | Export-Csv -Path "data.csv" -NoTypeInformation

[char]9 is one way to pass a tab character in PowerShell without the backtick-t syntax (which can cause issues in some editors and scripts). -NoTypeInformation prevents PowerShell from adding a #TYPE comment line at the top of the output.

This works correctly for files with commas in field values — PowerShell's Export-Csv adds proper quoting. For automation scripts that process multiple TSV files in a loop, this approach scales well.

For a one-off conversion, the browser tool is faster. For processing 50 TSV files in a folder, PowerShell makes more sense. Pick based on your frequency of use.

Changing the CSV Delimiter — Mac and Windows Differences

One related issue: some regions use semicolons instead of commas as the CSV delimiter. Germany, France, and other countries where the comma is used as a decimal separator often produce "CSV" files with semicolons.

On Windows, the CSV delimiter Excel expects is controlled by the system regional settings (Control Panel > Region > Additional Settings > List Separator). If you are on a system configured for a European locale, Excel may expect semicolons and interpret comma-delimited files incorrectly.

On Mac, Excel ignores system regional settings and always defaults to the comma as the CSV delimiter. This inconsistency causes problems when sharing files between Mac and Windows users in different countries.

The browser converter always produces standard RFC 4180 CSV with commas — the international standard. If you need a semicolon-separated output, you would need to run a second find-and-replace after conversion.

Frequently Asked Questions

How do I convert TSV to CSV on a Mac without Terminal?

Open the browser-based TSV to CSV converter in Safari or Chrome, drop your file, and download the CSV. Alternatively, open the file in Numbers (right-click > Open With > Numbers), then export as CSV via File > Export To > CSV. Both methods require no Terminal commands.

How do I convert TSV to CSV on Windows without PowerShell?

Use the browser converter in Chrome or Edge — drop the file, download the CSV, done. If you prefer to stay in Excel: open Excel, use File > Open > Browse, change the file filter to All Files, select the .tsv file, choose Tab as the delimiter in the import wizard, then Save As CSV.

Does the browser TSV to CSV converter work on Windows 10?

Yes. It works in Chrome, Edge, and Firefox on Windows 10 and 11. No plugin or download needed — just open the tool in a browser tab, drop the file, and download the CSV.

What is the best free TSV to CSV converter for Mac?

The browser-based converter at WildandFree Tools works in Safari and Chrome on Mac without any install. It handles proper RFC 4180 quoting, runs locally without uploading your data, and produces CSV compatible with Excel, Numbers, and Google Sheets. For files already on your Mac, Numbers also exports TSV as CSV natively via File > Export To > CSV.