Excel batch tools

Online to make two tables matching, cross-table matching filling, you can also weight, mix or split the workboard according to a list. file is processed in the browser locally.

Introduction of Excel Workbook

It can also be drawn up to 5 .xlsx, a total of 15 MB.
Method of handling

The account and match filling support two tables in the same book, also supports from two files respectively.

Treatment of rules

The first line as the headline. to restore the record that appears for the first time, to keep the list empty when it comes to the slide. after the breakdown, the groups are placed in different tables of the same XLSX.

When matching will ignore the spacecraft of the key value on both ends, retain the front-guided zero and the letter size small letters. for the account will be listed separately repeated key and empty key; filling when you meet the counter tab repeated key will mark the reason for artificial verification.

Export retained data values and digital formats.The formula uses the calculation results that have been saved in a file, the result-free workboard must be re-calculated and saved first with Excel.The original table's charts, combined cells and styles will not be copied.