Mito
Search
⌃K

Importing from Excel Files

How to import a Excel file into Mito.
Version requirements: Importing XLSX files is only supported on Python version greater than 3.6, and Pandas version greater than or equal to 1.0.

Importing multiple tabs from a single Excel file

  1. 1.
    Click on the Import button in the Mito toolbar.
  2. 2.
    Select the Import Files option that appears in the dropdown.
  3. 3.
    Use the file browser to navigate to the directory and XLSX file you want to import.
  4. 4.
    Click on the file, and then click the Import button. This will open a configuration screen.
  5. 5.
    Configure which tabs you want to import from the Excel file.
  6. 6.
    Set any additional configuration necessary for your import:
    1. 1.
      Has Header Row: Select "Yes" if Mito should set the first non-skipped row as the column headers. Select "No" if Mito should generate column headers
    2. 2.
      Number of Rows to Skip: The number of rows at the top of the file to skip when reading data into the dataframe.
    3. 3.
      Decimal Separator: The character used to separate the decimal places in numbers.
  7. 7.
    Click Import Selected Sheets. For each tab you selected to import, a tab will appear in the mitosheet with this data.

Importing Specific Ranges from a single Excel Sheet

  1. 1.
    Click on the file, and then click the Import button. This will open a configuration screen.
  2. 2.
    Use the file browser to navigate to the directory and XLSX file you want to import.
  3. 3.
    Select the Import Files option that appears in the dropdown.
  4. 4.
    Click on the Import button in the Mito toolbar.
  5. 5.
    Select the single sheet you wish to import specific ranges from. An additional option will appear in the taskpane asking if you want to import multiple ranges from this sheet, click this.
  6. 6.
    Click the + Add button to add additional ranges.

Configure the imported range

  1. 1.
    Name the dataframe you are importing.
  2. 2.
    Configure how to locate th start of the dataframe:
    1. 1.
      Exact Range: Import based on address like A10:C100, where you give the exact location of the dataframe.
    2. 2.
      Upper Left Corner: Input the value at the upper left corner of the dataframe. Mito will keep taking columns until an empty cell is hit.
  3. 3.
    If you selected Upper Left Corner, configure how to find the end of the dataframe:
    1. 1.
      First Empty Cell: Mito will scan the column where the Upper Left Corner is found until the first empty cell is found. This will determine the end of the dataframe.
    2. 2.
      Bottom Left Corner: Mito will scan the column where the Upper Left Corner is found until the Bottom Left Corner value is found.
  4. 4.
    Click import to read in the specific ranges you have configured above.
The Excel Range Import interface.
​
Previous
Importing CSV Files
Next
Importing Dataframes
Last modified 6mo ago