.. image:: image/logo_text_horizontal_800.png
  :width: 400
  :alt: Logo of Simple ML for Sheets
  :align: center

|

.. admonition:: Install Simple ML for Sheets!

   `Click here to install Simple ML for Sheets on your Google Account <https://workspace.google.com/marketplace/app/simple_ml_for_sheets/685936641092>`_

**Simple ML for Sheets** allows anyone to use machine learning (ML) in Google Sheets without any prior knowledge of ML, coding, or the need to share data with third parties.

Simple ML is an add-on for Google Sheets to solve the most common ML tasks. Its
main tasks are are highly automated ML capabilities that do not
require users to know ML: `Predict missing values <task_autocomplete_missing_values.html>`_,
`Spot abnormal values <task_spot_abnormal_values.html>`_, 
and  `Forecast future values <task_forecast.html>`_. 

Simple ML is also useful for machine learning experts who want to quickly iterate or prototype on small (e.g., <1 million examples) tabular datasets. Simple ML offers classic capabilities such as training, evaluating, running, or analyzing a model. Users can export a model to TensorFlow, Colab, TF Serving, or simply call the model in C++, Go, and JavaScript. Training generally takes only a few seconds, which is great for fast iteration.

.. note::
  Having issues using Simple ML for Sheets? Check out our `FAQ <faq.html>`_!


.. raw:: html

  <div style="position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; height: auto;">
  <iframe src="https://www.youtube.com/embed/GYCORMNr_IU" frameborder="0" allowfullscreen style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;"></iframe>
  </div>

.. note::

  Simple ML computation (e.g., training a model) is done in your web-browser using WebAssembly and Javascript.
  Simple ML is powered by `Yggdrasil Decision Forests <https://ydf.readthedocs.org/>`_ that also power `TensorFlow Decision Forests <https://www.tensorflow.org/decision_forests>`_. Simple ML models are compatible with the TensorFlow and the Yggdrasil Decision Forests.


Content
=======

.. toctree::
  :maxdepth: 1
  
  Install Addon <https://workspace.google.com/marketplace/app/simple_ml_for_sheets/685936641092>

.. toctree::
  :maxdepth: 1
  :caption: Tutorials

  Predict missing values <tutorial>
  Spot abnormal values <tutorial_abnormal>
  Forecast future values <tutorial_forecast>
  Train & evaluate models <tutorial_advanced>

.. toctree::
  :maxdepth: 1
  :caption: Documentation

  task_autocomplete_missing_values
  task_spot_abnormal_values
  task_forecast

.. toctree::
  :maxdepth: 1
  :caption: Advanced documentation

  task_train
  task_predict
  task_evaluate
  task_analyze
  task_share


.. toctree::
  :maxdepth: 1
  :caption: Resources
  
  what_can_do
  sheet_format
  faq
  changelog
  User group <https://groups.google.com/g/simple-ml-for-sheets-users>
  Send Feedback <https://forms.gle/YEa1QQsoS6xkBNYB9>
  about
  privacy
  terms