Step 2: Open Excel and Link to the Relevant Folder Once the files are correctly organized into the folder according to the above prerequisites, you're ready to start pulling the data together.