google spreadsheet paste as CSV code example
Example: google sheets paste comma delimited text into separate cells
# Process:
1. Open a Google Sheets spreadsheet
2. Paste the data you want to split into columns
3. Immediately after pasting, in the bottom right corner of your data,
click the Paste icon
4. Click Split text to columns. Your data will split into different
columns.
5. To change the delimiter, click the Detect Automatically dropdown menu.
# Note, for whatever reason, Google Sheets doesn't have an option to
# split tab-delimited data...