Data formatting method and system for files in E-mails

The invention relates to the technical field of information, and particularly discloses a data formatting method and system for files in emails, and the method comprises the steps: S10, obtaining emails, files in the emails, and receiving addresses and sending addresses of the emails from a plurality of associated mailboxes; step S20, determining a first source of the file based on the first association relationship; step S30, determining a second source of the file based on the second association relationship; step S40, determining the type of the file according to the mail content of the mail and the file name and/or the file content of the file; s50, merging the files according to the types of the files to obtain a merged file; step S60, establishing a corresponding relationship among the original column, the first source and the second source of the merged file and a preset standard column; and S70, filling the standard column with the data of the original column, the first source and the second source ac