transfer-information-from

Do you often manually pass data from a form to a spreadsheet?

With this tip, you won’t have to do it anymore.

All data from Google Forms can be automatically transferred to a Google spreadsheet . Learn how:

A Google Form will then open in a new tab. Create the form as normal.

When you do this, you will see that Google Sheets will create a tab in your spreadsheet with the form responses:

12. Import updated financial data transfer-information-from

This is a more specific feature, but middle east mobile number list it saves a lot of time for those who follow the financial market.

If you need to include stock price information in your spreadsheets, there is a command in Google Sheets that does it automatically.

This command is the =GOOGLEFINANCE . Next, look at the parameter you need to use:

=GOOGLEFINANCE(company, “price”, “start date”, “end date”, “frequency”)

An example, using Google’s own actions, is:

GOOGLEFINANCE(“GOOG”, “price”, “1/1/2014”, “12/31/2014”, “DAILY”)

13. Transfer an RSS feed to your spreadsheet transfer-information-from

Another specific, but also very useful, feature helps you build credibility and prestige is the automatic transfer of an RSS feed to the spreadsheet.

With the IMPORTFEED function , you can import recent posts from a website into your document.

This is how to use IMPORTFEED:

IMPORTFEED(“URL”) .

An example using Google’s own feed would be:

14. Standardize the text format

Often when importing data, the text angola latest email list formats become out of order (for example, DATA, dAtO, dato).

To standardize this format, you can use some functions like:

=UPPER(A1 ): leaves all letters uppercase.
=LOWER(A1) : Leaves all letters in lowercase.
=PROPER(A1) : capitalizes the first letter, lowercases the rest.

15. Hide the columns transfer-information-from

If you want to stop seeing some data in your spreadsheet, without deleting it, simply hide the column or row that corresponds to the information .

Right click on the row or column and select the ” hide row ” and ” hide column ” options respectively.

If at any time you want to see the column again, click on the arrow that was generated in its place:

16. Format the lines with colors

Do you want a quick and easy way to improve the design of your spreadsheet?

Look for the ” Alternating colors ” function in the “Format” section of the menu.

When you select this option, Google Sheets will automatically apply a color alternating rule to the rows.

See below:

With “Alternating colors”, your spreadsheet will look something like this:

17. Create a small chart in a cell transfer-information-from

To display your numbers quickly and visually, Google Sheets allows you to create small charts in cells .

If you want to create only one row, simply enter =SPARKLINE(C2:E2), assuming that the data you want to consider is between rows C1 and E1.

If you want to create a column sparkline, you must use =SPARKLINE(C2:E2,{“charttype”, “COLUMN”})

18. Confirm emails in your spreadsheet transfer-information-from

When importing email data into the spreadsheet, it is sometimes not formatted correctly.

The good news is that Google Sheets allows, through the ISEMAIL function , to identify which emails are valid and which are not.

To check emails for a specific data range, use the following formula:

=ArrayFormula(ISEMAIL(H2:H3))

Google Sheets will give a view like the following:

19. Validate URLs

In addition to validating emails, Google Sheets can also validate URLs in the spreadsheet.

Use the same formula as we indicated above for emails, replacing ISEMAIL with ISURL :

=ArrayFormula(ISURL(L2:L3))

With this configuration, Sheets can now display the correct and incorrect URLs:

20. Separate names and other data transfer-information-from

Have you ever spent a lot of time manually separating data (e.g. first and last name)?

There is a feature in Google Sheets that makes this task easier for you.

” Split text to columns ” helps you organize information as quickly and easily as possible.

As you’ve seen in this post, Google Sheets has a series of hacks that make your life easier and speed up everyday tasks.

You don’t have to be an expert to start using these features, so gather your favorites and start using them right away.

If you want to learn about other Google apps and how they can help you in your daily life, be sure to check out our list of 55 Google apps for various purposes.