Output to a table in Excel from Alteryx

Hi,

I'd like to print the output of an Alteryx workflow into a table in Excel. I am creating an empty table in Excel and then inserting the name of that table to the file path on the Output Tool so that Alteryx knows where to output to (much like using the name of a Named Range to direct Alteryx to output there). However, when I run the workflow and open the Excel file, the table is still not populated and appears empty.

Is it possible to output to a table in Excel from Alteryx?

Thanks!

Workflow

Output

Accepted answers

OTrieger

There is another way by using Blob Tool.

It is working in the following way, you are inputting a template file then you save the template and next step will be to save the data into the template, you will be require to add the range of the text where your wants it to be saved.

Do not write out the whole table, meaning the headers too, as if you will do it you will end in the same issue that you are writing out the whole table, start your range from the row under the headers.

All comments

atcodedog05

Hi @asuamat

Can you provide snapshot of your output tool config.

Tyro_abc

Hi @asuamat

Yes, it is possible. Follow the steps

1. Create an excel file ( Ex. try.xlsx, with field name[ID, Name])

2. In your select tool create the table's field name as your excel file mentioned ( like ID, Name)

3. In the Output Data tool, choose the file and the sheet(where you want to save)

It will say, the file already exists, do you want to replace it? Press the YES button

4. Then it will ask for Sheet and range.

5. Change the field accordingly

I think it's work.

Regards

Arundhuti

MarisaT

Hi, followed steps by @tyro_abc - unfortunately it just inserts the data without keeping the 'table' format

Does anyone else have a suggestion on how to make Alteryx data output into a table format?

Current output:

Current output settings:

Desired output (excel table)

OTrieger

@asuamat
The reason that you get that output is that when you write the data it is overwriting the table that you have in the excel file.

OTrieger

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335