Guide to Compiling a TikTok Creators Spreadsheet

Comprehensive Strategies and Tools for Finding Targeted TikTok Influencers

Key Takeaways

• Utilize Specialized Influencer Platforms: Use databases tailored for influencer marketing to filter creators by location, age, gender, niche, and follower count, ensuring you get the detailed data you need.
• Manual Verification & Research: Even after using advanced search tools, manually verify profiles to ensure that the creators meet your specific criteria related to content, age estimation, and authenticity.
• Data Organization Template: Assemble the gathered data into a clear spreadsheet template requiring key columns such as username, follower count, age, location, and content niche.

Understanding Your Requirements

You have requested a comprehensive list of 100 TikTok creators who meet specific criteria including gender, age, location, content type, and follower range. The required details are as follows:

• Gender: Female
• Age: Between 18 and 28 years old
• Location: London, UK
• Content: Lifestyle, parties, gym, fashion, creative projects, art, dating, relationships, and music
• Follower Count: Minimum of 1,000 and a maximum of 20,000 followers

Providing a spreadsheet that directly lists these influencers in a precompiled format is challenging due to the dynamic nature of social media data, privacy concerns, and the need for constant manual curation to ensure the accuracy of the criteria provided. Data privacy and ensuring that information is up-to-date are significant concerns when handling social media profiles.

Approach and Strategies to Build Your Spreadsheet

Rather than providing a pre-made spreadsheet, the optimal approach is to guide you through the process of compiling this list yourself by leveraging specialized influencer platforms and search techniques. Below, we expand on several methods to help you achieve this:

Utilizing Specialized Influencer Platforms and Tools

Several platforms have powerful search tools and databases that allow for precise filtering of TikTok influencers:

1. Influencer Marketing Platforms

Many influencer marketing platforms provide advanced search features that allow you to filter by various criteria such as location, gender, age estimates, follower count, and content niches. These include specialized databases where profiles are generally continuously updated.

• Database Search: These platforms usually offer large databases where you can specify filters like “London” for location, “female” for gender, and an age range estimated by content or self-reported information on profiles.
• Engagement Metric Monitoring: Some systems will also include metrics like engagement rate as additional information to help you decide on potential influencers.
• Content Filters: Refine your search using content hashtags or keywords such as #Lifestyle, #Fashion, #Gym, #Parties, etc. This will ensure that the influencers primarily post content that aligns with the specified interests.

Platforms like those available through comprehensive influencer directories allow you to download or export lists of influencers that satisfy the criteria. While some services are subscription-based, they provide highly accurate and up-to-date data.

2. Manual TikTok Platform Searches

In addition to using influencer databases, you can use TikTok’s internal search capabilities. This involves searching by popular hashtags such as:

• #LondonLifestyle
• #LondonFashion
• #LondonGym
• #LondonParties
• #LondonArt

By exploring these hashtags, you can identify creators whose content closely aligns with your criteria. Once identified, manually reviewing each profile’s bio and content can help you verify that:

• They are based in London
• Their content consistently features topics of interest
• Their follower count is between 1,000 and 20,000

3. Content Analysis & Verification

Once you have gathered a preliminary list using both automated tools and manual searches, it's essential to confirm each influencer’s details. Depending on how public information is structured:

• Age Estimation: While explicit age may not be provided, content such as lifestyle choices, fashion style, and other engagements can give an estimated idea of the creator's age range.
• Location Verification: Many influencers mention their location within their bios or video captions, which can be confirmed by cross-referencing posts or linked content on other social platforms.
• Demographic Specifics: Additional demographic analysis can sometimes be inferred from visual content, language, and branding, though privacy concerns necessitate respectful handling of such details.

Spreadsheet Template and Data Organization

To efficiently organize your findings when compiling your list of TikTok creators, here is a template that you can integrate into your preferred spreadsheet application (e.g., Microsoft Excel, Google Sheets). This template focuses on the essential columns that need to be filled:

This structured format allows for both manual entries and potential automatic data imports from influencer marketing platforms if you have access to them.

Detailed Steps to Compile Your List

Step 1: Define Your Search Criteria

Clearly remember all the criteria needed:

• Only female TikTok creators.
• Age range 18-28 (estimate where explicit data is unavailable).
• Based in London, United Kingdom.
• Content marketed towards lifestyle themes – including parties, gym workouts, fashion, creative arts, dating, relationships, and music.
• Follower count strictly between 1,000 and 20,000, ensuring that you target micro and emerging influencers.

Having these filters ready will facilitate smoother searches across multiple platforms.

Step 2: Use Influencer Databases

Subscribe to platforms that offer detailed influencer analysis. These platforms allow you to directly filter candidates based on most or all of the criteria mentioned. Once filtered:

• Export the list if the platform offers data download features.
• Adjust the filters if the available data appears too broad or if candidate profiles fall outside your target follower range.

Step 3: Conduct Manual Verification

With an initial list from the databases, the next vital step is verifying:

• Check that the location is indeed London by scanning the biography or profile details.
• Manually review posts to assess consistency with the content categories: lifestyle, parties, etc.
• Reconcile any discrepancies in follower counts by checking recent statistics. Influencer counts can change rapidly.

This step ensures your list remains accurate and unbiased.

Step 4: Populate Your Spreadsheet

As you verify each influencer’s details, add them to your spreadsheet using the template provided. Include relevant observations in the “Notes” column if any verification is ambiguous or requires follow-up.

Consider organizing the spreadsheet with additional columns if needed, such as contact info or engagement metrics, based on later needs. Always ensure that any data collected respects privacy rules and guidelines mandated on the platform.

Privacy Considerations and Ethical Implications

When gathering data about individual TikTok creators, privacy and ethical considerations are paramount. Here are some aspects to be mindful of:

Data Sensitivity and Public Information

Only use public information that creators have consented to share on their profiles. Avoid using any data that might be considered sensitive or private. Ensure you respect terms of use and any applicable privacy laws in the UK and other relevant jurisdictions.

Fair Use and Proper Acknowledgment

If you intend to use this data for marketing campaigns or any commercial purposes, follow fair use guidelines and best practices. Additional validation by contacting the creators or working through professional influencer marketing networks is advisable.

Maintaining ethical standards not only protects you legally but also ensures that the influencers are respected and appropriately engaged.

Dynamic Nature of Social Media Data

It’s crucial to note that social media data is highly dynamic. Influencers’ follower counts, content focus, and even location details can change frequently. When compiling a list such as this:

1. Continuous Updates

Expect the need to update your spreadsheet periodically to maintain its relevancy. Automated tools with scheduled data refreshing capabilities are a considerable asset here.

2. Manual Adjustments

Manual oversight is necessary to catch anomalies or shifts in an influencer’s content strategy that may take them outside of your specified criteria. This vigilance ensures the quality and applicability of your data over time.

Additional Tips and Best Practices

Besides using influencer platforms and manual verification, consider these additional practices:

Engage with Communities

Engage with local or niche communities on platforms like TikTok, LinkedIn, or even industry-specific forums. Often, recommendations in these spaces can reveal emerging talents that might not yet be prominently featured in larger influencer databases.

Utilize Data Aggregators

Some social media data aggregators compile public statistics across platforms including TikTok. While these aggregators may not precisely filter all your criteria, they can add a layer of verification for follower counts and engagement patterns.

Cross-Platform Integration

Many influencers have a presence across multiple platforms. If you can cross-check the details available on TikTok with those on Instagram, Twitter, or LinkedIn, it may help in validating data accuracy, especially the location and content type.

Utilizing a Sample Data Table

To illustrate the data organization further, here is an expanded example of how your spreadsheet might look:

This table can be expanded to include up to 100 entries based on your research. It’s recommended to keep this document updated by setting aside regular intervals for validation.

Challenges and Considerations

It is important to address challenges that often arise in this process:

Data Privacy and Ethics

Collecting data on individual influencers must be done with respect to privacy guidelines. Ensure that all data you compile is publicly available and that you do not breach any privacy regulations. The process should be transparent if used for commercial purposes.

Accuracy of Data

Given the fluctuating nature of social media platforms, accuracy is a primary concern. Always verify the current follower count, profile details, and content type since these parameters can change rapidly with increased posting activity or rebranding efforts by creators.

Limited Access to Internal Filters

Platforms like TikTok do not directly allow filtering by exact age or detailed demographic markers. This means you may have to estimate age and other criteria from available data, which introduces a margin of error. Combining automated tools with manual analysis helps mitigate this issue.

Conclusion

While it is not feasible to directly provide a precompiled spreadsheet with 100 TikTok creators meeting all the detailed criteria due to privacy concerns, changing data, and requirements for verification, this guide offers you a thorough roadmap. By leveraging influencer marketing tools, employing manual verification procedures, and organizing your findings in a structured template, you can effectively compile a highly accurate and targeted spreadsheet. Always remember to maintain ethical standards and respect privacy laws throughout your data collection journey.

References

• Top TikTok London Influencers in United Kingdom - Influence Grid
• Top 20 London Influencers in 2025 - Favikon
• Top 161 Tiktok Influencers In London, LND - Collabstr

More

How to use influencer platforms for data mining

Ethical considerations in social media data collection

Manual verification of social media profiles