
Available on Professional and Enterprise plans
Overview
Easily migrate and consolidate your customer data into Projects using bulk import. This allows you to upload multiple files and folders at once, streamlining your workflow.Prepare your data
Before you can import your data into Dovetail Projects, you’ll need to organize it and create a ZIP file. Organizing files on your computer- Structure your folders: Arrange the files you wish to import into a clear folder structure on your computer. these folders will help organize your data within Dovetail, often corresponding to new or existing projects.
Create a ZIP file:
- On Windows:
- Select the folder(s) or files you want to include.
- Right-click on the selected items.
- Choose “Send to” > “Compressed (zipped) folder”.
- A new ZIP file will be created in the same location. You can rename it if needed.
- On Mac:
- Select the folder(s) or files you want to include.
- Right-click (or Control-click) on the selected items.
- Choose “Compress [folder/file name]” or “Compress [number] items”.
- A new ZIP file (usually named “Archive.zip” if multiple items are selected, or named after the item if singular) will be created in the same location. You can rename it.
Preparing data from Google Drive or OneDrive
If your data is already organized in folders on a cloud storage service, you can typically download them directly as a ZIP file.- Google Drive:
- Navigate to your Google Drive.
- Right-click on the folder you want to download.
- Select “Download”.
- Google Drive will compress the folder into a ZIP file and the download will begin.
- OneDrive:
- Navigate to your OneDrive.
- Select the folder (or multiple files/folders) you want to download.
- In the top navigation bar, click “Download”. (Alternatively, you can right-click the selected folder and choose “Download”).
- OneDrive will compile the selected items into a ZIP file and initiate the download.
File guidelines
Dovetail supports a variety of file types for import. Commonly supported formats include:- Documents: PDF (.pdf), Microsoft Word (.docx), Microsoft PowerPoint (.pptx), Keynote (.key), Apple Pages (.pages). (Note: Google Docs, Sheets, and Slides will be imported as static PDFs).
- Spreadsheets for survey data: CSV (.csv) - these must be UTF-8 encoded.
- Video and Audio files: Common formats are generally supported.
- Transcripts: WebVTT (.vtt) for uploading your own transcripts.
- Individual file size: While the overall ZIP file size for bulk import should be checked against current Dovetail guidelines, note that individual video, audio, and PDF files have a general limit of 10GB. CSV cells also have character limits.
- Maximum ZIP file size: For the most current information on the maximum allowable size for your ZIP file, please consult Dovetail’s latest technical limits documentation or support resources.
- Maximum number of files within your ZIP: For the most current information on the maximum number of files permitted within a single ZIP file for bulk import, please consult Dovetail’s latest technical limits documentation or support resources.
Upload your ZIP file
Once your ZIP file is prepared, you can upload it to Dovetail by:- Navigating to Settings → Selecting Bulk data import
- Upload your ZIP file: You can drag and drop your prepared ZIP file directly onto the designated area on the page. This will start the upload process.
Map your data
After your ZIP file has been successfully uploaded, you’ll be guided through the mapping process.- Map files and folders to projects: Dovetail will display the structure of your uploaded ZIP file. You can then map your folders and individual files to either new or existing projects within your workspace.
- Verify file details: Dovetail will attempt to automatically infer the author and creation date for the imported files. You’ll have the opportunity to review and adjust these details if you need them.
Review and start import
Before the import begins, Dovetail will provide a summary of the new projects, data sources, and other resources that will be created in your workspace based on your mapping.- Review the summary: Carefully check the summary to ensure everything is configured as you intend.
- Start import: If everything looks correct, click the Start import button.
- Video transcription: Any video files you upload will be automatically transcribed.
- OCR for documents: Optical Character Recognition (OCR) will be performed on PDFs, PowerPoint presentations, and other supported document types, making their content searchable.
