Read from Excel directly

Problem: the .csv export

Back in the days, I remember spending so much time doing some .xlsx → .csv conversion.

It comes with several drawbacks!

❌ Time consuming: one more unecessary step in your pipeline

❌ Error prone: you can easily lose some formatting while doing the conversion, or struggle with special characters

❌ Lose the Multi-Sheet Structure

❌ Size Limitations: you are now storing the data twice!

❌ Metadata: Excel files can contain metadata like comments, author information, and other properties that are lost when converted to .csv

Productive R Workflow

This lesson is for members only! 😔
Become a member now to access the full course with a lifetime access!

Enroll

Or Login