Import Spreadsheet – Here, Here or Here

Posted by Posted on by

When it comes to managing data, people have been relying on spreadsheet more than anything else. Finance people, todays marketing executives, tomorrows managers and friendly support executives rely on it to get their day to day activities done.

So Zoho Creator is providing users to import their data from the spreadsheets quickly and efficiently.

I would like to tell you the fact that creating an fully functional application is not single day job (though you can in minutes), but it is an incremental process. As you go on using the application, you get more visibility on your requirements and the needs. You add some, delete some, rename few and tweak the application a bit here and there to suit your needs. So the application which you are working on should be flexible enough to give you the best result what you wanted it to, each day, everyday.

Keeping the flexibility in mind, we have provided options to import spreadsheet data at three different scenarios. You can make use of them whenever you need.

# Create Application Window
This will be your first step in creating an application. If you have data in a spreadsheet (.xls .csv or .tsv). Select ‘Import .XLS .CSV’ option and import your data either by copy/paste or by importing the whole file.

Zoho Creator - Create application window

# Create Form Window
You have imported the spreadsheet file easily enough to create the application. Now you wanted to create additional form by importing another spreadsheet. Now what?

In the edit mode, just click on ‘Create Form’ button and select ‘Paste your Data from .xls .csv file’ option. Paste the copied data in the area provided. Your form gets created automatically with the required fields.

Zoho Creator - Create Form window

# Import Data in the live mode
When you have missed the above two options and have landed in the live mode but still wanted to get those data into Zoho Creator which are lying in your spreadsheets. What can you do?

We have thought about that too. In the live mode click on ‘Import Data’ which is at right top corner of the form header, select ‘ From file’ and upload the spreadsheet file. Thats it, data will be imported to the application.

Here in this case, you need to make sure that the field labels in the form and the column names in the spreadsheet are same.

Go ahead, bring in all those spreadsheets which are used extensively by you and your colleagues. See your spreadsheets transforming into web application, beautifully.


How businesses can benefit from Zoho

Posted by Posted on by

Albert F. Case, Jr., at TechSpend makes some good points regarding businesses using web-based software. From his article,

I’ve read a lot about Google’s online spreadsheet and Zoho’s ZohoWriter and related products. I’ve also heard a lot of “Who needs it?” That attitude amazes me. During my “informal” survey of a few dozen Excel users I know exactly 0% used pivot tables and charts! Sure, I know people (like me) who do – but the reality is most don’t. Just like most people using Microsoft Office don’t do much more than write reports in Word, send Email in Outlook and do simple spreadsheets in Excel. Now, at $200 to $400 per person, how many thousands of dollars are spent for licenses of Microsoft Office in a company that has 1,000 or 2,000 or 5,000 PCs?

He goes on with how a web-based spreadsheet application (like Zoho Sheet) can help a company.

Think of the creative new applications of an online, sharable spreadsheet. A spreadsheet Wiki! The company home phone list can be instantly updated. Prospect lists can be shared. Budgets can be tinkered with in group fashion. I can think of hundreds of uses for this technology in the average corporation.

And, he has this to say about Zoho CRM :

Zoho has some paid applications as well – such as ZohoCRM. $12 per month per user! Whither goest Oracle/Siebel from here? This could be a real challenge to hosted CRM leader

Great thoughts, Albert! Like you, we believe more & more people have started realizing the endless possibilities that affordable (and often times free) web-based software like Zoho is creating for businesses around the world.

Zoho for lawyers

Posted by Posted on by

Robert J. Ambrogi in the ‘Law Technology News‘ column at has a nice article on how Web 2.0 can help lawyers. He writes,

Why use the Web as your platform instead of your desktop? For lawyers, the strongest reason is collaboration. Lawyers working jointly on a project — whether across town or across continents — derive enormous value from being able to work together in a platform- and location-neutral environment.

About the online Office suites, he has this to say :

Several companies now offer suites of office tools comparable to those you would buy for your desktop. They combine word processing, spreadsheets and graphical presentation applications.

One such suite is ThinkFree, which allows you to create Microsoft Office-compatible documents, spreadsheets and presentations.

Another, Zoho Office Suite, goes a step beyond ThinkFree. In addition to document, spreadsheet and presentation tools, it offers a “Virtual Office” of group e-mail, group and individual calendaring, document-sharing and instant messaging. Zoho’s word processor and other office tools are free. Its Virtual Office is free for up to 10 users, then priced starting at $295 a year.

Thanks, Robert!

Techlearning recommends Zoho Writer

Posted by Posted on by
Barbara Bray in the PDQ (Professional Development QuickTips) column at techLEARNING writes about using Zoho Writer as a free web based word processor. From the article :

Have you ever worked on a computer that didn’t have a word processor? How about using a Web-based word processor? Zoho Writer’s “Online Word Processor” provides all the tools you need to write and Email your document to yourself or save it in your online document folder.

Zoho Writer not only lets you create your own documents but also allows you to share your document to collaborate with others. You give permission for your friends to read only or read and write on your document.

Thanks Barbara & techLEARNING!

Sales Presentation using Zoho Show

Posted by Posted on by

Here is the sample sales presentation which embeds charts from Zoho Sheet & forms from Zoho Creator. Please fill your feedback in the form embedded in the presentation after seeing the presentation.
Steps followed ( Just 5 simple steps to follow ) :

1. Create chart using Zoho Sheet.
2. On mouse over in chart, you can see “Publish” option. Click on that to publish your chart.
3. A HTML code snippet will be given in the popup. Copy that HTML code snippet in Zoho Sheet
4. In Zoho Show slide, click on “Insert HTML” toolbar button ( <> ). In the popup, paste the HTML code snippet copied from Zoho Sheet.
5. Close the popup & you will see the chart embedded in your Presentation.

You can follow similar steps in Zoho Creator to embed the form in your presentation.

Try using Zoho Show for your next presentation & share your experience with us.

Zoho Writer recommended at the School Library Journal

Posted by Posted on by

Chris Harris, in the August issue of the School Library Journal writes,

Save a document with your desktop word processor and there it sits. Sure, you can move it around using the Sneaker-Net on a USB flash drive or e-mail the document, but there are serious limitations. Save a document using Zoho Writer and it is available wherever you can access the Web. You can share the document with read-only or read/write permissions with a simple e-mail invitation. Or you can make the document public and allow anyone to read what you have written. The options don’t stop there; you can also automatically post it to a blog, export it to a PDF file, or even save it in the standard DOC format for use in Microsoft Word.

So the next time you are collaborating on a project with a teacher down the hall, a librarian across the district, or a national committee, why not try Zoho Writer? Or if your school discourages students from bringing documents from home to school on storage drives, why not introduce students to an online word processor?

The whole article is available here. Thanks, Chris!

Page 298 of 333« First...102030...296297298299300...310320330...Last »