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

Questions & Answers
1

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.

2

If this helps I have my own app that has some useful modules, one of them is :slight_smile:

image

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
3

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

4

@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 :wink:

Screenshot_172
Screenshot_172442×810 28.2 KB

5

I have also had success with CloudConvert with various files.

6

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.

image
image772×606 22.3 KB

1 Like
7

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?

8

Yeah this is just an invite link for the app.

9

@Randy_Agyeman-Danso here you go:

  1. Use the modules google sheets or excel to open the xlsx
  2. Aggregate everything to CSV by using Create CSV
  3. Replace Chars that might break the CSV
  4. Save it in this case I used Email.

image
image2324×932 173 KB

1 Like
10

Thanks for your response! If I’m sending a file daily to an SFTP Server, is the process as follows?

image
image775×159 25.4 KB

  1. Find File in SFTP
  2. I do not see an option to Open the xlsx. I am using list table rows
  3. Create .csv
  4. Use text parser
  5. Send back to SFTP instead of email.

Does this make sense?

2 Likes
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
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!

14

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
15

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:

  1. Use the HTTP - Get a File module and map the file URL to the URL field in the module.
  2. Add my module and it will automatically map the data from the earlier module.
  3. Sit back and enjoy your scenario :slight_smile:

image
image2770×825 192 KB

1 Like
16

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

17

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

18

Yes, it is possible to do this with Integromat. Integromat allows you to connect with a variety of services and applications, including cloud storage services like Google Drive, and it has built-in modules that you can use to convert files between different formats. All you have to do is create a scenario that connects to the cloud storage service where the .xlsx file is located, converts it to .csv format, and then stores the .csv file on a cloud storage service or other destination of your choice. You can find more information about Integromat’s modules and services here: https://www.integromat.com/en/support/modules/

1 Like
19