Does anyone know how to make CSV/XLSX files in Arabic readable for the Parse CSV module in Make? I keep getting gibberish (screenshot attached). The problem stems from Make not being able to read Arabic, not the module. I tried using a translator module which received the same input from the file.
XLSX files are not CSV. You cannot directly parse CSV from an XLSX file.
Try converting it into CSV first.
To do this, you can try using the CloudConvert “Convert a File” module —
Converts a file into a selected output format.
For more information, see https://www.make.com/en/integrations/cloudconvert, and https://www.make.com/en/help/app/cloudconvert in the help centre.
If you do not want to use CloudConvert, a free option is to upload to Google Drive and use the “Download a File” module to convert it to CSV (expand the advanced settings).
To do this, you can try using the Google Drive “Download a File” module —
Downloads a file.
For more information, see https://www.make.com/en/integrations/google-drive, and https://www.make.com/en/help/app/google-drive in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
2 Likes
That did it! Thank you for the reply.
However, it’s 1/2 of the puzzle - when trying to create a new CSV from the parsed data (“Create CSV (Advanced)”), the data comes back out scrambled, which leads me to believe that Make’s native CSV creation function is using a different encoding (my files are use UTF-8 by default. Do you have any recommendations on file encoding in Make?
No worries if not; I’ll continue to hunt for a solution.
1 Like