Cách chuyển file ms project sang excel
When managing a project in Project for the web, you can export your project to Excel. Having your project data in an Excel tệp tin allows you to:
Send a tệp tin containing project details to external stakeholders
Create reports and visuals
Archive copies of your project data for audit & compliance
Print copies of your project
Here"s how to lớn export your project:
Go to project.yeahflashback.com.com and open the project you want lớn export khổng lồ Excel.
Bạn đang xem: Cách chuyển file ms project sang excel
In the đứng 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 xuất hiện 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 and 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 to your stakeholders, you can also export your project data khổng lồ Excel for in-depth data analysis and 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 to 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, and under Other tệp tin Types, double-click yeahflashback.com Excel Workbook.
(In Project 2010, choose File > Save As, & next khổng lồ Save as type, choose Excel Workbook.)
In the Save As dialog box, pick a location for the workbook.
In the File name box, type the name you want, and choose Save.
The Export Wizard appears.
Choose Next to get started.
On the Data step, choose Selected Data, if it’s not already selected.
Xem thêm: Hãy Yêu Nhau Dưới Ánh Trăng Năm Nào " (Kiếm Được 4 Bài), Điệu Buồn Đêm Trăng Lyrics
On the Map step, choose New map khổng lồ create your own data settings for mapping your data from Project fields khổng lồ appropriate Excel fields.
To use a predefined or previously defined map, choose Use existing map, and then pick the maps you want to use.
On the Map Options step, pick the types of data you are exporting và 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, và then press Enter.
Use the buttons below the mapping table to insert or remove rows, or apply a Project table for mapping.
Use the Move buttons lớn rearrange fields.
Under Preview, verify the layout of your export map.
If needed, pick a specific export filter in the Export filter box.
Choose Next.
On the End of map Definition step, choose Save Map if you want lớn use it again, & type a name in the Map name box. The new bản đồ will be added to the list of predefined maps.
Click Finish.
To view your exported project data, open the workbook in Excel.
Work with your project data in Excel
After you xuất hiện 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 quickly clean up columns of data, for example to change numbers khổng lồ dates, or text khổng lồ numbers.
Then you can analyze và format your data to create the visual reports you want: