logo-light

Chetan Amin

Categories
Uncategorized

Integrating Spreadsheets into a Website or WordPress Site

Many have called or emailed to check if Trunao can help to Integrate or embed spreadsheets into Websites or WordPress. The answer to this is an overwhelming YES.

The process of taking your sheet to the WordPress page of the website is quite simple in Trunao. It will take you less than an hour to integrate a spreadsheet and have it become available on your website once the sheet is converted to a Form in Trunao. All that is necessary is to enable the flag for Share Listing and copying the link to be put on your HTML page.

For step by step instructions, follow the link below.

2.5 Integrate Spreadsheet into Website or WordPress Site

It was quickly realized that a lot of individuals and small companies are struggling to take your sheets data and share it either through a login portal for your members or open it up for public consumption. And so, Trunao was also able to make their lives a lot simpler. Below is an example of public access usage for Trunao.

Since Trunao – free online excel editor has the ability for multiple pictures, the shared list on the web can also show the associated pictures for each of the records. For example, if the search listing is for a house on rent or sale, the host can put all the pictures to be browsed by the consumer.

Other examples include marriage database, car listing, Event attendees, etc.

Are you still using Excel or Google Spreadsheets? Time for a change.

Sign-up now and enjoy the features you have been missing.

#Trunao #ExceltoDatabase #ExceltoWebsite

Categories
Blog

Sharing Forms with Confidence

Sharing Spreadsheets with others has always been a nightmare. In the past, the only way to send worksheets to others was by attaching them to emails and sending them across the World Wide Web. Any new changes to those spreadsheets meant a new version had to be emailed. It would clog up email accounts and sometimes even accidentally pick up the wrong version.

With the use of Trunao and Cloud Sharing, it has been extremely convenient and easy. Your users will always have the latest data at their fingertips. With the help of Trunao, you can also get the data on mobile and have exactly the same look and feel as it would on laptops or tablets.

With Google/Excel Spreadsheets, you can share your sheets so that everyone gets the entire sheet with either a view-only document or all edit features with no granular control. With Trunao Share, however, you have a lot more options and micro-managing control over your sheets and data. Let’s look at the various options in Trunao – online excel viewer and editor.

Share Permissions:

Form Menu to Select Share
Invite User tab

As shown in the image above, you can invite users as Admin or Users. Admins have full access similar to the Owners. Users have access to the permissions that you deem fit to authorize. You can restrict the user to any of the actions displayed above.

Column Restriction:

In addition to the permissions, you can also exercise control over which columns are sensitive in your sheets and must not be shown to others. At a column level, you can select groups to hide the columns. This way they will have all the other columns except for the ones you have explicitly blocked as shown below.

Are you still using Excel or Google Spreadsheets? Time for a change.

Sign-up now and enjoy the features you have been missing.

#Trunao #ExceltoDatabase

Categories
Excel to Database

Trunao’s Powerful Feature

If you have ever tried to use Excel in a shared mode. You would have come up with a pain point of changing a filter and every one of your users will get the new filter on your sheet.

This causes the users a lot of trouble as any change by one user will change your search criteria. If you hide a column the column gets hidden on all users. The popular spreadsheets lack the ability to independently be able to filter, sort, or select columns.

Trunao has an extremely powerful feature to overcome this drawback called Views.

Each user can simply add their filter condition without impacting other users as every user gets their own workspace.

If they prefer to save this filler for regular use they can do so. By saving and providing a filter name.

In addition to filter conditions sort and column show/hide can be stored and retrieved in each view.

Are you still using Excel or Google Spreadsheets? Time for a change.

Sign-up now and enjoy the features you have been missing.

#Trunao #ExceltoDatabase

Categories
Excel to Database Uncategorized

How data driven is your organization?

Around 56% of small to medium enterprises struggle between managing and maintaining their databases. Most of these businesses are at a loss while deciding to choose between using simple MS Excel spreadsheets and investing money in maintaining a cloud database solution. While both of these solutions have their respective benefits and advantages, the key difference between the two is that simple spreadsheets analyze data while database solutions uphold and maintain data. Convert Excel to Online Database

While technologies around us begin to transform from analog to digital, it becomes important for businesses to catch up on this digital transformation in order to stay in the competition. One of the most important steps to digital transformation is maintaining data in the cloud. Not only is this a smarter and a more efficient method compared to Excel spreadsheets but also increases the overall productivity of the business. There are several cloud database solutions out there. Some of them include programming in Tableau and MySQL whereas others include renting out relational database management systems from companies like Salesforce and Microsoft. While these are the most frequently used solutions utilized by larger enterprises, many of the smaller businesses hesitate to employ these solutions due to a lack of programming expertise in the team or a lack of funding to invest in ready-made CRM solutions.

Maintaining a cloud database is inevitable for any company in the market. Hence, in order to make this process a lot easier for small to medium enterprises, Trunao offers a readymade solution to fix this problem. Trunao is an excel to a cloud database converter. It is a simple solution that allows organizations and corporate users to upload their simple Excel files and instantly convert excel to web application free them into a ready-to-use database. As like mentioned before, this database turns out to be extremely useful in analyzing the daily routine of the company by providing empirical statistical solutions such as pivot table or smart analyses such as form and report generators, linked hierarchies between forms, real-time document and photo uploads linked to every row of the data, auto-save features and much more! Trunao is simply a user interface tool made to make the business processes of small companies much easier so that these companies stop worrying about managing and handling their data and focus entirely on their product development and marketing.

Finally, the main question that comes to anyone’s mind when they hear the word ‘cloud’ is whether their data will be secure. Trunao takes care of this concern by offering an end-to-end encryption feature to all its users. This feature creates a tunnel between the user and his/her data where there is no chance of any third-party interference. Hence, keeping the data secure and completely isolated. Additionally, it employs a cryptic architecture as well. By doing this your data can only be viewed by you and the people you share it with.

While these features might seem overwhelming and costly, Trunao offers free and unlimited access to the cloud to its single users, whereas a $10 per month subscription to its corporate users with a free 30-day trial period. Hence, not only is Trunao a cost-effective and efficient solution for data management but is also a quick and easy fix to problems faced by small and medium enterprises regarding their data.

Also read: Web Apps vs Excel

Categories
Excel to Database

Why are Business still using Excel as a database?

In my years of experience, I have struggled with users using #Excel as a #database. The problem is once they start using it, then it’s never easy to convince them even when you have built the greatest of systems. #Excel users will usually never want to switch.

I cannot fully blame the users as to when they would go to IT for a new database application usually the estimate provided is upwards of $40,000. Then the question asked by CEO is “Does this system add to the bottom line?”. If not then there is no funding. This action then legitimizes the use of #Excel forever. This also impacts the users end up doing a lot of labor-intensive work just to keep that information going.

In addition, it also becomes a nightmare for the IT as users then have a lot of #Excel versions _v1, _v2…_vN on their disk drive and on the emails. No one seems to be worried about deleting either the email or the file from the storage device.

Also check: Key Reasons – Turn Excel Spreadsheets into Web Apps Now

I am not saying #Excel or #spreadsheets is bad. #Excel was not designed to be a database. I think it’s time that we have a system that is as simple, more user-friendly, with all the features that a #database should have, and much more is provided to the #business.

Thanks. Do share your comments and thoughts.

To learn more about how to resolve the above issue click link: https://trunao.com

Convert Excel to an Online Database

Upload your excel file here