Export to Excel and Format Options

James T Sidebotham

Hi, when I export to an Excel file, I have a column that I want to be shown as a number format. In Aperture I use the 'To Number' function prior to exporting. But when I open the file in Excel, the type is 'Custom' (#,###), and zero's are not showing. I can change Aperture export type as Alphanumeric, and that shows zeros in Excel, but then I get the error checking on each value.

So how can I export in Excel and make sure my numeric columns are shown as numeric (and preserve zero).

Thanks

Josh Boxer

Hi James

If you can give some example values and how you would like them to appear in Excel when a file is opened.

You could try a different filetype some detailed explanation on XLSX storage here:

https://community.experianaperture.io/discussion/149/floating-point-numbers-with-microsoft-excel-open-xml-spreadsheet-xlsx-files

Another option is to use OData to refresh the data in an existing Excel sheet with as much formatting previously applied retained:

https://community.experianaperture.io/discussion/597/%EF%BB%BF-%E2%84%B9%EF%B8%8F-%EF%BB%BF-importing-your-datasets-into-excel-or-tableau-using-odata

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/prepare-and-move-data/use-odata/