nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Export dataset or project to an Excel file type format

Benjamin Arnulf-Oracle

Description

Customers are requesting the ability to export a dataset or a project (canvas) to an Excel file type format and NOT only in CSV as it's not keeping the format they need.

Use Case and Business Need

Customers are requesting the ability to export a dataset or a project (canvas) to an Excel file type format and NOT only in CSV as it's not keeping the format they need.

Original Idea Number: 0f7a65076d

Find more posts tagged with

Delivered

Data Connectivity

Analysis and Data Visualization

Status: Delivered

Comments

Juan Diego Ruiz-Oracle

This is needed as some customers first do self-service analysis and then they want to share the results with excel savvy people who want to continue their analysis in excel. Respecting the format of tables and pivot tables is needed for that.

Bill_Marcellus

We've had many users ask why they can't export to excel and complain that their pivot tables are not retaining the same format when they export to CSV. If you include a column in your pivot (e.g. MONTH), the CSV exports it as a flat detailed list, and loses the pivot summarization... For example:

Pivot in OAC appears as:

Customer	Jan	Feb
A	100	200
B	400	500

After exporting to CSV, appears as:

Customer	Month	Amount
A	Jan	100
A	Feb	200
B	Jan	400
B	Feb	500

Wilian Perone

The ability to transform and/or share insights/information from a DV project in excel, respecting minimal formatting would be of high added value.

Myles Gilsenan-195859

Perficient as a company has standardized on OAC for enterprise reporting and dashboards. Although we typically discourage exporting to Excel if it can be avoided, there are several use cases at our company where there is a need to export a visualization or a canvas to Excel while keeping the format (the way it worked in OBIEE). The lack of this feature has caused some to think about using Answers for certain use cases. It would be great to have this feature in Data Viz as well.

M_Kumaran

It adds value .

gmigotto

Very welcomed!

ALOK SH-Oracle

Business want to compare the OAC classic output(formatted Excel) and DV view export in CSV. If this feature will be enable it will help business to validate the reports data.

Ursula Ortiz -Oracle

For which version is this planned?

Christian Lex

Due to the local settings of the operating system it is also leading to miss-interpretation of the comma-separated file in Excel if using the csv file. So export is highly appreciated from all users.

Heather Schreiber

Any update on what release this will be in?