Devart Excel Add-in for Sugar allows you to connect Microsoft Excel to Sugar, quickly and easily load data from Sugar to Excel, instantly refresh data in an Excel workbook from Sugar, edit these data, and save them back to Sugar.
It enables you to work with Sugar contacts, accounts, opportunities, tasks, and other objects like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.
Connect Microsoft Excel to Sugar. Work with live data directly in Excel. Modify external data easily. Save modified data back to the data source.
Features and Benefits
Edit Sugar Data Like Usual Excel Spreadsheets
To edit Sugar data in Excel you need just to click the Edit Mode button on the ribbon before editing, and then you can edit data just like you usually do it - add or delete rows, modify cell values, etc. All the changes are highlighted so you can easily see which data is changed.
After you finish editing, simply click Commit to write changes to Sugar or Rollback to cancel changes.
View All FeaturesUse Query Builder or SQL to Import Data You Need
Devart Excel Add-in for Sugar provides advanced SQL support for Sugar, and allows you to use complex SQL queries to get exactly the data you need.
View All FeaturesInstant Data Validation
Devart Excel Add-in for Sugar instantly validates entered data and highlights errors, such as incorrect dates, duplicate primary key values, etc.
View All FeaturesConnect to Sugar Directly from Excel
To connect Excel to Sugar you just need to specify the host to connect and your credentials.
Connection information may optionally be stored in the Excel file, or you may reenter it whenever necessary.
View All FeaturesEdit Sugar Data Like Usual Excel Spreadsheets
To edit Sugar data in Excel you need just to click the Edit Mode button on the ribbon before editing, and then you can edit data just like you usually do it - add or delete rows, modify cell values, etc. All the changes are highlighted so you can easily see which data is changed.
After you finish editing, simply click Commit to write changes to Sugar or Rollback to cancel changes.
Use Query Builder or SQL to Import Data You Need
Devart Excel Add-in for Sugar provides advanced SQL support for Sugar, and allows you to use complex SQL queries to get exactly the data you need.
Instant Data Validation
Devart Excel Add-in for Sugar instantly validates entered data and highlights errors, such as incorrect dates, duplicate primary key values, etc.
Connect to Sugar Directly from Excel
To connect Excel to Sugar you just need to specify the host to connect and your credentials.
Connection information may optionally be stored in the Excel file, or you may reenter it whenever necessary.
Support
Phone Support: -Support Email: support@devart.com
Support Knowledge Base: https://www.devart.com/excel-addins/support.html
Terms & Conditions
Terms of Service: https://www.devart.com/using-website/terms-of-use.htmlPrivacy Policy: https://www.devart.com/using-website/privacy-policy.html
