Start Fresh Excel sheet with foundation template. Can i include transactions from old sheet?

I have an Excel sheet that i have been using but the autocat feature Tiller added will not work with it. If i want to start fresh with the TIller Excel Foundation template is there a way to include the transactions from my old Excel sheet without creating the duplicate transaction problem?

When I’ve had to do this in the past, I update both the old and new sheet so they’re both completely ‘caught up’, then delete the transactions from the new sheet, and copy the transactions from the old sheet. Make sure you first get your Categories setup the same way. You might have to compare your accounts, and if they differ, you may want to filter by each and paste in the ‘new’ account name in place of the ‘old one’. Not the cleanest way to do it, but it seemed to work.