Why is copy and paste adding characters?

I am trying to copy and paste rows over from Excel to Smartsheets. It does work; however, it is adding extra characters to smart sheet.

I attached a picture so you can see. Here is the original excel, and then what it looks like in Smartsheet.

Is there any work around this?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @mloveday87

Since Smartsheet and Excel are separate programs there can be differences when data is copy/pasted from one to the other. What type of data in the excel file is turning into characters in Smartsheet, is it possible that there is a formula in excel that Smartsheet doesn't recognize?

Would you be able to post the excel file you're using with sample data? I'd like to test this on my own account to see what could be the cause.

Thanks!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.