The Scenario
You're a project coordinator at a 30-person agency. Kickoff week starts Monday. You have an Excel workbook with 15 rows — each one a new client engagement — and columns for Project Name, Customer, Start Date, and End Date. Every single one of those 15 projects needs to exist in Teamcamp before your delivery team shows up for their first standups.
The bad version:
- Open Teamcamp, click "New Project," type the name, set the customer, fill in the dates, save — then do it again for row 2.
- Lose your place on row 8, accidentally re-enter row 7 with a typo in the project name.
- Spend 40 minutes in the UI for work that is, at its core, a data transfer.
Kickoff week doesn't wait for data entry. Your job is coordination, not retyping spreadsheets — and those 40 minutes are borrowed from the parts of your work that actually require thinking.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data and talks to Teamcamp on your behalf — no configuration, no connector setup, no mapping screens.
Open the sidebar, paste this prompt:
Read every row in the 'New Projects' sheet — columns are Project Name, Customer, Start Date, End Date — and create a Teamcamp project for each row using those fields.
SheetXAI reads all 15 rows and creates a Teamcamp project for each one, passing the name, customer association, start date, and end date from your workbook directly to the API. It writes the resulting Teamcamp project IDs back into column E so you have a permanent reference.
What You Get
- 15 Teamcamp projects created in one operation, matching each row in your workbook.
- Project IDs written back to column E for downstream linking.
- Projects carry the exact names and dates from your workbook — no reformatting, no truncation.
- Any row that fails (say, a missing required field) surfaces an error note in column F so you know exactly which one to fix.
What If the Data Is Not Quite Ready
The dates are formatted as MM/DD/YYYY but Teamcamp wants YYYY-MM-DD
Read the 'New Projects' sheet. The dates in columns C and D are formatted as MM/DD/YYYY. Convert them to YYYY-MM-DD before creating each Teamcamp project.
Some rows are missing a customer name
Read the 'New Projects' sheet. Skip any row where column B is blank. Create Teamcamp projects for all rows that have a customer name filled in, and write a note in column F for any skipped rows.
The customer names in column B need to match existing Teamcamp customers exactly
Read column B in the 'New Projects' sheet. Cross-reference each name against the list in the 'Customers' sheet column A. Use the exact matched name when creating each Teamcamp project. Flag any names in column B that do not appear in the 'Customers' sheet.
Full cleanup-plus-creation in one shot
In the 'New Projects' sheet: trim whitespace from all project names in column A, convert dates in columns C and D from MM/DD/YYYY to YYYY-MM-DD, skip any row where column B is blank, and create a Teamcamp project for every remaining row. Write project IDs to column E and error notes to column F.
The pattern is to combine the data preparation and the API action in a single ask — you get a clean import and a usable project ID list without an intermediate cleanup step.
Try It
Get the 7-day free trial of SheetXAI and open any client pipeline workbook you've been maintaining in Excel, then ask it to push all the new engagements into Teamcamp at once. See also: importing sprint backlogs as tasks and the Teamcamp integration overview.