How to☝️ Paste CSV Data Into Columns in Google Sheets

To paste CSV data into rows and columns in Google Sheets, open your CSV file in Notepad, copy the comma-separated values into Google Sheets, click the Data tab, and choose “Split text to columns.”

If you have Microsoft Excel or other spreadsheet software installed on your hardware, you can just open the CSV file, copy the data using the Ctrl + C shortcut, drop the comma-separated list into a Google Sheets file, and call it a day.

However, if that’s not the case (or you can’t get the copy and paste method to work), stick around to learn how to do that same thing both on PC and Mac using your default notepad app.

How to Quickly and Easily Paste CSV Data Into Columns [Step-by-Step]

The whole process is pretty straightforward and takes less than a minute to go through. To quickly paste CSV data into Google Sheets, here’s what you need to do:

  1. Locate the CSV file you want to move to Google Sheets on your hard drive and right-click on it to pull up the contextual menu.
  2. Click “Open with.
  3. Select Notepad or any other text application capable of processing .txt files.

How to Quickly and Easily Paste CSV Data Into Columns

  1. Select the entire delimiter-separated list using the Ctrl + A shortcut and copy the values to the clipboard by pressing Ctrl + C.

Notepad in Google Sheets

  1. Copy the values into an empty Google Sheets file using the Ctrl + V shortcut.

The Data

  1. Navigate to the Data tab.
  2. Choose “Split text to columns” from the drop-down menu.

Split text to columns

Once there, Google Sheets will automatically break up the delimiter-separated values (regardless of whether you use a comma or semicolon as a separator) into columns.

Having followed all the steps, we get a neat list of cities with no formatting issues whatsoever.

Data in Google Sheets

And that’s how you do it!

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X