W-Systems joins SugarCRM! Read Blog

How to Easily Export Excel Sheets from Sugar

by Mihaela Bulacu on February 13, 2020

4 minute read

If you had a penny for every time you struggled to create the perfect document with crucial information and data from your CRM, you would be in Forbes Top 500 by now! The same goes for our team at W-Systems, but we have a trick up our collective sleeve: wDocs’ new Excel exporting features!

Our enhancement builds upon Sugar’s out-of-the-box spreadsheet generation capabilities with custom templates support and quick access. With wDocs, you can create and export complex, presentation-quality reports in XLSX format from Sugar. Read on to find out how! 

Intuitive Template Builder

wDocs includes an intuitive Template Builder tool, which was designed to help users build their spreadsheet templates. Once you install wDocs on your Sugar instance, you can find the extension and the Template Builder in your Sugar’s footer.

wDocs Template Builder

Use the Template Builder to copy and paste appropriate fields in an empty Excel spreadsheet and create your custom template, in several easy steps.

wDocs Template Builder Excel File

Creating Complex Excel Sheets with Just a Couple of Clicks

To create and export documents as Excel files, select one or more records in List View in your module of choice, or go to Record View and use the Merge Document action. 

wDocs Module List View
wDocs Merge Actions

Select which document template to use for merging record information. You can differentiate file formats by looking at your template’s extension.

wDocs Template Drawer

Once the document merge is complete, a pop-up will appear in the wDocs widget in the footer.

the wDocs Sugar footer widget.

Exporting Excel Files from wDocs

This is the last and easiest step you have to follow before you can use your newly created Excel files.

Click the document icon to download your spreadsheet.

wDocs widget Download files.

This is the finished result for the Accounts record used in this example.

wDocs merged document.

While the example we used in this article is fairly simple, note that your templates can be as complex as you need them to be!

Final Thoughts

While Sugar includes some document automation tools, wDocs extends its capabilities and enables you to easily create Word, Excel, or PDF files with just a couple of clicks! If you want to get a closer look at what wDocs can do for you and your business, don’t hesitate to schedule a one-on-one meeting with one of our sales reps. They have all the answers you need!