If you are looking for ways in which you can create a CSV file in Google Sheets or want to How to open a CSV file in Google Sheets then my this tutorial article has what you are looking for!
CSV files are used to import and export items and export report in most cases. I hope this tutorial will help you to solve your problem. So read on.
[top]
How to Import and Open a CSV File in Google Sheets
To upload your CSV to Google Sheets, you’ll need to download it to your device and then upload it.
You can open these kinds of files in Google Sheets by following the steps I have summarized the steps for you below:
- You will need an old or new Google Sheets
- To create a new spreadsheet, you need to go to Google Sheets ( https://docs.google.com/spreadsheets/ ) and click on the option that says “Blank” under “Start a new spreadsheet” menu.
- After opening it, you can change its name. In my case, I named it “CSV File in Google Sheets – Teqtog”
- Now go-to File>Open from the sheet menu bar options or use the keyboard shortcut
Ctrl+O
- A dialogue box that says “Open a file” will open up on your screen and, there, you will see find multiple windows to go to. Select the last window which is called “Upload” from that message box.
- Select the file that is on your computer.
- After you have chosen to select a file from your computer; a new window will be created that will be called the “Import file” window. In that window, click on the green-colored button which says “Import data”.
- If your file has been imported successfully, then you will be shown a message that says “Open now”. You can click on this to open your CSV file in a table format.
- Done! you made it. Now the sheet should look like this sheet.
Uploading a CSV File to Google Drive
You also have the option of adding a CSV file to your Google Drive and then having it open in Google Sheets. I have laid out the steps below so that you can do exactly that.
- First, you need to open your Google Drive – obviously.
- Select the option that says “New” on the top left corner of the window.
- From the “New” drop-down menu, select the “File upload” option.
- You will be given the option to browse for your CSV file from your computer; so, using that, select the file which you want to upload from your device.
- Select the “Open with Google Sheets” option so that the CSV file opens in Google Sheets.
- And, Google Sheets will display your CSV file as a new working sheet.
How to Make your CSV File More User-Friendly
There are a few ways in which you can make your CSV file more user-friendly so that it will be much easier for you to work with them; and, here are some of them:
- Remove any unwanted row
- Similarly, remove any unwanted columns
- Apply the “concatenate formula” to clean up your cells.
How to use the Concatenate Formula: Combining Columns
There can be some instances where there are two separate columns for different information. For example, banks use two different columns to put the information on debits and credits.
However, this format is not standard for a spreadsheet budget.
You can overcome this problem by combining information into one column.
To do this, you need to add a new column by selecting “insert new column (Insert 1 left).
Afterward, you can apply the “concatenate formula”. The concatenate formula basically helps you combine data from multiple columns. This means that you do not have to painstakingly copy, paste or retype everything manually.
Below is the entire guideline on how you can use the concatenate formula to combine and clean up cells:
- Add a new column on the left side of the debit column.
- Insert the following formula for concatenating in the cells of your new column.
Remember that the syntax of the formula is a little different for the debit data and the credit data.
- For the debit data, the syntax of the formula is:
=CONCATENATE(TEXT(C2,"#.00"),TEXT(D2,"#"))
- For the credit data, the syntax of the formula is:
=CONCATENATE(TEXT(D2,"#.00"),TEXT(C2,"#"))
For transferring information from the debit column, use the first formula and, similarly, for transferring information from the credit column, apply the second formula. And as a result, you will have all of the data combined into one, single column.
And that is all there is to it, on how to open a CSV file in Google Sheets. I hope my tutorial was able to help you out.
You may Love to Read More Google Sheets Tutorial Articles on:
How To Export As A CSV File From Google Sheets
How to Automatically Sort in Google Sheets (3 Easy Ways to Auto-Sort)
How to Count Colored Cells In Google Sheets (Step-by-Step)
How to Freeze Rows in Google Sheets (Quick & Easy Shortcut Methods)
