When managing a project in Project for the website, you can export your project to Excel. Having your project data in an Excel tệp tin allows you to:
Sover a file containing project details khổng lồ external stakeholders
Create reports và visuals
Archive sầu copies of your project data for audit và compliance
Print copies of your project
Here"s how to lớn export your project:
Go khổng lồ project.tuyonline.vn.com và open the project you want to lớn export to Excel.
Bạn đang xem: Cách chuyển từ project sang excel
In the top right corner, select the three dots (...), then select Export lớn Excel.
When you see the message "All done! We"ve exported
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, & the start & finish dates, duration, và 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 lớn your stakeholders, you can also export your project data to lớn Excel for in-depth data analysis và visual reporting. In Excel, you can create PivotTable reports, charts, và use many other features that help you create a more visual report.
You’ll have sầu to lớn maps 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, và under Other File Types, double-clichồng tuyonline.vn Excel Workbook.
(In Project 2010, choose File > Save As, and next to lớn Save as type, choose Excel Workbook.)
In the Save sầu As dialog box, pichồng a location for the workbook.
In the File name box, type the name you want, và 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.
On the Map step, choose New map to create your own data settings for mapping your data from Project fields to appropriate Excel fields.
To use a predefined or previously defined bản đồ, choose Use existing map, & then piông chồng the maps you want khổng lồ 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, và enter any new mapping fields:
In the From column, type or select a Project field, and 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 khổng lồ 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.
On the End of Map Definition step, choose Save Map if you want to lớn use it again, và type a name in the Map name box. The new map will be added lớn the các mục of predefined maps.
To view your exported project data, open the workbook in Excel.
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 to lớn quickly clean up columns of data, for example to lớn change numbers to lớn dates, or text lớn numbers.
Then you can analyze and format your data to lớn create the visual reports you want: