Excel Import: % Complete doesn’t import correctly



When importing your project from Excel, Pincello seems to divide your % Complete data by 100 and then round it to 1 or 0.



Typically, this issue is related to the way the Excel data is set up. To be imported successfully into Pincello, the records in the Percent Complete column should contain only numbers, without the actual “%” symbol. This is because, in Excel, the underlying value of a percentage is usually stored as a decimal, so even if you see “80%” in a cell, Excel actually stores it as “0.8”, and this is how Pincello will “read” it too.


To correctly import your tasks’ percentages into Pincello, you will need to remove the “%” symbol from all your % Complete records in Excel. Here’s how to do it quickly for all tasks at once:

  1. Open your Excel spreadsheet and select all data in the Percent Complete column. You don’t need to include the column header, if you have one.Screenshot_2.png

  2. With the column selected, Press Ctrl + H to open Excel’s Replace dialog.  Here, type “%” in the Find what box, while leaving the Replace with field empty; then, click Find All.Screenshot_3_cu_sageata.png

  3. Excel will display a list of all entries found within the selection. Click within that list and press Ctrl + A to select all entities. We’d recommend not to skip this step, as it ensures Excel will replace only the items within your selection and nothing else in your spreadsheet that contains the “%” symbol.Screenshot_4.png

  4. Now, click Replace All, and Excel will modify all data within your selection. Don’t worry if you now see some impossible numbers like 10000% in your Percent Complete column. It’s just because of the way Excel stores and formats data by default. Simply select the whole column, right-click the selection, and choose Format Cells -> General.Screenshot_5.png

  5. Click OK, and your % Complete column should now be formatted correctly and imported into Pincello successfully.Screenshot_6_cu_sageata.png

Have more questions? Submit a request