A week ago we announced how to bring Junar Data Streams into Google Spreadsheets.

Google insisted on returning the favor so it is possible now to publish Data Streams from pieces of Tables in your Google Spreadsheets !

Say you are passionate about Venture Capital, you have extracted some interesting information from LinkSV, and you now want to publish this data to the world. Here´s what you do:

#1 - You create the table you are interested in publishing and to honor the sources you write them below

#2 - You ensure that there are no protected areas in the document. This means that the column and row freeze bars are in the top left corner as you can see in the image above.

#3 - You need to publish the sheet in which the table is located. Ensure that you (i) publish as a webpage, (ii) select ONLY the one sheet.

#4 - You can get the link of this public sheet

#5 - And now you go to Junar to "collect a new Data Stream" as you already know, or you just use our bookmarklet if you are a Junar Ninja

And in case you want to check out this Data Stream, just go visit "Last 50 VC investments distribution"

Cheers, 

The Junar team

A new feature released by Junar, here it is: Insert live data streams into your Google Spreadsheets.

Very simple

1. Find the Data Stream you like (in this example a LinkSV sourced Data Stream on investments in Silicon Valley)

2. Click on ´Actions´ and then on ´Google Spreadsheets´ to get the ´code´

   -> =ImportHtml("http://www.junar.com/datastreams/html/34755/top-10-largest-vc-rounds-in-2011-linksv-investments-summary/" ; "table" ; 1)

3. Then, just go to your google Doc and insert the code in a cell

4. The Data Stream coming from a site in the web (or from a computer of a Junar Data Publisher) will be updated by Junar in your google doc

For sharing Spreadsheets you certainly use Google Docs... Start embedding live data from the web that you find in the Junar growing catalog of pre-curated data. Let us know what you think (support@junar.com).