# Mito Spreadsheet

- [Core Concepts](/how-to/overview-of-the-mitosheet.md): Introduces you to the high-level concepts helpful in understanding how the Mitosheet works.
- [Creating a Mitosheet](/how-to/creating-a-mitosheet.md): Use Mito to generate Python code, start automating your Excel processes.
- [Open Existing Virtual Environments](/how-to/creating-a-mitosheet/open-existing-virtual-environments.md): Reopen your existing virtual environments to keep working where you left off.
- [Importing Data](/how-to/importing-data-to-mito.md)
- [Importing CSV Files](/how-to/importing-data-to-mito/importing-csv-files.md): How to import a CSV file into Mito.
- [Importing from Excel Files](/how-to/importing-data-to-mito/importing-from-excel-files.md): How to import a Excel file into Mito.
- [Importing Dataframes](/how-to/importing-data-to-mito/importing-dataframes.md): How to import dataframes file into Mito.
- [Importing from a remote drive](/how-to/importing-data-to-mito/importing-from-a-remote-drive.md): How to import CSV and Excel files from a remote file system.
- [Import: Generated UI from any Python Function](/how-to/importing-data-to-mito/import-generated-ui-from-any-python-function.md): Automatically generate UI's to import data from your enterprise's databases.
- [Importing from other sources](/how-to/importing-data-to-mito/importing-from-other-sources.md): Import any pandas dataframe into Mito.
- [Graphing](/how-to/graphing.md): This documentation explains how to create presentation-ready graphs in Mito.
- [Graph Creation](/how-to/graphing/graph-creation.md): Generate interactive, presentation-ready graphs using Mito's point and click interface.
- [Graph Styling](/how-to/graphing/graph-styling.md): Set graph titles, axises, colors and more to create presentation-ready graphs.
- [Graph Export](/how-to/graphing/graph-export.md): Export your graphs as Python code, images or HTML files to share your insights with your peers.
- [Pivoting/Group By](/how-to/pivot-tables.md): Create Excel-like pivot tables using a spreadsheet interface.
- [Filter](/how-to/filter-data.md): This documentation will teach you how to filter datasets in Mito.
- [Filter By Condition](/how-to/filter-data/filter-by-condition.md): Use filter conditions like greater than, contains, starts with and much more to filter and explore your data.
- [Filter By Value](/how-to/filter-data/filter-by-value.md): View the unique values in your dataset and filter them in/out.
- [Mito AI](/how-to/mito-ai.md): Mito AI is one of the fastest ways to transform your data. This documentation explains how.
- [Summary Statistics](/how-to/summary-statistics.md): This documentation will teach you how to access the summary statistics and frequency chart for any data column.
- [Type Changes](/how-to/type-changes.md): This documentation explains how to change the data type of data and formula columns using Mito's type casting features.
- [Spreadsheet Formulas](/how-to/interacting-with-your-data.md): Write Excel-like spreadsheet formulas to edit your dataframes using Python.
- [Custom Spreadsheet Functions](/how-to/interacting-with-your-data/bring-your-own-spreadsheet-functions.md): Create your own spreadsheet functions and share them with your entire organization.
- [Formula Reference](/how-to/interacting-with-your-data/mito-spreadsheet-formulas.md): Mito supports 75+ of the most common Excel spreadsheet formulas, implemented in Python.
- [Using VLOOKUP](/how-to/interacting-with-your-data/using-vlookup.md): Joining dataframes using a Python VLOOKUP formula in Mito.
- [Editing Individual Cells](/how-to/editing-individual-cells.md): Edit your data with the ease of a spreadsheet.
- [Combining Dataframes](/how-to/combining-dataframes.md): Join datasets together by selecting keys, concatenate dataframes on top of each other, or find unique values between datasets.
- [Merge (horizontal)](/how-to/combining-dataframes/merging-datasets-together.md): Join the columns of two dataframes together.
- [Concatenate (horizontal)](/how-to/combining-dataframes/concatenate-dataframes.md): Concatenating dataframes allows you to combine two or more dataframes by stacking their rows on top of each other.
- [Anti-merge (unique)](/how-to/combining-dataframes/anti-merge-unique.md): Find records unique to one dataframe.
- [Sort Data](/how-to/sort-data.md): This documentation will teach you how to sort data columns in Mito.
- [Split Text to Columns](/how-to/split-text-to-columns.md): Split a column into multiple based on a delimiter.
- [Deleting Columns](/how-to/deleting-columns.md): Remove entire columns from your dataframe just using your keyboard.
- [Deleting Rows](/how-to/deleting-rows.md): Remove entire rows from your dataframe just using your keyboard.
- [Column Headers](/how-to/column-headers.md): Column headers identify the specific column within your dataframe. Mito provides a variety of tools for working with column headers directly.
- [Editing Column Headers](/how-to/column-headers/editing-column-headers.md): Rename your column headers with the ease of a spreadsheet.
- [Promote Row to Header](/how-to/column-headers/promote-row-to-header.md): Select a row of your dataframe to become the new column headers.
- [Deduplicate](/how-to/deduplicate.md): Deduplicate repeated entries from your dataframe.
- [Fill NaN Values](/how-to/fill-nan-values.md): NaN values are one of the most common sources of errors. Use Mito's Fill NaN values taskpane to choose how you handle your missing values.
- [Transpose](/how-to/transpose.md): Convert your columns into rows, and rows into columns.
- [Reset Index](/how-to/reset-index.md): Reset your dataframe's Index after sorting, filtering, or importing your data to cleanup your workspace.
- [Unpivot a Dataframe (Melt)](/how-to/unpivot-a-dataframe-melt.md): Convert a dataframe from wide format to long format.
- [Formatting](/how-to/formatting.md): Format your dataframe to generate presentation-ready Excel files.
- [Column Formatting](/how-to/formatting/column-formatting.md): Format numbers as currency, percentage, accounting, scientific notation or more.
- [Dataframe Colors](/how-to/formatting/dataframe-colors.md): Changing the color and style of the dataframe within Mito.
- [Conditional Formatting](/how-to/formatting/conditional-formatting.md): Explore or highlight your data by changing the format of specific cells.
- [Exporting Data](/how-to/exporting-to-csv-and-excel.md): This documentation explains how to get data out of Mito.
- [Download as CSV](/how-to/exporting-to-csv-and-excel/download-as-csv.md): Export a single dataframe to a CSV file.
- [Download as Excel](/how-to/exporting-to-csv-and-excel/download-as-excel.md): Export dataframes to an Excel file.
- [Generate code to create Excel and CSV reports](/how-to/exporting-to-csv-and-excel/generate-code-to-create-excel-and-csv-reports.md): Generate an Excel or CSV file each time you run your code.
- [Using the Generated Code](/how-to/using-the-generated-code.md): Use Mito generated code to complete your analysis or automate your reports.
- [Turn generated code into functions](/how-to/using-the-generated-code/turn-generated-code-into-functions.md): Convert the Mito generated code into a Python function to make it even easier to reuse.
- [Changing Imported Data](/how-to/changing-imported-data.md): Rerun your Mito analysis on new data to refresh a report.
- [Code Snippets](/how-to/code-snippets.md): This documentation will teach you how to use code snippets and import your own
- [Custom Editors: Autogenerate UI from Any Function](/how-to/custom-editors-autogenerate-ui-from-any-function.md): Extend Mito with custom dataframe transformations, like proprietary algorithms, calculations, and domain-specific knowledge.
- [Find and Replace](/how-to/find-and-replace.md): The quickest way to check if values exist in your data, and substitute them with others.
- [Bulk column header edits](/how-to/bulk-column-header-edits.md): Transform all of the column headers in your dataframe with just one click of a button.
- [Code Options](/how-to/code-options.md): Customize your Mito generated code by converting it to a function, selecting parameters and more.
- [Scheduling your Automation](/how-to/scheduling-your-automation.md): Create fully automated processes by scheduling your Python script to run on GitHub
- [Keyboard Shortcuts](/how-to/keyboard-shortcuts.md): Speed up your Mito workflow with keyboard shortcuts!
- [Upgrading Mito](/how-to/upgrading-mito.md): We move quick. Upgrade to get the latest and greatest.
- [Enterprise Logging](/how-to/enterprise-logging.md): Connect Mito to your internal logging servers so you can track Python retention at your firm.