Key Benefits of Analyzing Google Sheets Data in Toric

1. Access your dataflows from your browser in our cloud based software.
2. Cleanup and transform your data in a non-destructive way
3. Reuse your data transformations for new versions and projects with reusable dataflows.
4. Create interactive dashboards or "Data Apps" using your Google Sheets data.
5. Blend your Google Sheets data with other sources with a few clicks.
6. Export your transformed Google Sheets data to use with other programs.

‍

How to Import Google Sheets to Toric

It's simple to connect or import your data from Google Sheets:

• Use the Get Data button to select the Google Sheets option
• Sign in with your Google email and password
• Click the option to see all Google Drive files then click Continue

Add any XLSX or Google Sheet from the Sources tab in the dataflow workspaces

Build reports and dashboards using a variety of visualizations (ie. Pie Charts, Bar Charts, and much more). For example, put together a quick report showing the revenue trends of your company by wrapping up overall profit in a scorecard, show distribution of sales by product name, or track profit over time with an area chart. Add text to contextualize your data visualizations and better communicate your analysis to your team.

‍

Drill through your data with interactive charts - click through pie slices and bars to see all values update to show the summary of data based on selection.

‍

How to Export Data from Toric

Once data is transformed, you could use the Export node to create a new Excel or CSV file. If databases are your thing, you may export to Amazon S3, or your could 'Save As Source' in Toric.