How to make an Excel spreadsheet from text?

Question

Python

There is a text from the site in the following form: Name of
the indicator
Code 190 8 8 0 0 Research and development results 1120 6,665 5,010 7,175 7,275 5,393 33,212 0 Fixed assets 1150 12,076* 11,227 2,941 2,589 2,635 2,790 808 977 Financial investments 1170 0 0 0 0 2 649 Deferred tax assets 1180 9 164 11 096 3 415 2 071 679 851 0 0 Other non-current assets 1190 65 65 65 0 0 0 0 0 Total for Section I 1100 34 981 31 225 17 863 14 0812 3626 II. CURRENT ASSETS
Reserves 1210 453 524 218 529 93 699 84 119 50 751 54 618 35 195 34 484
value added tax for purchased values ​​1220 4 0 604 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Accounts receivable 376 14 082
Cash and monetary equivalents 1250 682 8 845 390 1 008 949 337 333 333 1 077
Other current assets 1260 2 483 2 498 2 677 50 166 3 753 223 0
Total for section II 1200 675 105* 401 978 088 102 451 61,140 68,567 48,127 49,643
BALANCE 1600
710,086 433,203 165,951 116,576 69,855 72,249 49,147 53,269 LIABILITIES
III. CAPITAL AND RESERVES
Authorized capital (share capital, authorized fund, contributions of partners) 1310 10 10 10 10 10 10 10 0
Retained earnings (uncovered loss) 1370 215 634 83 588 12 370 6 835 10 405 10 208 14 437 0 Total for section III
1300 215 644 83 598 12 380 6 845 10 415 10 218 14.4047
LONG- TERM LIABILITIES
Deferred tax liabilities 1420 1,187,683 1,296,833 0 0 0 0
Other liabilities 1450 0 0 0 0 0 0 0 203
Section IV total 1400 1,187,683 1,296,833 0 0
0
203 701 88 116 31 655 34 885 32 928 32 708 22 245 14 298
accounts payable 1520 165 623 205 038* 103 118* 74 013 26 512 29 323 12 455 44 747
Future income 1530 72 112 156 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assessment obligations 1540 48 857 55 656 17 346 0 0 0 0 0
Other obligations 1550 2* 0 0 0 0 0 0 30
Total for section V 1500 493 255* 348 922* 152 275 108 898 59 440 62 031 34 700 59 075
Balance 1700 710 086 433 203 165 951 116 576 69 855 72 249 49 147 53 269
Indicator Code 12/31/18 12/31/17 12/31/16
12/31/15
ASSETS I. NON-CURRENT ASSETS
Intangible assets 1110 48 55 0 0
Research and development results 1120 12,514 5,471 4,507 2,344
Fixed assets 1,150 147,179
Deferred tax assets 1,180 0 0 1,940
Section I total 1100 27,314 11,770 4,655 3,463
II. CURRENT ASSETS
Inventories 1210 33,226 26,771 13,976 13
Value added tax on acquired valuables 1220 0 0 0 377
Accounts receivable 1230 44 657 71 849 64 644 676
Costs and cash equivalents 1250 1 991 7 102 99 397
other current assets 1260 1 508 1 783 1 996 2 187*
Total for section II 1200 81 382 107 505 80 715 3 650* Balance* Balance*
Balance 1600 108 696 119 275 85 370 7 113
PASSIVE
III. CAPITAL AND RESERVES
Authorized capital (share capital, authorized fund, contributions of partners) 1310 20 20 20 20
Retained earnings (uncovered loss) 1370 71,736* 57,720 11,167 (4,362)
Section III total 1300 71,756* 57,740 11,187 (4 342)
IV. LONG- TERM LIABILITIES
Deferred tax liabilities 1420 964 957 828 141
Total for Section IV 1400 964 957 828 141
V. short -term
obligations borrowed funds 1510 26 597 36 871 23 832 7 922
payables 1520 9 379 23 707 49 523* 3 392
Total for section V 1500 35 976 60 578 73 355 11 314
Balance 1700 108 696 275 370 7 113 113
The data is taken from the table on the site. How to format all this in Excel.

Answer 1

Use the openxl library.
Documentation: OpenXL
Create a book, a sheet, and then add the cell filling code to your parser from the site.

Answer 2

Sergey Yavin If there is a table on the site in the table tag, then it is most convenient and easiest to parse it using the pandas package and its magical DataFrames.
With the help of pandas, you can also upload to excel.

Answer 3

Probably easier to manually type in tables

Answer 4

Parse text to csv. csv opens fine in excel