Excel Power Pivot does not correctly interpret tab-delimited file

Question

Setup: Windows 10, Microsoft Excel for Microsoft 365 MSO version 16.0.12827.20328 64-bit

I have a number of Excel-based "data prep" templates that leverage Power Pivot to aggregate large data files into consumable pivot tables -- these designs all revolve around tab-delimited text files that have historically, including Wednesday June-10 2020, been interpreted successfully by Power Pivot.

To demonstrate the problem, let's start with this tab-delimited file:

When I attempt to import this file using Power Pivot, you can see that the tabs are not recognized as delimiters:

Power Pivot has no issue interpreting comma-delimited files though:

The existing infrastructure relies on tab-delimited data, so while switching from tab-delimited data to comma-delimited data is an acceptable long-term solution, I need a short-term solution and believe that Power Pivot should be able to interpret tabs.

Can anyone advise on what I am doing wrong here, or if this is potentially a bug with Power Pivot?

Thanks! -Dan

[PII Removed by MSFT]

Answer 1

Appreciate the quick response Arck -- I have submitted this feedback to Microsoft via the Excel interface.

Thanks! -Dan

Answer 2

Hi,

You could do so, but it would mean redo all the reports based on the newly imported data, basically redesigning the report entirely and also hold the data as an excel table.

thanks