
ADVANCED SETUP – BATCH IMPORTS
Overview
Got a long list of jobs to add? Instead of entering them one by one, you can upload them all at once using the Batch Import feature. It’s fast, efficient, and especially helpful when you’re migrating data or launching Contract-Q for the first time.
This guide walks you through the upload process—from downloading the template to importing your file.
Step-by-Step: How to Import Jobs in Bulk
1. Download the Sample Format
Start by clicking the Sample Format download link at the top of the screen. This Excel (.xlsx) template includes all the required column headers in the exact format our system expects.
⚠️ You must use this template for the import to work. Custom spreadsheets won’t be accepted.
2. Enter Your Job Data
Open the file in Excel or Google Sheets and begin entering your job data directly into the template.
Be sure to:
Once your job list is complete, save the file in .xlsx format.
3. Upload Your File
Return to the Batch Import screen.
Maximum file size: 20MB
Accepted format: .xlsx only
4. Import
Once your file is uploaded, click the Import button in the top-right corner.
The system will now process your data and begin importing jobs into your account.
What Happens Next?
Next up: Error Handling—how to read the error message, fix your file, and re-upload only the failed jobs.
BATCH IMPORTS – ERROR HANDLING
Sometimes a row or two might trip up during the upload—and that’s okay. Contract-Q is designed to help you keep moving by isolating just the rows that need attention.
If there’s an issue with your import file, the system will automatically skip the rows with errors and continue importing everything else that’s valid.
What Happens If There’s an Error?
When you click Import, Contract-Q will:
You'll see a summary in the Most Recent Upload section, which includes:
Fixing and Re-Importing the Problem Rows
Here’s how to get those failed jobs into the system:
Only the corrected rows will be imported.
***Important Note
Do not re-upload the original full file. Doing so will create duplicate jobs for any rows that were already imported successfully. Always use the corrected file with just the problem rows to keep your data clean.
Common Reasons for Failed Rows