Cách chuyển file ms project sang excel

Máy khách Để bàn vietmac.com.vn Project Online Dự án đến web Project Professional 2021 Project Standard 2021 Project Professional 2019 Project Standard 2019 Project Professional năm nhâm thìn Project Standard năm nhâm thìn Project Professional 2013 Project Standard 2013 Project 2010 Project Standard 2010 Xem thêm...Ít hơn

When managing a project in Project for the website, you can export your project to Excel. Having your project data in an Excel file allows you to:

Send a tệp tin containing project details lớn external stakeholders

Create reports and visuals

Archive sầu copies of your project data for audit and compliance

Print copies of your project

Here"s how lớn export your project:

Go khổng lồ project.vietmac.com.vn.com and open the project you want lớn export lớn Excel.

You watching: Cách chuyển file ms project sang excel

In the top right corner, select the three dots (...), then select Export to Excel.

*

When you see the message "All done! We"ve exported ." at the bottom of the screen, you can look for your new Excel tệp tin where you store your downloads.

When you open the Excel file containing your project, you"ll see a tab called "Project tasks" that contains a summary of project-wide information at the top, including its name, project manager, và the start & finish dates, duration, and percent complete for the whole project. You"ll also see what date it was exported. Under that, you"ll see a table of all the information for your project.


While Project desktop has many built-in reports that let you present all sortsof project data to lớn your stakeholders, you can also export your project data lớn Excel for in-depth data analysis và visual reporting. In Excel, you can create PivotTable reports, charts, & use many other features that help you create a more visual report.

You’ll have lớn map your project data for proper arrangement in Excel, but the Export Wizard will guide you along the way.

Choose File > Export > Save Project as File, and under Other File Types, double-click vietmac.com.vn Excel Workbook.

*

(In Project 2010, choose File > Save As, và next lớn Save sầu as type, choose Excel Workbook.)

In the Save As dialog box, piông xã a location for the workbook.

In the File name box, type the name you want, & choose Save.

The Export Wizard appears.

*

Choose Next lớn get started.

On the Data step, choose Selected Data, if it’s not already selected.

See more: 3 Mẹo Khắc Phục Điện Thoại Bị Treo Màn Hình, Mẹo Đơn Giản Xử Lý Điện Thoại Samsung Bị Treo

On the Map step, choose New map to create your own data settings for mapping your data from Project fields to lớn appropriate Excel fields.

To use a predefined or previously defined maps, choose Use existing map, and then piông xã the bản đồ you want to lớn use.

On the Map Options step, piông chồng the types of data you are exporting & the options you want.

On the Task Mapping, Resource Mapping, or Assignment Mapping steps, edit any mapping assumptions Project made, and enter any new mapping fields:

In the From column, type or select a Project field, & then press Enter.

Use the buttons below the mapping table lớn insert or remove rows, or apply a Project table for mapping.

Use the Move buttons to rearrange fields.

Under Preview, verify the layout of your export bản đồ.

If needed, piông xã a specific export filter in the Export filter box.

Choose Next.

On the End of Map Definition step, choose Save sầu Map if you want lớn use it again, and type a name in the Map name box. The new bản đồ will be added to the danh mục of predefined maps.

Cliông xã Finish.

To view your exported project data, open the workbook in Excel.

See more: Những Câu Chuyện Để Nói Với Bạn Gái Thú Vị Và 4 Kỹ Năng Ghi Điểm Với

Work with your project data in Excel

After you open your workbook in Excel, you might notice that some data didn’t come in quite as you expected. No problem! In Excel, you can use Flash Fill khổng lồ quickly clean up columns of data, for example lớn change numbers to lớn dates, or text khổng lồ numbers.

Then you can analyze và format your data khổng lồ create the visual reports you want: