The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Facebook Twitter YouTube
Facebook Twitter YouTube
Product
Guide
About

Using Ragic with Google Sheets

By Berrin Sun

You can share the links you have generated with the Publish to the Web tool directly to allow others to download data in different formats.

You may also import your data with third party tools that allow you to import from a URL.

Ragic + Google Sheets

In the example below, we're using Google Sheets to further analyze our data.

You can view the example Ragic database here, and the example Google Sheet here.

Using the IMPORTDATA formula with the .csv format, we can import data into our spreadsheet from our Ragic database sheet.

Using this data, we can create charts with different criteria using the Charts tool.

This pivot table was created by selecting the range of data on the spreadsheet, and navigating to Data > Pivot Table.

Using the Report Editor menu, we can use multiple criteria to group fields, and display values accordingly. On our example, since we can use different criteria and stack them within the pivot table, we're able to group our products in our example under different product categories.

More information about pivot tables on Google Sheets can be found here.

Powered by Ragic! : Data Management That Actually Works
Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
Create your first database now!
Learn more about Ragic: Why we created Ragic | Webinars | User Guide.
Keep in touch: Blog | Email | Facebook | Twitter.
Ragic, Inc. | +1 888-666-8037 | Terms | Privacy