How To Import One Google Spreadsheet Into Another


Google Spreadsheet is a very powerful tool. Those are commonly used for our official or personal purposes. Google sheets can be easily and safely managed online with our Gmail Account, and which can be accessed from our Google Drive, about which I had already posted in one of my articles.

It has too many features, but most of people use with its very limited potential. We will discuss one simple one, about which we all think of but technically don't know how to do it. It is about "how could we view data from one spreadsheet into another one".

Before getting into how to import one spreadsheet data into the another one, Let us know why is it required to import the sheets.

Import Range

Why Google Spreadsheet need to be imported
At the workplace, we work on the several Google spreadsheets, as all the spreadsheets can not be the same, and we always required some amount of data from one sheet to make the analyzation reports, we can also import multiple spreadsheets into one, for preparing multiple reports. But importing multiple spreadsheets may slow down the spreadsheet a bit. 

Importing Data from another sheet using "import range"
Google Spreadsheet has a number of functions, to make our work simpler. Any kind of calculations can be done in Google Spreadsheet. Array, Text, Filter, Lookup, Parser etc. 

Which I will be posting in details in my next articles. You can follow my website for those updates.

Amongst all the functions, we will here be looking into, how to import one spreadsheet data into the another one.


Function 

=ImportRange
Import range

With the use of "=importrange", we can import multiple spreadsheet data. So now the question is how to just mention "=importrange" another sheet can get imported. So for importing a particular spreadsheet, we have to make it identical, we need to mention the spreadsheet key, name, and range.


For an instance
=ImportRange("SpreadsheetKey","Sheet!Range")

Assume we have a document, called "students_marks", and this data need to be imported into the other blank document in which we are supposed to add some more data along with the this imported one.


Example Spreadsheet "student_marks"



Import range key

Now the spreadsheet key which can be seen in the above image, need to be copied and should be provided in the blank new document (in which this data to be imported).

Import range

Next step is to mention the Sheet name and the range.
According to the provided document "student_marks",  the final function should look like the below image. 


=IMPORTRANGE("1CxxYXUEqrQ0ZNo96RaR40DXl3dUei0cQLTjMDadB7f8","students_Marks!A1:G8")


Import Range

And now as we can see we have imported the "student_marks" data into "Untitled Spreadsheet (Blank Document)".

Hoping this tutorial could be helpful . Do let me know your feedback into the comment section or any queries. will be happy to help out.

Useful Google Spreadsheet Shortcuts Keys

Google Spreadsheet Shortcuts Keys

Why shortcuts are important

Now a days because of the heavy work load we don't have an option other than fasten up our work, here keyboard shortcut keys plays an important role in our working life. Its being very essential to use those to Simplify our work and fasten it up, as  most of us generally use google spreadsheet for our office work regularly. Here lets check out some shortcut keys or commands.

-->
Common ActionsShortcut Keys
Select columnCtrl + Space
Select rowShift + Space
Select allCtrl + A, Ctrl + Shift + Space
UndoCtrl + Z
RedoCtrl + Y, Ctrl + Shift + Z
FindCtrl + F
Find and replaceCtrl + H
Fill rangeCtrl + Enter
Fill downCtrl + D
Fill rightCtrl + R
Save (Every change is saved automatically in Drive)Ctrl + S (Not Required)
OpenCtrl + O
PrintCtrl + P
CopyCtrl + C
CutCtrl + X
PasteCtrl + V
Paste values onlyCtrl + Shift + V
Show common keyboard shortcutsCtrl + /
Insert new sheetShift + F11
Compact controlsCtrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + K
Select input toolsCtrl + Alt + Shift + K

-->
Cell FormattingShortcut Keys
BoldCtrl + B
UnderlineCtrl + U
ItalicCtrl + I
StrikethroughAlt + Shift + 5
Center alignCtrl + Shift + E
Left alignCtrl + Shift + L
Right alignCtrl + Shift + R
Apply top borderAlt + Shift + 1
Apply right borderAlt + Shift + 2
Apply bottom borderAlt + Shift + 3
Apply left borderAlt + Shift + 4
Remove bordersAlt + Shift + 6
Apply outer borderAlt + Shift + 7
Insert linkCtrl + K
Insert timeCtrl + Shift + ;
Insert dateCtrl + ;
Format as decimalCtrl + Shift + 1
Format as timeCtrl + Shift + 2
Format as dateCtrl + Shift + 3
Format as currencyCtrl + Shift + 4
Format as percentageCtrl + Shift + 5
Format as exponentCtrl + Shift + 6
Clear formattingCtrl + \

-->
Spreadsheet NavigationShortcut Keys
Move to beginning of rowHome
Move to beginning of sheetCtrl + Home
Move to end of rowEnd
Move to end of sheetCtrl + End
Scroll to active cellCtrl + Backspace
Move to next sheetCtrl + Shift + Page Down
Move to previous sheetCtrl + Shift + Page Up
Display list of sheetsAlt + Shift + K
Open hyperlinkAlt + Enter
Open ExploreAlt + Shift + X
Move focus out of spreadsheetCtrl + Alt + Shift + M
Move to quicksum(when a range of cells is selected)Alt + Shift + Q
Move focus to popup (for links, bookmarks, and images)holding Ctrl + Alt, press E then P
Open drop-down menu on filtered cellCtrl + Alt + R
Open revision historyCtrl + Alt + Shift + G
Open chat inside the spreadsheetShift + Esc
Close drawing editorShift + Esc

-->
Notes and CommentsShortcut Keys
Insert/edit noteShift + F2
Insert/edit commentCtrl + Alt + M
Open comment discussion threadCtrl + Alt + Shift + A
Enter current commentholding Ctrl + Alt, press E then C
Move to next commentholding Ctrl + Alt, press N then C
Move to previous commentholding Ctrl + Alt, press P then C


-->
MenusShortcut Keys
File menuGoogle Chrome: Alt + F,
Rest of the browsers: Alt + Shift + F
Edit menuGoogle Chrome: Alt + E,
Rest of the browsers: Alt + Shift + E
View menuGoogle Chrome: Alt + V,
Rest of the browsers: Alt + Shift + V
Insert menuGoogle Chrome: Alt + I,
Rest of the browsers: Alt + Shift + I
Format menuGoogle Chrome: Alt + O,
Rest of the browsers: Alt + Shift + O
Data menuGoogle Chrome: Alt + D,
Rest of the browsers: Alt + Shift + D
Tools menuGoogle Chrome: Alt + T,
Rest of the browsers: Alt + Shift + T
Form menu (present when the spreadsheet is connected to a form)Google Chrome: Alt + M,
Rest of the browsers: Alt + Shift + M
Add-ons menu (present in the new Google Sheets)Google Chrome: Alt + N,
Rest of the browsers: Alt + Shift + N
Help menuGoogle Chrome: Alt + H,
Rest of the browsers: Alt + Shift + H
Accessibility menu (present when screen reader support is enabled)in Google Chrome: Alt + A,
Rest of the browsers: Alt + Shift + A
Sheet menu (copy, delete, and other sheet actions)Alt + Shift + S
Context menuCtrl + Shift + \


-->
Insert or Delete Rows or ColumnsShortcut Keys
Insert row aboveGoogle Chrome: Alt + I, then R,
Rest of the browsers: Alt + Shift + I, then R
Insert row belowGoogle Chrome: Alt + I, then W,
Rest of the browsers: Alt + Shift + I, then W
Insert column to the leftGoogle Chrome: Alt + I, then C,
Rest of the browsers: Alt + Shift + I, then C
Insert column to the rightGoogle Chrome: Alt + I, then G,
Rest of the browsers: Alt + Shift + I, then G
Delete rowGoogle Chrome: Alt + E, then D,
Rest of the browsers: Alt + Shift + E, then D
Delete columnGoogle Chrome: Alt + E, then E,
Rest of the browsers: Alt + Shift + E, then E

-->
FormulasShortcut Keys
Show all formulasCtrl + ~
Insert array formulaCtrl + Shift + Enter
Collapse an expanded array formulaCtrl + E
Show/hide formula help
(when entering a formula)
Shift + F1
Full/compact formula help
(when entering a formula)
F1
Absolute/relative references
(when entering a formula)
F4
Toggle formula result previews
(when entering a formula)
F9
Resize formula bar
(move up or down)
Ctrl + Up / Ctrl + Down


-->
Screen Reader SupportShortcut Keys
Enable screen reader supportCtrl + Alt + Z
Read columnCtrl + Alt + Shift + C
Read rowCtrl + Alt + Shift + R

9 Best Ways To Earn Money Online


9 Best Ways To Earn Money Online

There are Plenty of ways to earn money online. Here we will discuss a few good ones, which really works great and are very effective. Again that depends on the option which we are interested in. We all are good at some thing, so from below options we can definitely find one of them. Let us get into this and take a closer look of all the options.

Ways To Earn Money Online



1. Domain Buying And Selling

Buy and Sell Domain
Earning money by domain buying and selling is being very popular, as the efforts are minimum. Anyone can do that apart from working on their regular jobs. It just like being investing in a business and earning being a Sleeping partner.

Though are some expenses involved in buying domain names. But it's quite affordable for anyone. There are plenty of websites where we can buy domain names godaddy.com, namecheap.com, bigrock.com and much more. Where we can easily buy domains names with minimum investment. It takes just a few minutes to do it. And we can own a domain for minimum one year.

There is some risk involved in it as there is no guarantee that someone likes to purchase the domain name we which we have or we can make some huge profit out of it. Obviously, some risk will always be involved in earning some money.

The should select a domain name which should be trendy, new , simple so that we can get buyers easily for it. Here some creative skills required while thinking of a good and interesting domain name. We can get some idea by browsing the internet. There are chances that the good names are already been registered. But still, there would be a lot of domain which is not. Stay focused and select the unique domain name.



2. Selling Goods

Earn Money Online

We can sell goods online, whether its old are new ones on some e-commerce websites like Amazon, Flipkart, Snapdeal etc. are popular amongst all. For selling goods, we need to register as a seller on these online marketplaces.

If you are selling old goods then there would not be any investment. However, if you are Selling New goods might have to invest some money to purchase the goods. You may need to give your identity card and complete verification process to register as a seller. But now the question arises in our mind is why someone will purchase goods from us online? 

The buyers should be attracted to the goods which we are selling online. For that generating good reviews by selling good products at reasonable prices could be the only solution. It might take some time to get a good rating and good reviews from the customers. Patience will be the key here. Advertising our products in other websites will enhance our sale.

Millions of people are selling goods on such e-commerce sites daily and earn good money legally, we are not the only one who are thinking of the same.

3. Sell Photos Online

Earn Money Online
Selling photos online is also quite popular these days. A lot of us have a hobby of taking photographs. Then why not to earn some money by it, Let it be our profession too. If we are able to take good photographs then we can sell them online at sites such as Shutter Stock, graphicstock, istockphoto etc.

If we talk about the investment all we need is a camera which can take HD (High Definition) photos, having DSLR cameras are being too common these days. We can upload our photos from the photo library and monetize our image library, this doesn't take too much time. Steps are quite easy. Once we register on the above sites, we can understand it quite easily. 

There are plenty of people who likes to buy the photographs to laminate it and decorate it on their wall. And many more purposes are there to buy. So we can get a buyer easily if the photographs are good enough. Listing photos on reputed sites can make a good income out of it.


4. Writing an E-Book

Earn Money Online
Most of the people have the hobby of writing stories, poems etc. If that is the case then the written content can we self-published as an e-book and sold it online.
These writing skills can make a good profit to us. If you don't believe it, give a try. Most of the writers are earning through it. In fact, we don't have to make a lot of investment to do so. If you are looking for giving a try for free, then start writing with MS-Word and convert that file online into .pdf. an e-book will be ready in few minutes.

Publishing e-book on sites like amazon makes the process more quick and easy. Nowadays writers usually give their first e-book free online so that could reach out to all the readers. and to get a lot of downloads and good reviews, once they get good reviews on amazon then won't be providing it for free from the next time, the readers gain some confidence on the author and they do not hesitate to buy the e-book going forward. This is one of the great advertising skill.

5. Online Tuition

 Sharing our knowledge could make a good money for us. We all are good at something, So why not that knowledge to be a medium of the profit and earn while being at home. Just required a computer with a webcam, with the help of a few software's you can teach online
like WebexGoToWebinar is good options for online tuition.

These are not expensive at all, spending some money gives you all the features of the software. Skype or yahoo messenger can also be a great option if you are looking for a free one. I personally recommend Skype.

It is extremely easy to set them up and you can start taking online tuition in a short time. And earning good and decent money. Tuition like painting, yoga, guitarists, fitness training and much more.... whatever we are good at. People love to take online tuition as they hesitate going out after being too busy in the schedules.

6. Affiliate Marketing

Affiliate marketing is also very popular. We can put Affiliate links or banners on our website or blog. This is the click based income generator.

If someone clicks the add. and purchases something we will get some commission out of it. The investment here is also almost nothing. we need to have a website or a blog It is strongly recommended to have our own domain name, which we can get quite easily with very small investment and should have a good traffic on the website or blog,  it is very obvious that to get some traffic it will take some time. As the blog and website should reach to the readers.

We can monetize the traffic on your website but you will need to register for an affiliate banner. We can partner and get affiliate links from websites such as commission junction, Share Sale and Link share.

7. Blogging

Earn Money Online
If you like to write stories or poems you can create a blog and it's absolutely free by using blogger.com. If you want to create a professional blog we must use WordPress.com or Wordpress.org. Create a blog on free blogging sites to try it on and when u get some idea of it.. then think about paid sites subsequently. We need to make sure one thing that the content has a good quality and unique. Only if the content is good enough people will like to read it and will see ads on the blog. We have to link the blog with Adsense in order to get paid as commission for the views and clicks on the advertisement banner we put on our blog.


8. Freelancing

Millions of people are earning money using their talent even with being in their regular job by becoming a freelancer. Photographer, writer , marketer, video Editor, translator, there are several jobs being provided in freelancing.com, There are plenty of sites like freelancer, Up work, and Fiverr.

Registration is free on these sites and requires no investment at all. Goodwill is quite important into these sites to get enough work. And the quality of work we produce gives makes the Goodwill. Delivering the work on time makes the client feel very happy. Goodwill will come overnight. Initially, the price may be low, but we can always start quoting a bit low for the getting the jobs, as we don't have a good rating and experience. As we kept on deliver good work and receive good reviews, then we can start quoting higher for the next project. And the client will pay happily after looking at the ratings and reviews you get from the older clients.

9. Upload Videos On YouTube

Creating and uploading videos on YouTube can make some money. Videos should contain some unique content and be interesting too so that it can attract the viewers. Like if you sing well then record videos of your own. Tutorials and solving some technical issues videos are also being very popular on YouTube. Link them with Google Adsense once we get enough viewers and make money of the uploaded videos for each and every view. We can record the video from your video camera. mobile phone or computers. Making a slide show in presentation document and converting them into videos later can also be a good way.
The video content should be edited properly so that the viewers find it interesting. We can do that online or offline, there are plenty of freeware tools available for doing the same.

We have to keep some patience after uploading videos to get enough views or traffic. Some people become stars overnight, while for others it can take some time. But good content is always appreciated by people.


Also Read : How to Earn Money Through Fiverr