In this article:

How to Convert CSV to Google Sheets (2024 Guide)

May 8, 2024

How to Convert CSV to Google Sheets

Converting a CSV file to a Google Sheets format is a straightforward process. Here are the steps you can follow to do this:

Option 1: Upload and Open with Google Sheets

1. Go to Google Drive: Navigate to your Google Drive (drive.google.com) and sign in if you haven't already.

2. Upload your CSV File: Click on the "New" button on the left side, then select "File upload". Choose the CSV file from your computer that you want to convert to Google Sheets.

how to convert csv to google sheets

3. Open with Google Sheets: Once the upload is complete, right-click on the uploaded CSV file in your Google Drive. Select "Open with" > "Google Sheets". Google Sheets will automatically convert the CSV file into a Google Sheets format.

convert csv to google sheets

Option 2: Import CSV Data into an Existing Google Sheet

1. Open a New Google Sheet: Go to Google Sheets (sheets.google.com) and open a new spreadsheet.

2. Import CSV Data: Click on "File" > "Import" > "Upload", and then select or drag the CSV file you want to import.

how can i convert csv to google sheets
how do i convert csv to google sheets

3. Choose Import Options: You'll be prompted with several options on how you want to import the data. You can choose to create a new sheet, replace the current sheet, or append the data to the current sheet. Choose the option that best suits your needs.

csv to google sheets

3. Adjust Settings if Needed: Depending on your CSV file's structure, you might need to adjust the delimiter (comma, semicolon, etc.), which Google Sheets usually detects automatically. However, you can change this in the import settings if necessary.

Sometimes, when you import CSV files, the formatting might not transfer perfectly, especially for dates and numbers. You may need to adjust these manually.

We hope that this article has helped you and given you a better understanding of how to convert CSV to Google Sheets. If you enjoyed this article, you might also like our comprehensive formulas list for Google Sheets and how to consolidate data in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->