Output to a table in Excel from Alteryx

[asuamat]

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!

[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]

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.