Exporting to Google Sheets

Use this procedure to export program data to Google Sheets. This feature can be disabled by the administrator for all users or for selected users.

See administration tasks for H5 in M3 Core Administration Guide.

  1. Open a program. The program must be in the B panel.
  2. Select the records to export.
  3. Click .
  4. Tools > Export to Google SheetsSelect row option:
    • Export currently selected rows
    • Export all rows

      A maximum of 9999 rows can be exported.

  5. Select the format of the data to export:
    • Source Format: file uses the current data type. The column format in the resulting file is dependent on the data type defined list in the M3 program.
    • Target Format: file uses Auto as the default data format in Google sheets
    • Text Only: file uses the text data format
  6. Click AUTHORIZE GOOGLE. You are required to do this only once if you are signed in to Google.
  7. Optionally, click SIGN OUT to sign in to a different Google account.
  8. Click EXPORT.
    The records that were exported to Google Sheets are displayed in a new browser. If Google Sheetsdoes not open in a new browser tab, check your browser's pop-up blocker settings.