Please give us your suggestions. How to classify the book list in excel?

How to classify books mainly depends on the variety, scope and use of your collection.

For example, middle school mathematics teaching guidance books, you can classify them as mathematics, middle school and teaching guidance books. How to classify mainly depends on how to easily find relevant books when using them after classification.

If it is a library, it is suggested to classify it according to China Book Classification:

Marxism-Leninism and Mao Zedong Thought.

I Marxism-Leninism and Mao Zedong Thought.

1 Works of Marx and Engels

Lenin's works

3 Stalin's works

4 Mao Zedong's works

5. Compilation of works of Marx, Engels, Lenin, Stalin and Mao Zedong.

The life and biographies of Marx, Engels, Lenin, Stalin and Mao Zedong.

7. Study and study Marxism-Leninism and Mao Zedong Thought.

philosophy

philosophy

0 philosophy theory

1 world philosophy

2 China's philosophy

3/7 National Philosophy

80 Thinking Science (General)

8 1 logic (logic)

Ethics (moral philosophy)

83 aesthetics

84 psychology

9 atheism, religion

social science

Introduction to social science

Theory and method of social science

1 Present situation and general situation of social science

2 organs, organizations and meetings

3 social science research methods

4. Social science education and popularization

5. Social science series, anthologies and serial publications.

6 social science reference books

[7] Social Science Literature Retrieval Book (please check G257.33, Z88/89)

8 statistical data

9 1 sociology

Demography

93 management

[94] System Theory (Systematics, Systems Engineering) (please check N94)

96 talent science

Politics, law

0 political theory

1/3 *** Producer Movement and * * * Producer Party

Workers, peasants, youth and women's movements and organizations

5/7 World Politics

8 diplomacy and international relations

9 law

E military

0 military theory

1 world military

2 China military

3/7 National Army

8 Strategy, Tactics and Campaign

9 military technology

99 military topography and military geography

F economy

0 political economy

1 world economic survey, economic history, economic geography

2 Economic planning and management

3 agricultural economy

4 industrial economy

5 transport economy

6 a little frugal

7 trade economy

8 finance, finance

G. Culture, science, education and sports

0 cultural theory

1 overview of world cultural undertakings

2 information and knowledge dissemination

3 Science and scientific research

4 education

Eight sports

H. Language and writing

Linguistics 0

1 Chinese

2 China minority languages

Three commonly used foreign languages

3 1 English

32 French

33 German

34 Spanish

35 Russians

36 Japanese

37 Arabic

4/84 Languages of various languages

9 international auxiliary words

I. Literature

0 literary theory

1 world literature

2 China literature

3/7 national literature

J art

0 art theory

1 overview of world art

2 painting

Calligraphy and seal cutting

3 sculpture

4 photography art

5 Arts and Crafts

[59] Architectural Art (Please see Figure -8)

6 music

7 dance

8 drama art

9 film and television art

History, geography

0 historical theory

1 world history

2 History of China

3/7 National History

8 1 Biography

85 cultural relics archaeology

89 customs and habits

9 geography

natural science

Introduction to natural science

0 natural science theory and methodology

1 Present situation and general situation of natural science

2. Natural science organs, organizations and conferences

3 natural science research methods

4. Natural science education and popularization

5 natural science series, anthologies and serial publications.

6 natural science reference books

[7] natural science literature retrieval reference books (please check G257.36, Z88/89)

8. Natural science investigation and investigation

9 1 Natural Studies and Natural History

94 System Theory (Systematics, Systems Engineering)

[99] Information Science and Information Work (please check G35)

Mathematical science and chemistry

O 1 mathematics

1 1 classical mathematics

12 elementary mathematics

13 advanced mathematics

14 mathematical logic and mathematical basis

15 algebra, number theory and combinatorial theory

17 mathematical analysis

18 geometry and topology

19 global analysis and manifold analysis

2 1 probability theory and mathematical statistics

22 operational research

Cybernetics and information theory (mathematical theory)

24 computational mathematics

29 applied mathematics

O 3 mechanics

3 1 theoretical mechanics (general mechanics)

32 vibration theory

33 continuum mechanics (deformation mechanics)

34 solid mechanics

35 fluid mechanics

369 physical mechanics

rheology

38 explosive mechanics

applied mechanics

O 38 explosion mechanics

O 4 physics

4 1 theoretical physics

42 acoustics

43 optics

44 electromagnetism, electrodynamics

radiophysics

46 vacuum electronics (electronic physics)

Semiconductor physics

48 solid state physics

5 1 low-temperature physics

High pressure and high temperature physics

Plasma physics

Theory of heat and molecular motion of matter

56 Molecular Physics, High Energy Physics

59 applied physics

O 6 chemistry

6 1 inorganic chemistry

organic chemistry

Polymer chemistry (polymer)

Physical chemistry (theoretical chemistry), chemical physics

analytical chemistry

applied chemistry

O 7 crystallography

P astronomy, earth science

1 astronomy

2 Surveying and mapping

3 Geophysics

P 4 meteorology

5 Geology

7 oceanography

9 physical geography

Q bioscience

1 general biology

2 cytology

3 genetics

4 Biology

5 biochemistry

biophysics

7 molecular biology

8 1 bioengineering

[89] Environmental Biology (please check X 17)

9 1 paleontology

92 microbiology

Botany 94

Zoology 95

96 insects

Anthropology 98

Medicine and health

American agricultural science

Industrial science

TB general industrial technology

1 basic engineering science

(including: engineering mathematics, engineering mechanics, engineering physics,

Engineering astronomy, engineering bionics, ergonomics)

TB 2 engineering design and surveying and mapping

3 engineering materials science

[3 1] metal material (please check TG4)

nonmetallic material

33 composite material

35 Low temperature resistant materials and high temperature resistant materials

37 Corrosion resistant materials

39 Other special performance materials

General technology and equipment for industry

4 1 blasting technology

42 sealing technology

43 thin film technology

44 powder technology

48 packaging engineering

49 factories and workshops

5 acoustic engineering

6 refrigeration engineering

7 vacuum technology

8 photography technology

TB 9 metrology

TD mining engineering

TE oil and gas industry

TF metallurgical industry

Metallurgy and metal technology

1 metallurgy and heat treatment

2 casting

TG 3 metal pressure working

4 Welding, metal cutting and bonding

5 metal cutting and machine tools

Cutting tools, abrasives, abrasives, fixtures, molds and hand tools.

8 Tolerances and technical measuring and mechanical measuring instruments

9 fitter technology, assembly technology

Mechanical and Instrumental Technology

1 1 mechanics (basic theory of mechanical design)

12 mechanical design, calculation and drawing

13 mechanical parts and transmission devices

14 materials for machinery manufacturing

16 machinery manufacturing technology

17 operation and maintenance

18 machinery factory (workshop)

2. Lifting and transportation machinery

3 pump

4 gas compression and conveying machinery

6 Special machinery

7 instruments and meters

TJ weapon industry

0 general questions

2 firearms

Three guns

Ammunition, Fuzes and Detonators

5. Blasting equipment, pyrotechnic equipment, explosives.

Six kinds of underwater weapons

Seven rockets and missiles

Chariots, warships, fighters and space weapons

TJ 9 nuclear weapons and other special weapons and protective equipment

TK electric power industry

0 general questions

1 thermal engineering and heat engine

2 steam power engineering

3 Thermal measurement and thermal automatic control

chinese internal combustion engine engineering

5 Special heat energy and its utilization

6 Bio-energy and its utilization

7. Water energy and water conservancy machinery

8 wind energy and wind machinery

9 1 hydrogen energy and its utilization

TL atomic energy technology

TM electrical technology

0 general questions

1 basic theory of electrical engineering

2 electrical materials

TM 3 motor

4 Transformers, converters and reactors

5 electrics

6 power generation and power plants

7. Power transmission and distribution projects, power grids and power systems

8 high voltage technology

9 1 independent power supply technology (direct power generation)

Electrification and electric energy application

93 electrical measurement technology and instruments

Radio electronics and telecommunications technology

0 general questions

TN 1 Vacuum Electronic Technology

2 photoelectric technology and laser technology

3 semiconductor technology

4 microelectronics, integrated circuits (IC)

6 Electronic components and assemblies

7 basic electronic circuit

8 radio and telecommunication equipment

9 1 communication

92 wireless communication

93 broadcast

94 TV

95 radar

96 radio navigation

97 electronic countermeasures (jamming and anti-jamming)

[98] Radio and Telecommunication Measurement Techniques and Instruments (please refer to TM93)

Application of TN 99 radio electronics

TP automation technology and computing technology

1 basic theory of automation

2 automation technology and equipment

3 computing technology, computer

6 Injection technology (flow control technology)

remote sensing technology

8 remote control technology

TQ chemical industry

1 1 Basic Inorganic Chemistry

basic organic chemistry

TQ 3 1 polymer compound industry (polymer industry)

Synthetic resin and plastics industry

43 adhesive industry

5 1 Fuel Chemical Industry (General)

56 explosive industry, match industry

63 coating industry

Perfume and cosmetics industry

Light industry and handicraft industry

Slaughterhouse science

Television water conservancy project

U transportation

U 46 automobile engineering

46 1 automobile theory

Design and Calculation of 462 Vehicle

463 automobile structural parts

464 automobile engine

465 automobile material

466 automobile manufacturing technology

467 automobile experiment

Siliuba automobile factory

469 general motors

47 1 automobile driving and use

472 automobile maintenance and repair

473 fuels and lubricants for automobiles

V. Aviation and aerospace

1 research and exploration of aerospace technology

V 2 aviation

4 aerospace

4 1 basic theory and experiment

42 Rocket and Spacecraft Structure (Overall)

43 Propulsion system (engine, propeller)

Instruments, equipment, guidance and control

46 manufacturing process

Spacecraft and its vehicle

5 1 Aviation fuel (propellant) and lubricant

52 aerospace

Ground equipment, proving ground, launch site and space base

57 aerospace systems engineering

X. Environmental science

1 basic theory of environmental science

Comprehensive study of X 2 environment

3 environmental protection management

4 disasters and their prevention and control

5 Environmental pollution and its prevention and control

7 Three wastes treatment and comprehensive utilization

8 environmental quality assessment and environmental monitoring

Comprehensive books

Z comprehensive books

1 series

Encyclopedias and books.

3 dictionary

4. Prose, complete works, selected works and essays

Z 5 yearbook and annual publication

6 Periodicals and serial publications

8 book catalogue, abstract and index