If that doesn't work, you could try reapplying / pre-applying (paste with destination formatting) either the calibri or your default font, or a monospace font like Courier New. Paste your json data into notepad or possibly superuser first (to rid your data of all formatting, then select all and copy again, paste into Excel. After resize both the column width and the row height, it looks like this (font stays the default Calibri): "Wrap text" comes on automatically, and the row height jumps up. ![]() select cell, double-click/press F2, CTRL+V), it pastes everything into a single cell. If I do the same, but edit the cell before pasting (i.e. ![]() Disclaimer: Both of these will only work if the JSON/CSV are valid/standard formats. ![]() If I copy and paste your first "code formatted" JSON text section, and paste into Excel (select single cell, but not edit, hit CTRL+V) then in pastes it into a single column across 10 rows. Put this formula in C1: VLOOKUP (B1, TRANSPOSE (ARRAYFORMULA (SPLIT (TRANSPOSE (SPLIT (A1, char (10))), ','))), 2, FALSE) You can test it out by changing the lookup key in B1. Excel is a powerful tool that allows you to connect to. Strangely enough, I don't seem to have this issue. To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |