# Move projects from spreadsheets to Asana: introducing the CSV importer

> If you're moving from excel to Asana for your project management, the transition just got easier. This new integration imports projects from CSV to Asana.

Source: https://asana.com/inside-asana/import-csv-asana-projects

## Move projects from spreadsheets to Asana: introducing the CSV importer

It starts out simple: You kick off a project by creating a spreadsheet with the [list of to-dos](https://asana.com/uses/to-do-list) that need to get done. Then you list the teammates tackling the work in the next column, and add due dates in another column. It feels fairly organized. But then things change. And with work happening across emails, meetings, docs, and conversations, your spreadsheet quickly becomes out of date and lacks important context for the project.

While spreadsheets are often used for project planning, they weren’t designed for collaborating on complex work and managing lots of moving parts. But it can feel daunting to try another tool because you don’t want to start all over from scratch. With our new CSV importer, you can import your spreadsheet right into an Asana project so you can begin managing your project in a collaborative, flexible tool with just a few clicks.

## Why use Asana instead of spreadsheets?

Unlike a spreadsheet, your project plan is actionable and trackable in Asana. Teammates can collaborate, communicate, assign work, and [share files](https://asana.com/apps?category=file-sharing) right in your Asana project so everything stays connected—and everyone stays on the same page.

We used to manage projects in spreadsheets. But since we were tracking hundreds of things in dozens of different spreadsheets, tracking down information was unattainable and projects fell through the cracks. Now that we use Asana, project steps are trackable and we have a better system of accountability.You can also set the project to [comment only](https://blog.asana.com/2017/11/comment-view-only-permissions-asana/) so teammates don’t make accidental changes to the plan. And because Asana integrates with [tools you already use](https://asana.com/apps), all project work stays connected, instead of scattered across emails, IMs, spreadsheets, docs, and other tools.

## How to import a CSV file to Asana

If [you use Excel,](https://asana.com/uses/excel-project-management) Google Sheets, Smartsheet, or want to move Trello projects into Asana, these spreadsheets can easily be converted to a CSV file, and then imported. Once you’ve converted your file:

1. [Log in](https://app.asana.com/#login) to Asana

2. Create a new project by clicking the + button in the top bar or navigate to an existing project.

3. Click the project header dropdown menu and select **Add Tasks via**, then choose **CSV**.

4. Choose your file or drag it into the importer.

5. If your spreadsheet has a header row, check the **Use first row as column names**box.

6. Map your columns to task name, task assignee, and task due date. Premium customers can map start dates and custom fields during this step.

7. Start your import!

Once you’ve imported a spreadsheet to a project, any additional spreadsheets you import to the project will add to, not replace, the information you already have in the project.

## Map your spreadsheet to Asana

To ensure a successful import, here are some formatting tips for your CSV file:
- **Assignee:**The column with the names of teammates responsible for the tasks will be mapped to the assignee field in Asana. You’ll need to replace their name with their work email address to successfully assign the tasks.
- **Dates:**You can track both start and due dates in Asana. In your spreadsheet, separate these dates into two columns. Your date columns need to be formatted in the standard US date format of month/day/year to import successfully. (Note: Start dates are an [Asana Premium](https://asana.com/premium) feature and will appear in the task description if you’re not on a Premium plan.)
- **Other information:**In addition to task name, assignee, and dates, other columns can be mapped to [custom fields](https://blog.asana.com/2016/09/track-anything-with-custom-fields/). Custom fields help you categorize and track priorities; you can also sort or search by field. Some good uses for custom fields are priority, project stage, team, and estimated time. (Note: Custom fields are an [Asana Premium](https://asana.com/premium) feature. If you’re not a Premium customer, all other column information will be added to the task description in the order of your columns.)
- **Sections:**If your spreadsheet has rows that divide to-dos into sections, add a colon to the end of your section text and these will automatically turn into [sections](https://asana.com/guide/help/projects/sections) in your Asana project.

Once you’ve mapped your columns and imported the spreadsheet, you can move tasks and sections around, add project members and followers to tasks, attach files, and share status updates with teammates. For more information on getting started with Asana, visit the [Asana Guide](https://asana.com/guide/help/api/csv-importer).

## Making the move

Change can be hard, and taking the first step to implementing a new tool and process is the hardest part. We hope the new CSV importer makes it easy to get out of tracking your projects in spreadsheets so you can manage your projects in a collaborative and dynamic work management tool.

- [Asana の最新情報: 2022年 8月号](/ja/inside-asana/whats-new-focus)

製品について

成果につながらない仕事を減らし、効率を高めるなら、Asana にお任せください。今月は、チームが時間を節約し、有意義なことに集中するための新機能が揃って登場しました。仕事中に気が散って困るという方は必見です。Asana の Google ドライブ連携なら、コメントを見落としません使えるツールはいくらでもある現代。その一方で複数のプラットフォームや文書、関係 ...

- [Asana の最新情報: 2022年 4月号](/ja/inside-asana/whats-new-april)

製品について

今日の話題は、チームをさらにパワーアップする Asana の多彩な新機能。リクエストの受け付けプロセスの最適化やルーチン業務の自動化など、今月のアップグレードで Asana が特におすすめする機能をご紹介します。自動化を極める時間を節約したい方に朗報です。プロジェクトごとに設定できるルールの数が、20 からなんと 50 に大幅アップ。ルール化できる手作業が ...

- [気が散らずに集中できる: 取り組みたい仕事に集中して注意を向けるための新機能をご紹介](/ja/inside-asana/personal-productivity-features)

製品について

現在のナレッジワーカーは、今までになく分散しています。また、集中力もさらに低下しています。実際、「仕事の解剖学」インデックスによると、80% の従業員が受信箱やコミュニケーションアプリを開いたまま仕事をしており、75% 近くが日中マルチタスクに追われていると感じていると答えています。その結果、個人の効率は低下し、重要なメッセージや締め切りを見逃す可能性が高 ...

- [Asana のゴール機能を使って「見える化のピラミッド」を構築する方法](/ja/inside-asana/pyramid-of-clarity)

製品について

#### コンテンツライター

チームリーダーの最も重要な責任の一つは、組織の目標を支える仕事を正しく優先できるよう、チームメンバーを支援することです。とはいえ、言うは易し行うは難し。現実を見れば、チームは常に膨大な数のプロジェクトに同時並行で取り組んでいても、そのすべてが優先度が高く、インパクトのある仕事というわけではありません。では、優先度の低い細々した仕事を脇に置き、全員が限りある ...

- [Move projects from spreadsheets to Asana: introducing the CSV importer](/ja/inside-asana/import-csv-asana-projects)

製品について

It starts out simple: You kick off a project by creating a spreadsheet with the list of to-dos that need to get done. Then you list the teammates tackling the work in the next col ...

- [製品について](/inside-asana/product)