AnsweredAssumed Answered

Controling the cell format of Excel for Sugar exports

Question asked by Hugo Geyskens on Dec 6, 2018
Latest reply on Jan 23, 2019 by Rolustech Support

Like • Show 0 Likes0
Comment • 3

Hi there,

When I export the Contacts list from Sugar to Excel, the phone numbers in some cases get 'corrupted', since Excel (I assume) tries to interprete them as formulas in about 10% of the cases.

An example

Sugar : +49 4131/77- 2536

Excel interpretes as ; =102,649350649351- 2536

Excel displays the result : -2433,350649

Reason is , that the Phone info is exported into a 'General' formatted cell of Excel.

If I could switch those phone info cells to Text formatting , all would be fine.

Does anybody has a trick how I can fix this in the Export of Sugar ?

Thanks !

Hugo

No one else has this question

Outcomes

3 Replies

Rolustech Support Dec 27, 2018 10:34 PM
Mark Correct
Correct Answer
Hi Hugo,

Out of the box, Sugar exports the records in a CSV file and not an excel file. By Excel File I am assuming .xlsx or .xls file. Are you using a plugin to export the records? Because if so, it could be a plugin specific issue.
Try exporting the records as a csv file and you should be good to go.

Let me know if this solves your problem.
Like • Show 0 Likes0
Actions
- Hugo Geyskens @ Rolustech Support on Jan 2, 2019 2:54 AM
  Mark Correct
  Correct Answer
  Hi there,
  The issue seems to be that after the SalesOne .csv export finishes, you cannot have that .csv file directly opened in Excel via the 'Open File' button in the webbrowser. You...
  first need to launch Excel
  than open a blank Workbook
  and than import the (saved) .csv as usual.
  Only via that procedure the phone numbers are entered/formated as intended.
  I don't know what Excel internal difference exists between the 2 procedures...They look very similar to me.
  
  Thanks for your reply anyway!
  
  Bey now
  Hugo
  Like • Show 0 Likes0
  Actions
  - Rolustech Support @ Hugo Geyskens on Jan 23, 2019 1:46 AM
    Mark Correct
    Correct Answer
    Hi Hugo,
    
    Glad to know that you figured out the issue. However this is a known issue in some versions of Excel i.e. 2013 and 2016 that it doesn't open the CSV files properly. You have to manually import them again. It's not an issue with the CSV that Sugar generates rather an issue on the Excel side. Let us know if you have any other questions.
    Like • Show 0 Likes0
    Actions

Controling the cell format of Excel for Sugar exports

Outcomes

Related Content

Recommended Content