Copy and Paste from Excel into Smartsheet Project

AlanAlan
edited 12/09/19 in Using Smartsheet
02/08/18 Edited 12/09/19

Hi,

I have a smartsheet project and am wanting to copy and paste multiple cells from a MS excel document into the 'task name' column.

 

Can this be done ?

 

Thank you

 

Alan

 

Previous13

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Alan,

    Absolutely! Just copy and paste as usual.

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • When I select and copy multiple cells from the excel sheet, and paste, they all go into just one cell in the project sheet ?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ok.

    Are the cells in Excel in the same column?

    Which type of column are you pasting it into in Smartsheet? 

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Yes, cells in same column

    Column type in project sheet is 'text/number'

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    That's strange! It works for me.

    Can you check the data in Excel and see what format it is?

     

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • It's a MS Excel for Mac (365 subscription)

    The cells I'm trying to copy/paste are all text. I checked the cell format they are in and it was set to 'number/general'.

    I changed to 'text' but it still doesn't work.

    I am having to copy and paste each cell individually which is a bit of a pain.

    The excel sheet is an estimating sheet which lists all the tasks on a project so we can cost the project.

    I was hoping to just simply copy and paste the tasks straight into a project sheet and then put dates/durations etc against them

     

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Strange!

    If you want you can share the file with me and I'll take a look and see if it works for me.

    One workaround could be to import the excel and copy and paste from one sheet to another inside Smartsheet. 

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thanks Andree

     

    I'll give your second option a try.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Another tip!

    You can also copy or move rows from one sheet to another and if you have the same column on both it will automatically be added to the right one. The columns that don't match up will be added to the sheet as new columns to the far right.

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi,

    I can't copy more than one cell from my excel sheets directly into Smartsheet. I use a MacBook on 365 subscription.

    Has anyone got a solution for this?

    Thanks

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Alice,

    That's strange! It should work. What happens when you try to copy and paste?

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant @ Get Done

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • GBGB
    edited 06/21/18

    Doesn't work for me either, which is annoying as we're looking to convert a load of existing task lists in Excel 2010 into plans in SS.

    Is this linked to the browser, as I'm tied to using IE 11?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    One possible workaround would be to import the excel sheets to Smartsheet and the copy/move the information there.

    Would that work for you?

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant @ Get Done

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andree - 

    I have the same problem. 

    I cannot cut and paste columns of data into or from smartsheet any longer. It did work pre-upgrade but no longer does. Win 10, Chrome or IE.

    Any ideas anyone?

    Thanks,

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Alan,

    How did it go? Did you get a solution to your problem?

    Best,

    Andrée Starå - Workflow Consultant @ Get Done

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.