Skip to main content

Step 1: Organize your Excel sheets

Integrate your Excel workbooks from OneDrive to Plecto.

To start, organize your sheets like in the table below. Use a compatible date and time format: MM/DD/YYYY HH:MM or YYYY-MM-DD HH:MM:SS


Column title

Column title

Column title

Employee email

Employee name




2024-03-30 21:15:30

Joan Reyes




3/31/2024 14:15

Martin Jones

See example

Step 2: Integrate your sheets

  1. In Plecto, go to Data management > Data sources > + New data source > Microsoft Excel.

  2. Click Next, sign in to your OneDrive account, and click Accept to give Plecto to access your workbooks.

  3. Choose a workbook. If it contains multiple sheets, select the sheets to import. Each sheet will create one data source.

  4. Configure the settings for your upcoming data source(s) by matching the column names from your sheet. You can omit the Team field.

  5. Click Next to finish and import your data. 🎉