FAQs Import/Export
Browse by Category
FAQ › How do I...? › Category: Import/Export
What is Smartsheet?
What is Smartsheet?
Question Link
Question Link
Why can’t I see all the columns imported from Smartsheet file?
Why can't I see all the columns imported from Smartsheet file?
Question Link
Question Link
How do I import both Tasks and Resources from Excel file?
How do I import both Tasks and Resources from Excel file?
Question Link
Question Link
Answer
Data is imported to 2 distinct data areas: Task or Resources.Imports will not update more than one data area at the same time.Excel datasheets will need to be divided into these areas of data.For example, if you want to import information about both Tasks and Resources, your Excel file will need to have two sheets, one with information about tasks and one about resources.
Why can’t I see all the columns imported from Excel file?
Why can't I see all the columns imported from Excel file?
Question Link
Question Link
What should I know before starting to import the Excel file in Project Plan 365 app?
What should I know before starting to import the Excel file in Project Plan 365 app?
Question Link
Question Link
Answer
1. Be aware of which Excel file fields will be mapped to which Project Plan file fields before starting the Import Wizard.
2. Not all fields in the Excel field are required to be imported. When mapping the columns from your file you will have the opportunity to pick which fields you will import by deleting the unnecessary ones (using the Delete Row button).
3. Make sure you know which Excel file tab names will be imported into which data areas within Project Plan. e.: Task data, Resource data.
4. Be aware if your import file has column headers.
5. Blank lines in the Excel file will be imported as blank lines in the project file.
6. Start and Finish dates when imported into the Start and Finish fields in Project Plan 365 will create Start No Earlier Than constraints for the tasks.
2. Not all fields in the Excel field are required to be imported. When mapping the columns from your file you will have the opportunity to pick which fields you will import by deleting the unnecessary ones (using the Delete Row button).
3. Make sure you know which Excel file tab names will be imported into which data areas within Project Plan. e.: Task data, Resource data.
4. Be aware if your import file has column headers.
5. Blank lines in the Excel file will be imported as blank lines in the project file.
6. Start and Finish dates when imported into the Start and Finish fields in Project Plan 365 will create Start No Earlier Than constraints for the tasks.
What changes do I need to make to the excel file before importing it in Project Plan 365 app?
What changes do I need to make to the excel file before importing it in Project Plan 365 app?
Question Link
Question Link
Answer
Before importing your Excel file in our application please make the following changes:1. Create any customized fields before starting the import process.
2. Make sure the customized fields are of the same data type as the fields that will be imported from Excel. I.e.: Text into Text, Date into Date.
3. When possible, create the customized field names to match the names in the Excel file. Optional but helpful.
2. Make sure the customized fields are of the same data type as the fields that will be imported from Excel. I.e.: Text into Text, Date into Date.
3. When possible, create the customized field names to match the names in the Excel file. Optional but helpful.
What is Microsoft Excel?
What is Microsoft Excel?
Question Link
Question Link
What does the “Export to XML” functionality do?
What does the “Export to XML” functionality do?
Question Link
Question Link
What does the “Export to Word” functionality do?
What does the “Export to Word” functionality do?
Question Link
Question Link
What does the “Export to PowerPoint” functionality do?
What does the “Export to PowerPoint” functionality do?
Question Link
Question Link
How can I export a project to PDF without using the Export functionality from Project Plan 365?
How can I export a project to PDF without using the Export functionality from Project Plan 365?
Question Link
Question Link
How can I export a report to PDF?
How can I export a report to PDF?
Question Link
Question Link
Can I convert a project exported as PDF back to a Project MPP file?
Can I convert a project exported as PDF back to a Project MPP file?
Question Link
Question Link
What does the “Export to PDF” functionality do?
What does the "Export to PDF" functionality do?
Question Link
Question Link
How do I export a project to MPP?
How do I export a project to MPP?
Question Link
Question Link
How can I export the project to PDF?
How can I export the project to PDF?
Question Link
Question Link
I want to export the Resource Usage data into Excel (CSV). However, I can only export the total usage in hours. How can I export the breakdown of month?
I want to export the Resource Usage data into Excel (CSV). However, I can only export the total usage in hours. How can I export the breakdown of month?
Question Link
Question Link
When I export to a PDF it is unreadable.
When I export to a PDF it is unreadable.
Question Link
Question Link
Can I export a project to a powerpoint file?
Can I export a project to a powerpoint file?
Question Link
Question Link
How can I export my project to a XML file?
How can I export my project to a XML file?
Question Link
Question Link
Can I export my project information to a word file?
Can I export my project information to a word file?
Question Link
Question Link