This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Hi
When I try to import excel data into MS Project, I have to select the tab name (which I haven't had to do before if there is only one active tab), but when I try and select the data - nothing is showing.
I have cleared all formatting from the excel file, used 'Task Name', 'Start' and 'Finish' as the data headers and there are no spaces in the file name.
Any ideas, why the data fields are not displaying?
Apologies but could not work out what tags to use, so have selected something so I could post the question!
Thanks
Hi,
You can refer to this article:Import Excel file into MS Project. Task mapping wizard not picking up all fields
Hi Ceasar
Thanks for this article, but unfortunately, I am still unable to import the data correctly from Excel.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 1%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Hi, Try to make your Excel structure similar to Project, watching the column order. I don't know if the column names are important, but if you put the same ones of Project the mapping is automatic: Name, Duration, Start date, End Date, etc. (translate if your Project version is not English). That way it worked to me.
Cheers
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 48%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
I found that a file name length of 15 characters resulting in the tab name of same length also triggers this bug. Renaming the tab name to 11 characters in length (and no spaces), fixed the issue for me.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, thank you guys for the suggested solutions. I had the same issue of not picking up the excel fields. It is strange that when I created a new tab and copy and paste the content from the first tab to the new tab, then choose the new tab name in project, it can pick the excel fields.
However, after I add them all and click next or finish, it just bounces back to ask for the worksheet name again, simply not proceeding to import the data.
Did any of you encounter this and have any ideas?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 93%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
I got the same problem. seems like a new bug. either from office 365 excel or ms project. saying this, because I was able to do it in the old version of ms project and excel
Tab names longer than 11 characters (15 definitely is too long) will also trigger this bug.
Hi
Thanks. That could well be the issue, which it never occurred to me that it might be that. I will check.