I am curious on hearing other's work experiences on how you deal with a spreadsheet culture. I'm trying to help create uniformity in spreadsheets used as databases in my current environment as we plan to migrate certain data collection from spreadsheets to systems appropriate for the work. But that calls for some automated functionality to help transition without extra manpower. My biggest concern is how to ensure that the data imported is:
- in the proper format
- and that there aren't extra columns added
Now I do know how to do this the "brute force" sort of way by using R, creating structures that keep the data structure and format and check at import. But I wanted to see if there are alternative ways that anyone might have insight that I have yet to find.
Love to hear what you think!