How to import an Excel file in RStudio?
The first block are headers and standard number formats that you will recognise , then the data is simply an X/Y coordinate and a value. Save it in Personal.xlsb to have it always available. Personalise excel toolbar adding a macro call button and open files from there. You can add more formating to the macro, like column autofit , alignment,etc.…