--- title: P6 Layouts and Spreadsheet Import description: "Steps for P6 users to prepare layouts for\nworking with Turbo Chart data and for Importing via Spreadsheet to Turbo Chart" --- [Skip to content](https://learn.turbo-chart.com/p6-layouts-and-spreadsheet-import#main-content) English Show submenu for translations [More support](https://learn.turbo-chart.com/kb-tickets/new?hsLang=en) [Ticket portal](https://help.turbo-chart.com/tickets?hsLang=en) [![Turbo-Chart](https://learn.turbo-chart.com/hs-fs/hubfs/TC_URL_BLUE_on_CLEAR_1246_197.png?width=1246&height=197&name=TC_URL_BLUE_on_CLEAR_1246_197.png)](https://turbo-chart.com/?hsLang=en) - [Home](https://turbo-chart.com/) - [Product](https://turbo-chart.com/product-presentation) Show submenu for Product - [Changelog](https://turbo-chart.com/changelog) - [Presentation & Demonstration](https://turbo-chart.com/product-presentation) - [Tilos vs Turbo-Chart Training](https://turbo-chart.com/tilos-training-tutorial) - [Features](https://turbo-chart.com/features) - [Chart Samples](https://turbo-chart.com/sample-interactive-viewer-charts) - [Purchase](https://turbo-chart.com/purchase) - [Help](https://learn.turbo-chart.com/) Show submenu for Help - [F.A.Q.](https://turbo-chart.com/faq) - [Knowledgebase](https://learn.turbo-chart.com/) - [Licence Portal](https://portal.turbo-chart.com/) - [Time Location Mini-Course](https://turbo-chart.com/time-location-charting-mini-course) - [Contact Us](https://turbo-chart.com/contact-us) - [About](https://turbo-chart.com/about) Show submenu for About - [Customers](https://turbo-chart.com/turbo-chart-customers) - [About Us](https://turbo-chart.com/about) - [News](https://turbo-chart.com/blogs) - [Contact Us](https://turbo-chart.com/contact-us) - [Terms](https://turbo-chart.com/terms) Open main navigation Close main navigation - [Home](https://turbo-chart.com/) - [Product](https://turbo-chart.com/product-presentation) Show submenu for Product - [Changelog](https://turbo-chart.com/changelog) - [Presentation & Demonstration](https://turbo-chart.com/product-presentation) - [Tilos vs Turbo-Chart Training](https://turbo-chart.com/tilos-training-tutorial) - [Features](https://turbo-chart.com/features) - [Chart Samples](https://turbo-chart.com/sample-interactive-viewer-charts) - [Purchase](https://turbo-chart.com/purchase) - [Help](https://learn.turbo-chart.com/) Show submenu for Help - [F.A.Q.](https://turbo-chart.com/faq) - [Knowledgebase](https://learn.turbo-chart.com/) - [Licence Portal](https://portal.turbo-chart.com/) - [Time Location Mini-Course](https://turbo-chart.com/time-location-charting-mini-course) - [Contact Us](https://turbo-chart.com/contact-us) - [About](https://turbo-chart.com/about) Show submenu for About - [Customers](https://turbo-chart.com/turbo-chart-customers) - [About Us](https://turbo-chart.com/about) - [News](https://turbo-chart.com/blogs) - [Contact Us](https://turbo-chart.com/contact-us) - [Terms](https://turbo-chart.com/terms) - English Show submenu for translations - [More support](https://learn.turbo-chart.com/kb-tickets/new) - [Ticket portal](https://help.turbo-chart.com/tickets) How can we help you? - There are no suggestions because the search field is empty. 1. [Turbo-Chart Help](https://learn.turbo-chart.com/?hsLang=en) 2. [Importing Data](https://learn.turbo-chart.com/importing-data?hsLang=en) January 16, 2024 # P6 Layouts and Spreadsheet Import ## Steps for P6 users to prepare layouts for working with Turbo Chart data and for Importing via Spreadsheet to Turbo Chart #### Turbo Chart Data Fields This article assumes the following User Defined Fields have been created within P6 for Turbo Chart Data - Numeric UDF for location start value - Numeric UDF for location end value - Text UDF for Shape Code values - Text UDF for Location Codes (if also being used) - Text UDF for Filter Code value (this field is not a required field, but can also be used) ![KB1.IMG01](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB1.IMG01.png?width=484&height=252&name=KB1.IMG01.png) #### Creating a Working Layout To create a general purpose layout, assign the above UDF fields as additional columns in any layout. 1. In P6 Activity View, Select **VIEW \> COLUMNS** from the menu, or right-click on the column headers and select COLUMNS 2. Select all the UDF fields required, and press the right Arrow to include the columns in the layout ![KB3.IMG02-1](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB3.IMG02-1.png?width=563&height=493&name=KB3.IMG02-1.png) 3\. The columns are now available for data entry or modification. 4\. Any Grouping and Sorting options may be applied ![KB3.IMG03](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB3.IMG03.png?width=688&height=307&name=KB3.IMG03.png) A sample P6 Layout file *LPS\_WBS ACTIVITY VIEW.plf* is provided in the sample data (**HELP \> DOWNLOAD SAMPLES** within Turbo Chart). Note that the layout may not display the UDF fields as each P6 database has unique ID’s that may not display with the provided layout file. #### Spreadsheet Data Import A layout that provides data that can be imported via spreadsheet import requires the following data fields. Note that column headings must be modified to match those required by Turbo Chart: | **Column Heading** | **P6 Data Field** | **Data Type** | | --- | --- | --- | | Name | Activity ID | Text Values | | Description | Activity Name | Text Values | | ShapeCode | *P6 UDF for Shapes* | Text Values | | FilterCode | *P6 UDF for Filters* | Text Values | | LocationCode | *P6 UDF for Locations* | Text Values | | Start | *P6 UDF for Start Position* | Numeric Values | | End | *P6 UDF for End Position* | Numeric Values | | Start Date | *Start* | Date Format | | Finish Date | *Finish* | Date Format | To modify column headings in P6, select the field to modify, then select **EDIT COLUMN** **![KB3.IMG05](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB3.IMG05.png?width=688&height=311&name=KB3.IMG05.png)** And then enter the New Title required for the column ![KB3.IMG06](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB3.IMG06.png?width=465&height=248&name=KB3.IMG06.png) Apply to all the required Data Fields ![KB3.IMG04-1](https://learn.turbo-chart.com/hs-fs/hubfs/Imported%20images/KB3.IMG04-1.png?width=688&height=295&name=KB3.IMG04-1.png) A sample P6 Layout file *LPS\_SPREADSHEET IMPORT VIEW.plf* is provided in the sample data (**HELP \> DOWNLOAD SAMPLES** within turbo Chart). Note that the layout may not display the UDF fields as each P6 database has unique ID’s that may not display with the provided layout file. A Sample Spreadsheet import file (Macro-enabled XLS file) is also provided in the sample data to display the required import columns and headings. Once the required headers are provided, data from P6 can be copied and pasted into Turbo-Chart, through the DATA\>TASKS “Paste from Clipboard” function. #### Further Help All queries relating to Turbo Chart or the sample data can be addressed via email to [support@linearprojectsoftware.com](mailto:support@linearprojectsoftware.com) - [Getting started](https://learn.turbo-chart.com/getting-started?hsLang=en) - [Importing Data](https://learn.turbo-chart.com/importing-data?hsLang=en) - [Working with Charts](https://learn.turbo-chart.com/working-with-charts?hsLang=en) - [Printing and Publishing](https://learn.turbo-chart.com/printing-and-publishing?hsLang=en) - [FAQs](https://learn.turbo-chart.com/faqs?hsLang=en) - [Troubleshooting](https://learn.turbo-chart.com/troubleshooting?hsLang=en) - [Tickets](https://22261683.hs-sites.com/tickets-view) [![logo-white-line-02 (2)](https://learn.turbo-chart.com/hubfs/logo-white-line-02%20(2).svg "logo-white-line-02 (2)")](https://22261683.hs-sites.com/home?hsLang=en) Turbo-Chart Support, Linear Project Software Pty Ltd, Sydney, Australia & London, United Kingdom [mailto:support@linearprojectsoftware.com](mailto:support@linearprojectsoftware.com) Copyright © 2025, Linear Project Software Pty Ltd