Merge Data with Excel97 Data
Merge data with your Excel 97-2003 (.xls) data quickly
Merge Data
Merging stacks your Excel 97-2003 (.xls) file together with one or more datasets, appending their records underneath so everything lands in one table. The result includes every column found across all datasets, and you choose which column from each dataset fills each one. Perfect for combining exports from different periods, regions, or systems into a single dataset.
Excel 97-2003 (.xls)
Excel 97-2003 file refers to the file format used by Microsoft Excel versions from 1997 to 2003, typically having the .xls extension. This format is a binary file format known as BIFF (Binary Interchange File Format) and was the standard for Excel spreadsheets before the introduction of the newer format in Excel 2007. This version of Excel support 65,536 rows and 256 columns per sheet, as well as various formatting options, formulas, charts, pivot tables, and conditional formatting. This older format included password protection and encryption which has since been improved in the newer version. The Excel 97-2003 .xls remains in uses in environments where legacy systems are in operation or where compatibility with older versions of Excel is necessary.