SOLVED
Converting .CSV to xlsx - Bunch of files
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
sriniprad08
11 - Bolide
‎10-12-2021
01:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Hope you are well.
I need help. I have a folder with .csv files. Is there a macro which can append all the .csv files and convert them into .xlsx format ?
Please let me know ,
thanks,
Sri
Solved! Go to Solution.
Labels:
- Labels:
- Batch Macro
7 REPLIES 7
Hamder83
11 - Bolide
‎10-12-2021
01:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎10-12-2021
02:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08
Just adding a guide on how to downgrade packaged workflows and macros
Hope this helps : )
‎10-12-2021
03:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hamder83 ,
Thank you so much. Its working. However all the columns are coming in the single row. how to get the data in the separate column please?
thanks,
Sri
‎10-12-2021
03:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-12-2021
03:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hamder83
11 - Bolide
‎10-12-2021
04:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
if you right click the macro and set the delimiter to comma as in your input file 🙂
‎10-12-2021
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
