You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

To do this, simply: Effortless Data Conversion and Organization The first step in leveraging the power of Excel Power Query is to convert your raw data into Excel tables.