Controling the cell format of Excel for Sugar exports

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

  • 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. 

  • 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

  • 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.