Simple ML for Sheets

What is SimpleML for Sheets?

SimpleML for Sheets is a Google Sheets add-on designed to bring the power of machine learning (ML) to anyone, regardless of their coding knowledge or ML expertise. It enables users to perform common ML tasks directly within Google Sheets without needing to share their data with external parties.

How does SimpleML for Sheets work?

SimpleML for Sheets operates as an add-on within Google Sheets, providing automated machine learning capabilities. It leverages WebAssembly and JavaScript for computations within the user's web browser, ensuring data privacy. The add-on is powered by Yggdrasil Decision Forests, which also powers TensorFlow Decision Forests, making the models compatible with TensorFlow and Yggdrasil Decision Forests.

Key Features of SimpleML for Sheets

• Predict Missing Values: Automatically fill in gaps in your data.
• Spot Abnormal Values: Identify outliers and anomalies in your datasets.
• Forecast Future Values: Predict trends and future data points based on existing data.
• Model Training & Evaluation: Train, evaluate, and analyze machine learning models quickly.
• Model Export: Export models to TensorFlow, Colab, TF Serving, C++, Go, or JavaScript.

How to use SimpleML for Sheets?

1. Install the Add-on: Install Simple ML for Sheets from the Google Workspace Marketplace.
2. Prepare Your Data: Format your data in Google Sheets appropriately. Refer to the documentation for guidelines.
3. Select a Task: Choose from options like predicting missing values, spotting anomalies, or forecasting future values.
4. Run the Analysis: Simple ML automates the ML process. No coding is required.
5. Evaluate Results: Analyze the results within Google Sheets and export the model if needed.

Why choose SimpleML for Sheets?

• No Coding Required: Ideal for users without any ML or coding background.
• Data Privacy: Computations are performed in the browser, ensuring data is not shared with third parties.
• Fast Iteration: Training models takes only a few seconds, which is perfect for rapid prototyping.
• Compatibility: Models are compatible with TensorFlow and Yggdrasil Decision Forests.

Who is SimpleML for Sheets for?

SimpleML is designed for a broad audience:

• Beginners: Users who want to leverage machine learning without coding.
• Data Analysts: Professionals looking to perform quick data analysis and predictive modeling.
• Machine Learning Experts: Experts who need to quickly iterate and prototype on smaller tabular datasets.

Best way to leverage SimpleML for Sheets?

To get the most out of SimpleML for Sheets:

• Start with Clear Objectives: Define what you want to achieve with ML (e.g., predicting sales, identifying fraud).
• Format Data Correctly: Ensure your data is properly formatted in Google Sheets for optimal results.
• Explore Different Features: Experiment with different features of Simple ML to understand their capabilities.
• Consult Documentation: Refer to the official documentation and FAQ for troubleshooting and best practices.

SimpleML for Sheets simplifies machine learning, making it accessible to a wide range of users directly within Google Sheets. By automating common ML tasks and ensuring data privacy, it provides a valuable tool for data analysis and predictive modeling.