# Spreadsheet Import {% hint style="info" %} **Who can use this feature?** All Project Users can import Tasks via CSV. {% endhint %} If your plan already lives in Excel, you don’t need to start from scratch.\ Quickly import Task names, dates and more - turn your spreadsheet into a live plan in Aphex. ## Upload or Paste your Spreadsheet *** Start by selecting your CSV file or copying data directly from your spreadsheet.
#### To upload your data: * Click your Project Title in the top left * Select `Import Tasks` * Choose between `Upload a CSV` or `Copy and Paste` * Upload your CSV file, or paste your data into the importer * Select
Supported Migration Sources The migration tool is built to support CSV formatted data. If your plans are in any system with rows and columns, you can most likely either export the data directly to CSV or copy the data from the interface and paste it into a CSV or other spreadsheet. Should your existing data be inconsistently structured due to headings or another formatting technique, you can download an example CSV template below and paste your relevant data before importing. Sample CSV Import File
What can you import? The importer supports mapping of the following six properties on imported tasks. At least one mapping is required for a valid import: | Property | Accepted Format | Default Value | | --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | | `Task Name` | Any String | "New Task" | | `Start` |

dd/MM/yyyy',

'dd/MM/yy',

'yyyy/MM/dd',

'dd-MM-yyyy',

'dd-MM-yy',

'yyyy-MM-dd',

'ddMMyy',

'yyyyMMdd',

Prefix of the day are also supported i.e. "Tue ddMMyyyy"

| Today | | `End` | Same as Start | Same as Start | | `Shift` |

'Day',

'Afternoon',

'Night',

'All',

| Day | | `Package` | Any String | N/A | | `Subcontractor` | Any String | N/A | Imported tasks will be assigned to the project's default calendar and the owner undertaking the migration.
## Map your data to Aphex *** Aphex will scan your spreadsheet and show the columns it found. Just match each one to the right Aphex property - like Task Name, Start Date, or Shift. You only need to map what you’re using.
#### To map properties: * Choose which columns in your spreadsheet match Aphex properties like `Task Name`, `Start Date`, `End Date`, `Subcontractor`, `Shift`, or `Package`. * If needed, toggle `Exclude up to row` to skip up to the first 10 rows - handy if your file includes notes or headers before the actual data starts * Select ## Confirm your Tasks *** Get a quick sense check of what you’re about to create. We’ll show you a preview of the task names, dates, and any mapped fields so you can confirm it’s all as expected.
#### To complete the import: * Review the Tasks you're about to import * If you're happy, select to add your Tasks to the Plan
What happens after the import is complete? * Imported tasks will be assigned to the project's default calendar and the owner undertaking the migration. * Assigned Project Assets, such as Packages or Subcontractors will be created automatically if required. * Tasks will be created in the plan immediately
--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.aphex.co/docs/planner/features/migrate-existing-plans-to-aphex-csv.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.