Excel Updater
Our Excel Updater solution affords you a cost-effective path to integrate data into Workfront without having to learn the API, write code, or set up a server, and is ideal for both one time and reoccurring data loads.
HOW | Annual License, Image, On Demand, Video |
WHAT | Actuals, Budgeting, Configuration, Financials |
WHEN | Since 2011 |
WHERE | Companies, Custom Data, Expenses, Hours, Issues, Portfolios, Programs, Projects, Tasks, Users |
WHO | Planner, SysAdmin |
WHY | Data Processing, Schedulable, Simplification |
- Solution
TIP: We invite you to learn about this solution below, and once you are ready, to then proceed here.
Our Excel Updater solution affords you a cost-effective path to integrate data into Workfront without having to learn the API, write code, or set up a server, and is ideal for both one time and reoccurring data loads.
To use it…
Create a specially formatted Excel Updater file, then run our Excel Updater solution to upload that file and process its COMPANIES, DOCUMENTS, EXPENSES, ISSUES, PORTFOLIOS, PROGRAMS, PROJECTS, TASKS, USERS, and HOURS tab(s) to insert or update the data from Excel into Workfront. The data in the Excel file can be for Workfront core fields (e.g. Name, Description, etc.), as well as Parameter fields (e.g. those in Custom Data). You can also to overwrite, prepend, or append text values. Please refer to the Related Files below for more information, examples, and tips.
NOTE: the Excel Updater might not work with objects that include multiple Custom Forms, nor does it support Form Logic at this time
- Media
Excel Updater Video:
- Pricing
From $0.50/Row, to a maximum of:
$499/Day
$1,999/Week
$7,499/Month
$24,999/YearNOTE: The cost is per row in the spreadsheet, but with no charge for a row whose Excel file data matches what is already in Workfront.
- Files
01-Tutorial-Introduction.pdf
324 KB
02-Tutorial-Generate-Template.pdf
211 KB
03-Tutorial-Unique-Keys.pdf
210 KB
04-Tutorial-Insert-Only.pdf
207 KB
05-Tutorial-Update-Only.pdf
199 KB
06-Tutorial-Prepend-Overwrite-Append.pdf
207 KB
07-Tutorial-Setting-Null-Values.pdf
195 KB
08-Tutorial-set-vlookups.pdf
295 KB - Related Products