How to import a folder of .xlsx files and save each file as .csv file in the same folder
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
TimOzirsky
8 - Asteroid
‎09-24-2024
11:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Will someone please let me know How to import a folder of .xlsx files and save each file as .csv file in the same folder?
I found the Directory tool to read the folder and now what.
Thank you
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
binuacs
21 - Polaris
‎09-24-2024
01:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@TimOzirsky one way of doing this with the batch macro
‎09-24-2024
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am sorry, that didn't work for me.
I should have said that I want the work flow to open each xlsx file and save each file as a csv file using the xlsx file name in the same folder.
For example, open B0-0.xlsx and save it as B0-0.csv.
Thank you
binuacs
21 - Polaris
‎09-24-2024
03:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@TimOzirsky That is exactly the above workflow does, what is the error you are facing?
TOzirsky
7 - Meteor
‎09-24-2024
03:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can't find any files created by the macro. Do I need to edit a path somewhere or ?
Thank you
