Best way to import large project plan from Excel file?

Smartsheet Student

Hi,

I have a project plan containing 140+ columns and hundreds of rows that I would like to import into Smartsheet. The "Solution Center" import breaks every time in the middle of the upload. As this is a large file, I assumed running a data shuttle would be better. The only issue is, the data shuttle seems to require I individually map all of my columns 1 by 1 to the sheet. I would like to just populate a blank sheet with the data from this file (less than 2mb) without having to add 140 blank columns and individually rename all of them.

Other issue, when I want to add columns to the sheet, it seems like I can only add 5 at a time? To add new columns I need to highlight more columns, thus creating this weird feedback where you need columns for more columns, but you only can do up to 5?

Am I just missing something here? I really hope I am.

Andrée Starå

Hi @Smartsheet Student

I hope you're well and safe!

• Have you tried splitting the Excel file into multiple imports instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!