Importing Excel spreadsheet to an existing Smartsheet

Hi,

I need to import Excel spreadsheet to an existing Smartsheet that already have DataMesh set up. It's not feasible to copy and paste 500 rows at a time since the Excel has many more rows than that. DataShuttle also would not work because while I can save the Excel in OneDrive, it requires additional permissions to connect SmartSheet to the company OneDrive due to possible confidential and private data.

If this is not an option, SS needs to make it an option, and increase the number of rows/columns that can be copied at one time.

Answers

  • ChristianFinke
    ChristianFinke ✭✭✭✭✭

    Hi @Jayy S.

    If DataShuttle and copy-pasting aren’t options, one workaround is to split the Excel file into smaller chunks and import each chunk individually. I know this isn't ideal with so many rows.

    Or, if you have admin support, they might be able to help with the permissions needed to connect OneDrive to Smartsheet for a smoother import via DataShuttle.

    Let us know if you need further assistance.

    Best,

    CHRISTIAN FINKE

    cfinke@digitalradius.com

    Schedule a Meeting