Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Data exported from P6 in Excel is in strange, unusable format?

5 replies [Last post]
David Ball
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 26 Jan 2012
Posts: 10
Groups: None


Whenever I export data from P6 in Excel format the data comes out in a strange format where everything has a "`" in front. For example, 1303FR001 comes out like `1303FR001. And I can't perform a Vlookup or other action as Excel doesn't seem to recognise the data.

Is there a way to export from P6 into Excel and get a "normal", usable output?


Thanks very much




hany esmael
User offline. Last seen 32 weeks 6 days ago. Offline
Joined: 5 Mar 2008
Posts: 38
Michael Lepage
User offline. Last seen 30 weeks 6 days ago. Offline
Joined: 11 Aug 2011
Posts: 37
Groups: None


A nice plugin for excel is called ASAP Utilities which has a nice feature to remove those apostrophes in excel.  There's a tutorial on updating activities through excel (with ASAP utils) over at


David Ball
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 26 Jan 2012
Posts: 10
Groups: None

Thanks very much guys.



Christopher Hall
User offline. Last seen 7 years 1 week ago. Offline
Joined: 17 May 2012
Posts: 42
Groups: None


The ' character symbolizes left justify in excel.  It comes in with some imports.

You could write a macro but the simplest way to remove ' character is to select a blank cell on the worksheet type the number 1 into it.

Ctl C this cell, highlight the column/ table, go to paste special and use the operation 'divide by'.

Problem solved, just note you'll need to re-format any date columns as the output will be numerical.

Also don't select the whole spreadsheet, it will return zeros for blank cells.


Chris Hall

Raymund de Laza
User offline. Last seen 23 hours 19 min ago. Offline
Joined: 23 Nov 2009
Posts: 698


Use the export through SDK....