Exporting to CSV using R without symbols

Question

I am writing a script to automatically convert to csv, a long list of xlsx files. Currently using export function from the rio package.

Problem is, there comes symbols and characters in the csv files. On the other hand, converting to a csv using Microsoft excel File>Save as doesn't give any symbols.

I want the excel files not to have any of those symbols or characters.

Answer 1

You can first import the xlsx files with readxl::read_xlsx, and then convert it to csv with the base function write.csv: both encoding should keep the symbols.