Insert specific data into Excel as Table

Question

Insert specific data into Excel as Table

Anonymous

Hello together,

I have a very spezific problem to insert data from a .txt document into a excel table.

The data is displayed like this

{

	"ERDAT": "20221128",

	"LSTAR": "ITR",

	"DURATION": "0.1667",

	"SHRTTXT": "shorttext",

	"DESCTXT": "sample text "

},

{

	"ERDAT": "20221128",

	"LSTAR": "ITR",

	"DURATION": "2.7",

	"SHRTTXT": "other shorttext",

	"DESCTXT": "other sample text"

},

and there are ca. 400 more of these data-sets. So now i want to export them into excel and have erdat, lstar, duration, shrtxt and desctxt as headlines and beneath them the data. Is there any way to insert it into a exel table like that?

Thanks in advance.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Lz365 38,201 Volunteer Moderator

Hi Teaman1999

Are you sure your text file is constructed as you shared? Asking as it looks like a JSON (incomplete) document...

In both cases you should be able to resolve this with Get & Transform (aka Power Query). Below is the result (quick & dirty) after transforming the data you shared when saved them as a text file

0 comments

Share via

Insert specific data into Excel as Table

1 answer