Import Multiple CSV Files Into Google Sheets (2024 Update)

In this tutorial, we will show you exactly how to import multiple CSV files into Google Sheets in just a few steps. Simply follow the steps below.

‍

Importing Multiple CSV Files Into Google Sheets

Follow the process below to add multiple CSV files into your Google Sheets.

1. Create a New Google Sheet

Click the "+" button in Google Sheets to create a new, blank spreadsheet. This is where your CSV files will be imported.

‍

2. Access the "File" Menu to Import Data

In the Google Sheet, click the "File" menu at the top left of the screen. This will allow you to import files. 

‍

3. Select "Import" to Upload Your CSV Files

From the "File" menu, select "Import." This will give you the option to upload CSV files from your computer.

‍

4. Upload the First CSV File 

Click on "Upload," then click "Browse" to choose the first CSV file from your computer. It will be imported into your Google Sheet.

‍

‍

Select the CSV file you want to import, then click "Open."

‍

5. Set the Import Location for the File

Choose where to place the imported data. Click on "Create new spreadsheet" to open the drop-down list.

‍

‍

Select "Replace current sheet" for the first file. Then click “Import data.”

‍

6. Repeat the Import Process for Each Additional CSV File

Repeat steps 4-6 for every CSV file. Each one can go into a new sheet in the same Google Sheets document by clicking "Insert new sheet(s)" then selecting "Import data."

‍

‍

After importing, you can open the sheet by clicking "Open now »."

‍

‍

We hope that you now have a better understanding of importing multiple CSV files into Google Sheets. If you enjoyed this article, you might want to check our articles on how to make a supply and demand graph in Google Sheets and how to insert data from a picture into Google Sheets.