+61 2 9570 3160

UniPhi 14.1 - Copy paste from Excel

UniPhi Software, 29 Oct 2018

UniPhi 14.1 is set for release on Wednesday and one of the cool little enhancements is a move away from file importing to copy paste importing. The benefit of this approach is the removal of the black box nature of the file upload. Many excel imports required tacit knowledge with regards to the named ranges used to import the data, the order of the fields and when they failed, required a lengthy debugging process to fix. Now, all a user needs to do is highlight the range of data they wish to import (even if this includes data not to be included), copy the range and then paste it into our new "Paste from Excel" window. The paste provides instant feedback with the end user being able to see what data will and won't be imported right after the paste action. In some instances, they can fix the data quality issue directly in the UniPhi excel paste window rather than going back to the source file.
highlight the cells you wish to import - no need to format for data to be ignored

Columns not required are ignored. 

Instant feedback as to codes that don't exist and a host of other error handling responses

The breadth of this functionality includes:

Cash flow data for actual, forecast and budget
Whole of project budgets
Accounting transactions when accounting integration doesn't exist

This last feature enables Project Managers to get better access to the transaction data making up their actuals as Finance departments are able to send them extracts in excel and this data can then be managed within UniPhi leading to its end financial reports being leveraged across the portfolio.

Follow us on linked in or twitter to get daily updates on this release and other UniPhi news.


Share this:

We have software solutions for

The enterprise
The Enterprise

Imagine being able to see your project portfolio status. The transparency of UniPhi makes this possible in real-time.

Major projects
Major Projects

There’s project management, then there’s UniPhi. Collaborate effectively as a team and get results.

Your business
Your Business

Real-time practice management, profitable results. Take control of your small to medium business today.

uniphi onsite

On-the-go doesn’t mean disconnected. Track and change project information from your iOS or Android device.

Project and Portfolio Management Software

Award-winning software to collaborate, track and report on your project portfolio.

Covers all areas of project work

Document management

Content generation with the latest version.

Financial management

Real time profitability now and at completion.


Communicate across a virtual team.

Risk management

Execute the plan. Track effectiveness.

Issues management

Focus on the problem, resolve it quickly.

Resource management

Real time utilisation and overallocation.

Time management

What project's slipping, what has slipped?

Cost management

Cost benchmarks, forecasting and reports.

Contract management

Know your commitments. Audit trail variations.

and Reports

Progress on all 9 functions in one screen.