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

0 Rolustech Support over 5 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Hugo Geyskens over 5 years ago in reply to Rolustech Support
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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rolustech Support over 5 years ago in reply to Hugo Geyskens

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel