Pick up .xlsx file and save it as .csv file

Randy_Agyeman-Danso · January 16, 2023, 7:18pm

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.

EyalGershon · January 18, 2023, 8:51am

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

Wemakefuture · January 18, 2023, 9:23am

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

Bjorn.drivn · January 18, 2023, 10:36am

@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

myprojectsolution · January 18, 2023, 12:28pm

I have also had success with CloudConvert with various files.

Randy_Agyeman-Danso · January 18, 2023, 3:07pm

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.

Randy_Agyeman-Danso · January 18, 2023, 3:09pm

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?

EyalGershon · January 18, 2023, 6:00pm

Yeah this is just an invite link for the app.

SebastianMertens · January 19, 2023, 10:04am

@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.

Randy_Agyeman-Danso · January 19, 2023, 6:33pm

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?

rabin · January 21, 2023, 8:14pm

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

Thinus · March 4, 2023, 9:25am

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!

EyalGershon · March 5, 2023, 7:22am

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.

EyalGershon · March 5, 2023, 9:56am

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

Thinus · March 16, 2023, 12:58pm

Thanks!
Can I use your plugin to export to an api?

EyalGershon · March 16, 2023, 1:10pm

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