{"id":1670,"date":"2026-11-17T16:24:05","date_gmt":"2026-11-17T14:24:05","guid":{"rendered":"https:\/\/www.kaarne.fi\/superstore\/?p=1670"},"modified":"2026-11-17T16:24:07","modified_gmt":"2026-11-17T14:24:07","slug":"monthly-csv-changed-columns","status":"publish","type":"post","link":"https:\/\/www.kaarne.fi\/superstore\/articles\/monthly-csv-changed-columns\/","title":{"rendered":"The New CSV Has Different Headings. What Should Happen Next?"},"content":{"rendered":"<p>The latest export looks familiar, except one heading has changed and a new column has appeared. The report may still refresh, or it may stop with an error. Neither outcome tells you by itself whether the new file means the same thing.<\/p>\n<p>Treat a changed source structure as a question to review. The right response depends on what changed and how the reporting steps use it.<\/p>\n<h2>Compare the contract with the new file<\/h2>\n<p>Consider a fictional dispatch-office report. Its preparation method expects an order identifier, a transaction date and a defined amount. A new export replaces one date heading with a more specific description.<\/p>\n<p>Before renaming it back, ask whether this is only a label change or a different business date. An order date and a dispatch date can produce different monthly populations even when both contain valid dates.<\/p>\n<p>Keep a short list of the fields your report relies on, their meanings and any allowed values. This is the practical source contract against which a changed file can be assessed.<\/p>\n<h2>Preserve the incoming version<\/h2>\n<p>Keep the new source intact and compare it with the earlier expected structure. Record the export date and the system or person supplying it, using only information you are authorised to handle.<\/p>\n<p>Check the affected preparation steps in a test copy. Power Query\u2019s applied steps make the transformation route visible, but the business interpretation still needs an owner who understands the source.<\/p>\n<p>Do not remove an unfamiliar column or rename a field merely to suppress an error. Equally, a new optional field may require no reporting change. Establish the dependency before deciding what to alter.<\/p>\n<h2>Test meaning as well as refresh<\/h2>\n<p>Use recognisable fictional records that exercise the changed field. Write the expected period assignment or category before refreshing, then inspect the prepared result and the final view.<\/p>\n<p>Compare the reconciliation note with the previous method. Explain any intended change in counts or totals. If you cannot explain the difference, keep the report provisional while the source question is resolved.<\/p>\n<p>The exact effect of a structural change depends on the workbook\u2019s queries and settings. Avoid a universal rule that every renamed heading is safe or that every added column breaks a report.<\/p>\n<h2>Make the next month easier<\/h2>\n<p>After agreeing the change, update the operating note and source contract. Record who approved the meaning, which steps changed and which examples were checked.<\/p>\n<p>Tell the people who read the report if a definition or comparison changed. A technically successful update can still mislead a reader who assumes the old measure is unchanged.<\/p>\n<p>The useful outcome is a controlled adaptation rather than a clever workaround nobody remembers. When the source evolves, the reporting method should retain a visible explanation of how the new file becomes the number people discuss.<\/p>\n<h2>Keep the reporting method connected<\/h2>\n<p>Explore the <a href=\"https:\/\/www.kaarne.fi\/superstore\/monthly-reports-refresh-handover\/\">Build a Monthly Report Someone Else Can Continue<\/a> guide and the related practical questions below.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/excel-report-refresh-handover\/\">You Can Refresh the Report. Can the Person Covering for You?<\/a><\/li>\n<li><a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/excel-report-repeat-refresh-check\/\">You Refreshed Twice. Should the Report Have Changed?<\/a><\/li>\n<\/ul>\n<p>If you want a written practice route, review the <a href=\"https:\/\/www.kaarne.fi\/superstore\/excel-monthly-reports-with-matze\/\">Excel Monthly Reports with Matze course overview<\/a>. It requires compatible Excel Desktop for Windows with Power Query; you build the report yourself.<\/p>\n<p><a href=\"https:\/\/einfachmitmatze.de\/excel-monthly-reports\/#aff=pasi5e9a&amp;cam=superstore-launch-20261117\" rel=\"sponsored noopener\" target=\"_blank\">Check the course contents and current price<\/a>. <small>Affiliate link: Superstore may earn a commission if you buy. Check current contents, requirements and terms before purchasing.<\/small><\/p>\n<p><small>Technical reference: <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/about-power-query-in-excel\" target=\"_blank\" rel=\"noopener\">Microsoft: About Power Query in Excel<\/a>. Checked 17 November 2026. The fictional business exercise and reporting recommendations above are Superstore editorial guidance.<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A changed CSV heading may signal a changed meaning. Review the source contract, test affected steps and record the decision before updating the report.<\/p>\n","protected":false},"author":1,"featured_media":1713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[35],"tags":[],"class_list":["post-1670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-digital-tools"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.kaarne.fi\/superstore\/wp-content\/uploads\/sites\/7\/2026\/11\/excel-monthly-8.webp","_links":{"self":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/comments?post=1670"}],"version-history":[{"count":8,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1670\/revisions"}],"predecessor-version":[{"id":1786,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1670\/revisions\/1786"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media\/1713"}],"wp:attachment":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media?parent=1670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/categories?post=1670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/tags?post=1670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}