1.If you want to copy SharePoint list data to local, you could use Export to CSV or Export to Excel.
2.If you want to copy SharePoint list data to another SharePoint list, you could use flow to achieve this.
Reference:
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.