Something I learned today:

You can just paste the text into your spreadsheet. Go to Data > Split text to columns > select your formatting option.

That's super helpful and solved my issue!