0

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.

zx8754
  • 52,746
  • 12
  • 114
  • 209
amerakhtab
  • 1
  • 1
  • 2
    This lacks sufficient context (e.g., sample data) to do more than opine what *might* be useful. Please make this question reproducible. Also, it seems that this is more likely a unicode issue (e.g., `iconv`), not a file read/write problem. – r2evans Jun 29 '21 at 17:46

1 Answers1

0

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.

MonJeanJean
  • 2,876
  • 1
  • 4
  • 20