Export DataIku dataset to Excel
![grauco](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar7.png)
Dear experts,
I have been trying to understand how I could export an existing DataIku dataset to Excel. By studying the documentation, I suppose there might be an API functionality allowing me to achieve it, but unfortunately I could not find it.
More in details:
- I have created a dataset in my DataIku project using a python recipe;
- I would like to understand if it would be possible to export this dataset to Excel, and eventually how to do it.
I really thank you in advance for any help you may give me.
Giorgia
Answers
-
Hi Giorgia,
Exporting to Excel (and to other formats) is available from the right panel on the flow. You have to click on a dataset, then on "Export" at the top of the right panel, and then chose the Excel format.
The dataset will be downloaded as xlsx file.
-
tim-wright Partner, L2 Designer, Snowflake Advanced, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 77 Partner
Giorgia,
yes it is possible to export a dataset to Excel. Within your flow, double click on the dataset that you want to export. Select "Actions" in the top right to bring out the panel with options for what you can do with the dataset. There should be an option at the top called "export" -- see image below.
From within the dialogue that pops up, you can select an xlsx format for which to download the data to your local machine. You probably wouldn't want to try this from a particularly large dataset, but I think that should do it for you.
-
tim-wright Partner, L2 Designer, Snowflake Advanced, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 77 Partner
-
Hi @Andrey
,Thanks a lot for your fast and kind reply.
I apologize if I didn't explain clearly my needs. What I am trying to understand is if there would be a way to access the dataset from Excel (really from the Data -> GetData -> From... tabs), without the need to explicitly connect to DataIku once the dataset has been created and published on the base.
Thanks again a lot and kind regards,
Giorgia
-
I don't think we have any special integration with Excel apart from export to xlsx files.
However as I can see Excel supports import from SQL server DB, so you may try to write into SQL Server Dataset using your python code in Dataiku and read it by Excel from another end, but without knowing your use case it looks like an overkill.
-
Ignacio_Toledo Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 412 Neuron