Not able to import CSV File

Tamizamuthan Vedachalam

The following sheets exist in the Smartsheet and use Data Uploader to acquire data. The data uploader is mapped with Google Drive to acquire the source files.

UserCurriculumStatusSummaryCSV - 500+ rows

CurriculumItemStatusCSV - 10000+ rows

Recently Google Drive is NOT working, so I am trying to manually upload the files directly to those 2 sheets using FILE --> IMPORT --> IMPORT MICROSOFT EXCEL

File Names are

UserCurriculumStatusSummaryCSV

Curriculum Item Status Detail (CSV)

1. I disabled the Data Uploader scheduled job and performed manual upload - Not working
2. Renamed my input files with the actual sheet name in Smartsheet Ex - Curriculum Item Status Detail (CSV) RENAMED as CurriculumItemStatusCSV - Not working

Neither of the attempts did NOT helped. What could be the possible reason for this failure?

Tamizamuthan Vedachalam

That would be really helpful! Appreciated your response.

Paul Newcome

Have you tried reformatting the file type itself from .csv to .xls?

Tamizamuthan Vedachalam

Hi Paul,

Yes, I tried formatting it for xls. It doesn't help, its just uploading the values, but the SAVE button is not enabled.

Paul Newcome

If it is uploading the values then it is working as it is intended. Which save button are you referring to?

Tamizamuthan Vedachalam

Hi Paul,

This is the Save Button I am referring too.

Also, I am having few more challenges. Using this data sheet I am currently performing copy and paste values on daily basis. This sheet has multiple formulas written in SUMMARY option and calling those values in a Dashboard.

Also, I am calling these values in another sheet to additional calculations to represent in dashboard.

Is there any way to upload the values from a source sheet (saved from my desktop) and upload to his sheet. Without disturbing other settings and just replace the values inside the sheet.

Also, I tried importing the values as per your suggestion and these are the sequential steps

However, after uploading the sheet. It's been generated as new sheet and my calculations in the Summary options are removed. My requirement is to upload the values in the sheet and that should reflect in the dashboard

Paul Newcome

TO upload into an existing sheet, you are going to need to either copy/paste the data or go back to using data uploader. Importing a document into Smartsheet will always create a new sheet.

Tamizamuthan Vedachalam

Currently, we don't have subscription to Data Uploader. Also, copy and paste will allow only 500 rows per attempt. Is there any other options ?

Andrée Starå

Hi @Tamizamuthan Vedachalam

To add to Paul's excellent advice.

Another option if you have resources could be the Smartsheet API.

Is that an option?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Andrée Starå I'm glad you stumbled across this one. I was just about to tag you to see if you had any other ideas.

Tamizamuthan Vedachalam

Hi Andree,

Thanks for your inputs. I already discussed Smartsheet API with you few months back.

Andrée Starå

@Paul Newcome 😎

@Tamizamuthan Vedachalam

Happy to help!

Ah. Ok. Time flies!

Data Uploader is probably the best option.

I'll let you know if I come to think of some other way to solve it.

Tamizamuthan Vedachalam

Hi Andre,

We are getting feed file from SAP SuccessFactors emailed to outlook. I used Trial version of Data Uploader and that worked good. I need to manually drop the file in path and Data Uploader updated the rows.

The SAP SuccessFactors can drop their file in their SFTP path and to make Smartsheet to pick the file, you suggseted Smartsheet API and this conversation occured 1 month ago

however, client dont have preference to buy additional tools you suggested. Hence, I used this option to manually copy paste the rows from file i received through outlook.

Atleast I was expecting some options to copy and paste more than 500 Items or uploading the values from Desktop to Smartsheet could have it can make it bit easier

Andrée Starå

@Tamizamuthan Vedachalam

Ok.

Maybe we'll see some limit increase at this year's Engage conference.

Tamizamuthan Vedachalam

That would be really helpful! Appreciated your response.