Hello, is it possible for Make (Integromat) to view a file in one format (.xlsx) and save it as a .csv file? Or if there’s a process that changes a file’s format to .csv as an example?
I have a client who needs their file changed from .xlsx to .csv. They use Qualtrics to upload their records from yardi but Yardi is unable to extract .csv files.
If this helps I have my own app that has some useful modules, one of them is
This module takes a xls/xlsx binary file and converts it into an object or bundle
The app is completely free and you can add it to your account via this link - https://eu1.make.com/app/invite/f584d5c7f923e107e8a816a9ccf066f7
1 Like
Hi. You can use Cloudconvert too. Its a very good service with modules in Make.
If you need additional support, please don’t hesitate to reach out.
Cheers
//HFBR
@Randy_Agyeman-Danso If you have a gWorkspace account, you can use the Drive API to export a google sheet as a CSV. We’ve been using this for multiple clients and working perfectly
I have also had success with CloudConvert with various files.
Thanks for your reply! Does this work on a macbook? I keep seeing 401: Access Denied error screen when I click the link and login.
1 Like
Thanks for your reply! How does cloud convert work? I’m having trouble with the initial setup. Also, can files be automatically dropped into Cloud conver?
Yeah this is just an invite link for the app.
@Randy_Agyeman-Danso here you go:
Use the modules google sheets or excel to open the xlsx
Aggregate everything to CSV by using Create CSV
Replace Chars that might break the CSV
Save it in this case I used Email.
1 Like
Thanks for your response! If I’m sending a file daily to an SFTP Server, is the process as follows?
Find File in SFTP
I do not see an option to Open the xlsx. I am using list table rows
Create .csv
Use text parser
Send back to SFTP instead of email.
Does this make sense?
2 Likes
rabin
January 21, 2023, 8:14pm
11
Hi,
If you mean that you are unable to install the application of the talented @EyalGershon !!
Try this link:
https://us1.make.com/app/invite/f584d5c7f923e107e8a816a9ccf066f7
1 Like
Thinus
March 4, 2023, 9:25am
13
Hi EyalGerson, As I’m fairly new to MAKE, can you please give us an example of a workflow on how to use your toolbox to convert an xlsx to csv?
(My use case is receiving a url from webhook, convert to csv, send back via api call)
Thanks!
For instance if you use a mail hook and get n attachment you could convert that.
Any case where it’s an xls/xlsx in binary format it will work.
1 Like
Sorry, replied from my mobile earlier, I see you asked how do you use this module when you get a file URL via webhook… so here goes:
Use the HTTP - Get a File module and map the file URL to the URL field in the module.
Add my module and it will automatically map the data from the earlier module.
Sit back and enjoy your scenario
1 Like
Thinus
March 16, 2023, 12:58pm
16
Thanks!
Can I use your plugin to export to an api?
what do you mean by export to API ?
If you want to know how I did it, I used node.js with this package - https://www.npmjs.com/package/convert-excel-to-json