On this page
On this page you will find a number of google sheets that we have shared in order to help streamline your UPSC preparation.
You will need to make a copy of these files to be able to edit them.
💡
How to make a copy
1. Go to File menu
2. Click on Make a copy
3. Edit as needed
1. Go to File menu
2. Click on Make a copy
3. Edit as needed
All the best!
PLAN SHEETS
8 Month Plan for UPSC CSE 2025 for BEGINNERS
This plan is for people who are just starting their UPSC CSE journey right now and have no previous experience with any or most of the subjects.
(Beginner) 8 Months Plan for UPSC CSE 2025 - UPSCprep.com
8 Month Plan for UPSC CSE 2025 for ADVANCED
This plan focuses a lot more on covering Mains related GS subjects and assumes a certain amount of familiarity with each subject.
The timelines for completion of topics will be stricter as compared to the beginner plan.
(Advance) 8 Months Plan for UPSC CSE 2025 - UPSCprep.com
MAINS ANALYSIS SHEETS
You can access the Google sheet versions of all plans shared on youtube below.
Mains PYQ Analysis
Mains PYQ Analysis - UPSCprep.com
Syllabus Paper,Code,Topic,Column1
GS 1,1c,Indian culture will cover the salient aspects of Art Forms, literature and Architecture from ancient to modern times.,1
GS 1,1i,Modern Indian history from about the middle of the eighteenth century until the present-significant events, personalities, is…
Checklist for UPSC Mains 2024 - Progress Tracker
UPSC Mains 2024 Prep Tracker - UPSCprep.com
Progress Paper,Reading Status,Notes Status,PYQ Status,MAX Marks,Common Feedback
GS1,42%,42%,33%,110,Maps in geography, facts in society missing.
GS2,0%,0%,0%
GS3,0%,0%,0%
GS4,0%,0%,0%
Socio P1,0%,0%,0%
Socio P2,0%,0%,0%
This contains a progress tracker for Sociology optional as well. You can update for your own optional as needed.
SOCIOLOGY OPTIONAL SHEETS
4 Month Plan for Sociology Optional (with Daily Targets)
Starting from 1st of July 2024.
Sociology 4 Months Plan for UPSC 2025/26 - UPSCprep.com
Plan Date ,Day,General Studies ( 3 Hours ) + PYQs Practicing (30 mins)
1 July,Monday,Understanding the Syllabus + Watching Toppers Talks
2 July,Tuesday,Resource collection - Primary and Reference Material
3 July,Wednesday,Resource collection - Primary and Reference Material
4 July,Thursday,Text…
PRELIMS ANALYSIS SHEETS
UPSC Prelims 2024 Answer Key
UPSC Prelims 2024 Answer Key - UPSCprep.com
GS SET B SET B Q,Topic,SET B Key,Subject,Type
1,Fertility rate,D,Economy,Direct
2,NBFC - G secs,C,Economy,Normal options
3,Corporate bonds - G Secs ,D,Economy,Normal options
4,Motor vehicles,D,Economy,Normal options
5,Primary secondary tertiary sectors,B,Economy,Fancy options
6,Aviation Fuel,C,E…
Click the button below to check the detailed solution for UPSC Prelims 2024 General Studies paper.
CSAT 2023 Marks Distribution
CSAT23 Marks Distribution - UPSCprep.com
CSAT Topics CSAT 2023 Marks Distribution
Maths,LR,Comprehension
34,19,27
Topic,CSAT23,Number system,Questions
Number System,17,Basic maths,7,Odd/Even,Prime/Composite,Counting
P&C,9,Remainders,6
Mensuration,4,Sequence/Series,2
Time & Work,3,Powers & exponents,1
Compound interest,1,HCF/LCM,1
Total,34
UPSC Prelims 2023 Analysis Sheet
Prelims 2023 Analysis
Set B Q. No.,Solution,Difficulty,Subject,Type
1,A,02 Medium,AMC,Direct
2,B,01 Easy,AMC,Fancy Options
3,B,03 Hard,AMC,Direct
4,D,03 Hard,AMC,Direct
5,D,02 Medium,AMC,Fancy Options
6,B/C,03 Hard,AMC,Fancy Options
7,B,01 Easy,AMC,Direct
8,A,03 Hard,AMC,Direct
9,C,01 Easy,AMC,Direct
10,D,01 Easy,Modern
UPSC Prelims Trends 2011 - 2023
Themes in Prelims 2011-22
Overview Subject,Themes,12 Year Q Count,Average Qs,Expected marks 2023
Polity,7,159,13.3,26.6
Economy,6,142,11.8,23.6
Science & Tech,4,108,9,18
Environment,6,208,17.3,34.6
Geography,7,199,16.6,33.2
History,6,211,17.6,35.2
Prelims Progress Tracker
Prelims Progress Tracker - UPSCprep.com
Overview Prelims Subjects,Progress Bar,Test Scores (Max/Min)
Polity
Economy
Environment
Geography
Science & Tech
History
Current affairs
CSAT Maths
CSAT LR
CSAT Comprehension
Exam Analysis Sheets
(OLD) 4 Month Plan for UPSC Prelims 2024 (Daily Targets)
UPSC Prelims 2024 - 4 Months Plan (UPSCprep.com)
Daily Plan Date,Day,Slot 1,Slot 2,Slot 3
1 January,Monday,Optional
2 January,Tuesday,Optional
3 January,Wednesday,Optional
4 January,Thursday,Optional
5 January,Friday,Optional
6 January,Saturday,Optional
7 January,Sunday
8 January,Monday,Optional
9 January,Tuesday,Optional
10 January,Wednesday,…
(Old) 8-Month Plan for UPSC CSE 2024
8 Month Plan - CSE 2024 (UPSCprep.com)
Macro view Start Date,Week,Primary Focus,Secondary Focus
16 Oct,Week 1,Indian Polity - Laxmikant,Optional
23 Oct,Week 2,Indian Polity - Laxmikant,Optional
30 Oct,Week 3,Indian Polity - Laxmikant,Optional
06 Nov,Week 4,Indian Economy Handbook by Ketan Sir,Optional,Economy Handbook shared on our T…
(Old) 1 Year Plan for UPSC CSE 2025
Updated 1 Year Plan for UPSC CSE 2025 - UPSCprep.com
Daily Plan Date,Day,General Studies Topic,Current Affairs,CSAT Practice,Optional Subject 1 July,Monday,Understanding the Exam Pattern - Prelims, Mains, Interview
Watching Toppers Talks, Newspaper
2 July,Tuesday,Resource collection - Prelims
Resource collection - Mains (Topper Copies, Books et…
