Reports in Rex can be exported in .CSV format. CSV format 'frees' your data, making it compatible with Excel or an equivalent. This means you can export your Rex reporting data for use within Excel - allowing you to manipulate your reporting data in far more ways than you were previously able to. This allows you to gain additional information and insights from your Rex reports.
How to export as a CSV
You'll notice when you go to create compatible reports, there's a drop-down button - clicking that will reveal the option to export as CSV.
Excel Tips and Tricks
You may find sometimes when you're exporting data into Excel, the columns aren't sized correctly to show all data entered into the cell. You can easily resize all of the cells at once, so that all of the data is visible:
- Open your Excel spreadsheet.
- Click on a blank cell that isn't amongst your data (for example; the first entry below the last entry in the spreadsheet).
- Select all cells (control+A for Windows or Command+A for Mac)
- Double click the separator between cells (see screenshot below)
The best part about having your data in an Excel spreadsheet is that you can plot the data how you please. For example, we've linked to two Microsoft articles below. One relates to creating tables in Excel, and the other relates to creating charts:
Some things to keep in mind are; there are different versions of Excel, as well as other equivalent software packages capable of opening .CSV files. If your software/version of Excel differs from our tips and tricks and the external help content we've linked to - chances are there is help content available to you that can be sourced from the company who made the program. The other thing to keep in mind is that here at Rex, we know our way around Excel spreadsheets - but for help specifically with Excel/other software's functionality, your best point of call for support will be to contact that company directly.