Share via

Excel doesn't see new columns when I want to append several sheets

Natalya Matyushenko 0 Reputation points
2024-05-09T18:04:52.2866667+00:00

I had multiple .csv files that I downloaded to Excel workbook as tables on separate sheets. I've added a new Date column to each table, each sheet has a data for each month, so I have 12 tables. After that I want to append all tables so I have the whole year data. But when I append those files, it doesn't see a new Date column. I tried to save it, to download it again with all sheets, and refresh, and clear cache. I have this new column in all tables in my file, but when appending Excel doesn't see these columns. Is there any way how to append tables in the same workbook, so could add new columns and Excel would see them?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,520 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 5,475 Reputation points Microsoft Vendor
    2024-05-10T05:40:50.6666667+00:00

    Hi @Natalya Matyushenko

    I have some questions about your issue:

    • Where do you store these .csv files before download to Excel?
    • How did you add the date columns?
    • How did you append all tables?

    I suggest you try Excel Power Query to combine these tables.

    The reference:

    https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

    https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-to-combine-data-from-multiple-tabs/5c09de27-3856-44d6-a159-4ad0686fe5c9

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.