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

**URL:** https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824
**Category:** Questions
**Created:** [January 16, 2023, 7:18pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824 "2023-01-16T19:18:11Z")
**Posts on this page:** 18
**Page:** 1

<div class="post-metadata">

### Author: ![Randy\_Agyeman-Danso](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Randy\_Agyeman-Danso](https://community.make.com/u/Randy_Agyeman-Danso)
#### Post date: [January 16, 2023, 7:18pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/1 "2023-01-16T19:18:12Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![EyalGershon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/eyalgershon/32/6551_2.png) [@EyalGershon](https://community.make.com/u/EyalGershon)
#### Post date: [January 18, 2023, 8:51am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/2 "2023-01-18T08:51:56Z")

</div>

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

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/28ac10f97350e4a5e563262008addaf97ac274e8.png)

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](https://eu1.make.com/app/invite/f584d5c7f923e107e8a816a9ccf066f7)

---

<div class="post-metadata">

### Author: ![Wemakefuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/wemakefuture/32/103_2.png) [@Wemakefuture](https://community.make.com/u/Wemakefuture)
#### Post date: [January 18, 2023, 9:23am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/3 "2023-01-18T09:23:30Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Bjorn.drivn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/bjorn.drivn/32/4503_2.png) [@Bjorn.drivn](https://community.make.com/u/Bjorn.drivn)
#### Post date: [January 18, 2023, 10:36am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/4 "2023-01-18T10:36:55Z")

</div>

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

 ![Screenshot_172](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/1/1970b8efb3457ec0de7d04b872da072a5f4f78d1.png)

---

<div class="post-metadata">

### Author: ![myprojectsolution](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/myprojectsolution/32/5307_2.png) [@myprojectsolution](https://community.make.com/u/myprojectsolution)
#### Post date: [January 18, 2023, 12:28pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/5 "2023-01-18T12:28:51Z")

</div>

I have also had success with CloudConvert with various files.

---

<div class="post-metadata">

### Author: ![Randy\_Agyeman-Danso](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Randy\_Agyeman-Danso](https://community.make.com/u/Randy_Agyeman-Danso)
#### Post date: [January 18, 2023, 3:07pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/6 "2023-01-18T15:07:59Z")

</div>

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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/4/488446fe89a2edf4137cec7c2acb614179534943.png)

---

<div class="post-metadata">

### Author: ![Randy\_Agyeman-Danso](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Randy\_Agyeman-Danso](https://community.make.com/u/Randy_Agyeman-Danso)
#### Post date: [January 18, 2023, 3:09pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/7 "2023-01-18T15:09:07Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![EyalGershon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/eyalgershon/32/6551_2.png) [@EyalGershon](https://community.make.com/u/EyalGershon)
#### Post date: [January 18, 2023, 6:00pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/8 "2023-01-18T18:00:07Z")

</div>

Yeah this is just an invite link for the app.

---

<div class="post-metadata">

### Author: ![SebastianMertens](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sebastianmertens/32/4439_2.png) [@SebastianMertens](https://community.make.com/u/SebastianMertens)
#### Post date: [January 19, 2023, 10:04am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/9 "2023-01-19T10:04:14Z")

</div>

@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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/3/34079843276da8c001c1460639b8859af0887d78.png)

---

<div class="post-metadata">

### Author: ![Randy\_Agyeman-Danso](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Randy\_Agyeman-Danso](https://community.make.com/u/Randy_Agyeman-Danso)
#### Post date: [January 19, 2023, 6:33pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/10 "2023-01-19T18:33:06Z")

</div>

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

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/c/ce528cbf53a3217e19bd10e450417af17cce7618.png)

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?

---

<div class="post-metadata">

### Author: ![rabin](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@rabin](https://community.make.com/u/rabin)
#### Post date: [January 21, 2023, 8:14pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/11 "2023-01-21T20:14:58Z")

</div>

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](https://us1.make.com/app/invite/f584d5c7f923e107e8a816a9ccf066f7)

---

<div class="post-metadata">

### Author: ![Thinus](https://avatars.discourse-cdn.com/v4/letter/t/73ab20/32.png) [@Thinus](https://community.make.com/u/Thinus)
#### Post date: [March 4, 2023, 9:25am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/13 "2023-03-04T09:25:24Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![EyalGershon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/eyalgershon/32/6551_2.png) [@EyalGershon](https://community.make.com/u/EyalGershon)
#### Post date: [March 5, 2023, 7:22am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/14 "2023-03-05T07:22:08Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![EyalGershon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/eyalgershon/32/6551_2.png) [@EyalGershon](https://community.make.com/u/EyalGershon)
#### Post date: [March 5, 2023, 9:56am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/15 "2023-03-05T09:56:25Z")

</div>

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 🙂

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/1/14167582112639050329efa8d628eb76abc8cc5d.png)

---

<div class="post-metadata">

### Author: ![Thinus](https://avatars.discourse-cdn.com/v4/letter/t/73ab20/32.png) [@Thinus](https://community.make.com/u/Thinus)
#### Post date: [March 16, 2023, 12:58pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/16 "2023-03-16T12:58:34Z")

</div>

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

---

<div class="post-metadata">

### Author: ![EyalGershon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/eyalgershon/32/6551_2.png) [@EyalGershon](https://community.make.com/u/EyalGershon)
#### Post date: [March 16, 2023, 1:10pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/17 "2023-03-16T13:10:32Z")

</div>

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](https://www.npmjs.com/package/convert-excel-to-json)

---

<div class="post-metadata">

### Author: ![andynicky89](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@andynicky89](https://community.make.com/u/andynicky89)
#### Post date: [April 5, 2023, 6:58am UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/18 "2023-04-05T06:58:45Z")

</div>

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](https://www.xlsxtocsv.com/) about Integromat’s modules and services here: [https://www.integromat.com/en/support/modules/](https://www.integromat.com/en/support/modules/)

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [September 22, 2023, 4:07pm UTC](https://community.make.com/t/pick-up-xlsx-file-and-save-it-as-csv-file/6824/19 "2023-09-22T16:07:11Z")

</div>


