Forum Discussion

BazzaBoyes's avatar
BazzaBoyes
Copper Contributor
Feb 07, 2022
Solved

CSV file----->> Excel Spread Sheet-Appended Sync

Hi,

I am trying to maintain an excel spreadsheet using a data link from a CSV file. This is straightforward, BUT here's the challenge:

I need the various rows to append when there is a change in that row instead of updating.

The idea is to build up the spreadsheet with new and historic data that can be controlled using column filters.

 

Any advice will be most welcome, and thanks.

BI & Data Analysis
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 08, 2022

    BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.

     

    Example attached.

     

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 08, 2022

    BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.

     

    Example attached.

     

Resources