Skip to content

Instantly share code, notes, and snippets.

@smram

smram/howto_paste_tsv_google_sheets

Created February 9, 2021 19:36
Show Gist options
  • Save smram/ba244f06ee8560c786a3641bc486efe5 to your computer and use it in GitHub Desktop.
Save smram/ba244f06ee8560c786a3641bc486efe5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
howto_paste_tsv_google_sheets
Q: How to paste tab-separated data into Google Sheets
Problem: Google sheets automatically parses CSV data into columns on paste. It doesn't work with TSV - cannot detect tab as a separator automatically, and I cannot figure out how to enter tab as a custom separator.
Solution:
1. Data -> Cleanup Data -> Trim whitespace.
2. Data -> Split text into columns -> Choose space as the separator
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment