--- title: Using the Copy and Paste Wizard description: The Turbo-Chart Paste Wizard provides a convenient and easy method to import tasks into a dataset --- [Skip to content](https://learn.turbo-chart.com/using-the-copy-and-paste-wizard#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) April 12, 2024 # Using the Copy and Paste Wizard ## The Turbo-Chart Paste Wizard provides a convenient and easy method to import tasks into a dataset This article demonstrates how to setup data specifically from Primavera P6 and use the Turbo-Chart paste wizard. From other sources, the process is similar where data is in a tabular format, and the first row contains the headers to be mapped by the wizard. **Preparing Schedule Data** Create User Defined Fields in your P6 database to use for required data 1. 1. Location Start Value | Numeric 2. Location End Value | Numeric 3. ShapeCode | Text 4. FilterCode | Text (optional) 5. LocationCode | Text (optional) ![P6UDFFields](https://learn.turbo-chart.com/hs-fs/hubfs/P6UDFFields.png?width=688&height=421&name=P6UDFFields.png) **Primavera P6 Activity Layout Tips** Create Activity layout in P6 database with  required data columns - Column headers can use any titel - Activity ID column required - Other required columns are: - ShapeCode UDF - Start and Finish dates - Start and End location UDFs (or a LocationCode column) - FilterCodes UDF - Activity Descriptions - Include Critical field to enable highlighting of critical tasks - Any other columns may be used and will be ignored - Any summary grouping and sorting is ok - Any column order is ok ![P6ActivityLayout](https://learn.turbo-chart.com/hs-fs/hubfs/P6ActivityLayout.png?width=603&height=381&name=P6ActivityLayout.png) **Copy all Data to Clipboard** Note: only activities shown on the layout will be copied, remove/apply filters as required - Click CTRL+A to select all data - Click CTRL+C to copy the data to clipboard **Using Turbo-Chart Paste Wizard** The Turbo-Chart Paste Wizard will check that the data is in a suitable format, containing a header row. Then select the relevant fields from your Data to map into Turbo-Chart's fields ![PasteWizardMapping](https://learn.turbo-chart.com/hs-fs/hubfs/PasteWizardMapping.png?width=688&height=457&name=PasteWizardMapping.png) The Paste Wizard also: - Strips all rows with no ShapeCodes (including summary grouping bands) - Removes Dates with **A** or **\*** Suffix - Identifies New and Existing Tasks - Provides info on Data retained and unused **Chart Ranges being updated** The PasteWizard will auto-fit the current chart shown to the dates and location ranges of the pasted data. To prevent this, untick the option shown to "Best Fit the Active Chart". ![PasteWizardBestFit-1](https://learn.turbo-chart.com/hs-fs/hubfs/PasteWizardBestFit-1.png?width=688&height=560&name=PasteWizardBestFit-1.png)  If your data is not displaying correctly, it may be due to the importing of both location values and LocationCodes resulting in all location values shown as 1,2,3 etc. Please see this article for further assistance: [https://learn.turbo-chart.com/chart-locations-are-using-1234-etc](https://learn.turbo-chart.com/chart-locations-are-using-1234-etc?hsLang=en) - [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