Data gathering in Excel refers to the process of collecting and compiling raw data from various sources and formats into a single spreadsheet.