Step-by-Step 1 – Open a Non-Native File Directly in Excel

Open the file in excel. Add a new sheet and name it “Remove Duplicates”. Copy and paste the raw data into the new sheet. In the “Data” tab, click on “Remove Duplicates” In the “Remove Duplicates” window, select only the column that includes the data field GUID. This is a unique identifier. In the sample data set, this is Column B. ................
................