N O T I C E


MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here for more info!


After your successful integration of Microsoft OneDrive to MSPbots, you are now ready to import your data for dataset creation. This article shows how you can add the CSV files that you want to convert into a dataset.  

What's in this article: 

What are the requirements for adding a CSV file?

You need the following before you can add a CSV file for conversion: 

  • Admin role - Only admins and roles with editing privileges for Integrations can add CSV files. 
  • CSV files in OneDrive - You need to upload the CSV files to OneDrive before you can add these for conversion. 
  • OneDrive integration - MSPbots should be successfully connected to OneDrive before you can perform the steps below. 

How can I add a CSV file? 

Be guided by the following steps for adding a CSV file:

  1. Navigate to Integrations in the MSPbots app and search for OneDrive in the search bar.


  2. Click the ellipsis and select Files. 
    add files

  3. Select the user account and the CSV files in OneDrive. Do the following steps: 
    find csv file
    1. Type the user's account in the User Account field and click the Search icon.

      The User Account field is case-sensitive. Ensure that you are typing the user account correctly. 


    2. Click the dropdown button  and select the drive where the file or files are located.
    3. Enter the file name in the File Name field and click the Search icon.
      Alternatively, you can
      search for the file extension in the File Name search bar. For example, if the file extension is .csv, just type .csv to return all CSV files associated with the user. 
      Once the search results are available, click on the file you want to convert into a dataset. 

  4. Click the Save and Sync button. 

The CSV files cannot contain any of the following: 

  • Blank rows
  • Blank column headers
  • Duplicate column headers
  • Symbols in column headers
  • Column headers that are more than 25 characters long
  • Numbers with commas