Steps To Import CSV To Google Sheets - Full Details


Google Sheets is one of the best office tools provided by Google. Here you can create various sheets and charts, share them among your friends, colleagues and even save them on your system in various formats. It is just like Microsoft Excel, but Google Sheets allows multiple users to use and edit the sheets at once. Now we came across a query stating ‘can you import CSV to Google Sheets?’ Well, you can but it can be a little tricky. Not only this but, you can also add images to any particular cells of the spreadsheets. Don’t worry, we are here to help you with that. 

What All Can Google Sheets Do?

Not only for office work, but it can also even be used by students. You can create spreadsheets using templates for various tasks like to-do lists, annual budget, calendars, schedules, make plans, create invoices, time sheets, attendance charts, and many others. You can say it is all in one tool for managing your work among your team or group more reliably.

So let’s check out the steps to open CSV format files in Google Sheets.

Import CSV To Google Sheets

You can use two methods and both of them are similar whether you use the desktop application or the web browsers. One is with the saved CSV files on your system and another with the help of any URL for CSV file. Let’s see how.

Using CSV Files

1. Open Google Sheets and then click on File from the toolbar menu and select Import…

import CSV to Google Sheets

2. This will open the Import File window. Here go to the Upload tab.

upload CSV files to Google Sheets

Now select the CSV file from your computer that you wish to import. Or you can simply drag and drop the required files to this window.

If you wish you can also select the option to open CSV files and edit it or just as read-only. This can be done while selecting the files from your system. Click on the drop-down icon next to Open and select accordingly.

open csv file in google sheets

3. As the upload is finished, you will see various options, here keep everything as it is or if you wish to select any other option which depends on you. Then click on the Import data button.

Google sheets - import data

It will show you a message File imported successfully as soon as it is completed. To see the spreadsheet and the imported data, select Open Now link beside the File imported successfully option. That’s it.

Using The CSV URL

If you have any URL for online CSV files, then you can also use it to import the data with the help of a formula. Open Google Sheets, then on the first column of a new spreadsheet write =importData(“CSV URL”).

Import CSV to Google Sheets using URL

Like for example =importData(“http://example.com/work.csv”). As soon as you paste the URL Google Sheets will load all the data and then show it to you in the spreadsheet.

Export/Save CSV File From Google Sheet

Now if you wish to export or save any spreadsheet from the Google Sheets in CSV format so that it can be easy to share or use, then you can easily do that. Again go to Files and from there point the cursor on Download as.

save or Export Google Sheets as CSV

Then you will see various downloading format options, select Comma-separated values (.csv, current sheet). As you select it the file will start to download. You can also save the spreadsheets in other doc formats like .xlsx, .ods, .html and .tsv. This way you can easily create CSV file using Google Sheets.

Import Images To Google Sheet Cells

You can also add images to any particular cell of Google Sheets using a formula. Normally the images are added above the spreadsheet cells using the Insert image option, but using this method you can add images directly into the cell using an image URL. The method is similar to adding the CSV file Using URL.

Open Google Sheets, and then at click on any cell, then type =image(“Image URL”) For example =image(“https:// Dailyinfotech.com/2019/02/open-csv-file.png”) and hit enter.

add image to the cell of google sheets

You will then see the image inside the cell and you can do it in any of the cells you wish to.

The image will be inserted in a default small size, but if you wish to you can also use the given formula to change the size of an image or make any custom size. There are 4 options for changing the size of an image.

  • 1 – the default mode where the image is inserted into the cell as we already did above.
  • 2 – in this the image is stretched to fit inside the cells completely. For this click on the image and at the end of URL type 2 separated by a comma. For e.g. =image(“Image URL”, 2)add streched image to google sheets

  • 3 – Insert the image in the original size. For this, similarly on image formula write =image(“Image URL”, 3)
  • add image in its original size in Google Sheet cells

  • 4 – You can also add a custom size to the image. Again click on the inserted image and then add the numbers like in the given formula i.e. =image(“Image URL”, 4, height, width).add custom size image to google sheets cells

Here in the formulas after the URL the first number denotes the mode of the image. To add a custom size to the image you will have to use the 4th mode.


So these were the steps required to upload or import the CSV and all the data from it to Google Sheets and then use it as spreadsheets. Or save the Google Sheets spreadsheet data as CSV or other file formats. And even add images to the cell of Google Sheets with the help of URL and a formula. It is simple and you will learn it in no time. Still facing any problems? Let us know in the comments section below.



How You Feel About This Post

Like Our Content ? Enter Your Email and Get Daily Dose of Infotainment Stories


5G,2,Abaya,14,Adobe,2,Ahsan Khan,3,Aima Baig,5,Aiman khan,18,Alizeh Shah,9,Android,49,Apple,16,Apps,723,Ayesha Khan,1,Ayesha Umer,3,Ayeza Khan,23,Azekah,1,Bags,1,Bollywood,81,Breakfast,1,Bridal Dresses,11,Celebrities,1295,Children Prints,8,Cookware,1,Dresses,367,Facebook,56,Fashion,457,Fatima Effendi,1,Fawad Khan,4,Firefox,4,Fiza Ali,2,Food,29,Gadets iPhone,8,Gadgets,930,Gents,1,Gents Dress,26,Gmail,10,Google,68,Google Assistant,8,Google Duo,8,Google Gboard,7,Google Maps,19,Google Photos,8,Google Pixel,2,Google Play Store,3,Hair Styles,12,Hania Amir,9,Hareem Farooq,3,Health,84,Hera Mani,7,Hijab,3,Hina Altaf,4,Hollywood,9,How To,310,HTC,5,Huawei,152,Humayun Saeed,1,Iman Aly,1,Infinix,16,Instagram,54,iOS,63,Iqra Aziz,18,Iqrar Ul Hassan,11,Kinza Hashmi,8,Komal Rizvi,2,Ladies Cloths,200,Laptops,1,Lenovo,13,LG,24,Mac,5,Mahira,18,Makeup,15,Mathira,2,Mawra Hocane,8,Maya Ali,16,Mehndi Styles,28,Mehwish Hayat,12,Meizu,19,Microsoft,5,Minal Khan,15,Mix topics,927,Mobilink,15,Momal Sheikh,3,Momina Mustahsen,2,Motorola,20,Music,36,Nadia Hussain,1,Naimal,2,Neelam Muneer,4,Neelam Usaf,1,Netflix,3,Nida Yasir,9,Nimra Khan,6,Nokia,43,Nubia X,6,Office,1,OnePlus,16,Oppo,60,Pak Army,1,Pixel,1,PTCL,3,Qmobile,2,Realme,19,Reema Khan,8,Resham,1,Saba Qamar,13,Sabeeka Imam,1,Sabeena,1,Saboor Aly,5,Sadaf kanwal,7,Sajal Ali,14,Samsung,160,Sana Fakhar,2,Sana Javed,1,Sanam Baloch,4,Sanam Jung,2,Sania Mirza,1,Saniya Shamshad,1,Sarah Khan,6,Shawls,3,Shoes,14,Showbiz,1439,Sidra Batool,1,Skin Care,9,Skype,6,Snapchat,12,Sony,11,Sonya Hussain,2,SoundCloud,1,Sports,74,Startups,2,Summer Outfits,61,Syed Jibran,4,Tech,1870,Techno,8,Telegram,4,Telenor,10,TikTok,7,TV,4,TV Series,153,Twitter,20,Uber,1,Ufone,3,Urwa Hocane,7,Videos,140,Vivo,58,W,1,WhatsApp,80,Windows,101,Winter Collection,1,WordPress,1,Xiaomi,100,YouTube,23,Zara Noor,14,Zenfone,2,Zong,4,
Daily InfoTainment: Steps To Import CSV To Google Sheets - Full Details
Steps To Import CSV To Google Sheets - Full Details
Daily InfoTainment
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy