How to Add a CSV as a New Tab in Google Sheets

0:00 Sometimes when we're working with data inside of Google Sheets we have a CSV file we want to add to our entire spreadsheet file, but as a new tab. So we're working on monthly sales and we're compounding them. We want to add monthly sales, but as a new tab. going to go to File, Import . Here we have four tabs here. We're going to click Upload. We're going to upload from our current drive. Once we have our CSV selected, we'll click and drag it in here. It'll show up as blue. And then we have a few options. We don't want to create a new spreadsheet . That will create an entire spreadsheet file. Insert New Sheets is going to create a new tab inside of our Google Sheet with our CSV file. We don't want to replace our spreadsheet. We don't want to replace our current sheet and we don't want to append to current sheet. We also don't want to replace the data at the selected cell. The one you want to do, if you want to create a new tab with our CSV file information is insert new sheets. We have some other options here like separator type. Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas How To Add Columns in Google Sheets Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas How to Copy a Tab in Google Sheets

0:46 We can select , we can also select a custom one. We can convert or not convert our text to numbers , dates, and formulas. Once we have all of the items selected that we want to insert new sheets, convert text, and detect automatically. Click the green button, import data . And it'll create a new tab with the name of the CSV file as the name of the tab. You can rename this tab by double clicking on it. Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas Getting Started in Google Sheets Spreadsheet Management Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas How To Make a Table in Google Sheets