Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting .XLS to .XLSX

johnrexrima_19
8 - Asteroid
‎11-06-2019 10:29 PM

Hi everyone,

 

I have a .XLS file downloaded from a website. I wanted to convert the file to .xlsx first before using the file as an input. Do you have any suggestions on how can I make this possible? Thanks.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor
‎11-06-2019 10:33 PM
You could use an output tool and save the file as .xlsx
Reply
0 Likes
RishiK
Alteryx
Alteryx
‎11-06-2019 10:34 PM

@johnrexrima_19 if you are using Alteryx to webscrape and download the data in a workflow (via the Download tool) you can save this as a XLSX file.  However you can simply use a combination of the Select and Output Tool to convert the data to XLSX.

 

Can you share the website you get the XLS files from?

Reply
0 Likes
johnrexrima_19
8 - Asteroid
‎11-06-2019 10:37 PM

@RishiK I am not yet using the Alteryx to download the file from the website - it is downloaded manually. The website is https://securities.citidirect.com.

Reply
0 Likes
johnrexrima_19
8 - Asteroid
‎11-06-2019 10:46 PM

It works! Thanks @JosephSerpis and @RishiK ! 

Reply
go to user group event calendar
Labels