Get an Excel file
Tasks that end with an Excel file you can keep working in: tables, calculations and lists with links. There are 137 tasks on this page.
Marketplaces and e-commerce
- Analyze a brand's TikTok Shop store: Modelyx reviews a TikTok Shop store: number of products, price range and the best-rated items, so you see how the brand sells there.
- Benchmark your product's reviews against competitors: Modelyx compares review themes on your listing and three competitors so you see where your product wins and where it loses.
- Build a keyword list from competitor titles: Modelyx collects competitor titles for several phrases and builds a keyword table ranked by how often top sellers use each word.
- Build a launch checklist for a new marketplace product: Modelyx builds a step-by-step launch checklist for your product on Wildberries or Ozon, tailored with data from the niche.
- Build a repricing table based on competitor prices: Modelyx collects competitor prices for your SKUs and builds a table with a suggested price per SKU within your minimum margin.
- Build a unit economics calculator for a marketplace product: Modelyx builds an Excel calculator with formulas for cost, commission, logistics, returns and ads that shows profit per unit.
- Build an interactive niche dashboard you can share: Modelyx turns marketplace niche data into an interactive dashboard with price, brand and rating charts and a public link.
- Check competitor prices on Wildberries and Ozon: Modelyx collects prices for similar products on Wildberries and Ozon and shows the min, median and max and where your price sits.
- Check how concentrated brands are in a marketplace category: Modelyx shows which brands dominate a category on Wildberries and Ozon by listings and reviews, so you know if the niche is locked up.
- Compare several product ideas and pick a niche: Modelyx scores several product ideas side by side on price, competition and review activity so you can pick the one to launch.
- Compare your listing with the top 10 in search: Modelyx puts your listing next to the top 10 search results on price, rating, reviews and title, and lists what to fix first.
- Decide whether to launch on Wildberries or Ozon first: Modelyx compares the same niche on Wildberries and Ozon by price level, competition and ratings to help you pick where to start.
- Estimate import margin: Amazon vs Wildberries and Ozon prices: Modelyx compares prices on Amazon with Wildberries and Ozon in one currency and estimates your margin from your costs.
- Find empty price segments in a marketplace niche: Modelyx maps listings by price and rating and finds price bands where buyers leave reviews but few sellers compete.
- Find fast-rising newcomer listings in a category: Modelyx finds listings with high ratings but few reviews in top search results, a sign of products gaining ground fast.
- Find out how often competitors discount on Wildberries: Modelyx compares price histories of several Wildberries competitors to show how often they discount, how deep, and who holds the price.
- Find what buyers complain about in competitor reviews: Modelyx collects reviews of top competitor products and ranks the most common complaints with quotes, so you can fix them in your product.
- Map a competitor brand's assortment on Wildberries and Ozon: Modelyx collects a competitor brand's listings and maps its assortment by product type, price and rating to show its strong spots.
- Monitor competitor prices every week automatically: Modelyx checks competitor prices on Wildberries and Ozon on a schedule and sends you what changed since the last run.
- Pick gift-season products to add to your assortment: Modelyx checks gift search results on Wildberries and Ozon and suggests products that fit your store for New Year or March 8.
- Research a product niche on Amazon: Modelyx collects Amazon search results for a product and shows price range, rating spread and how many reviews the leaders have.
- Research products on TikTok Shop in the US: Modelyx collects TikTok Shop listings for a search phrase and shows price range, ratings and the strongest products in the US market.
- See what an influencer recommends on their Amazon storefront: Modelyx collects the products in an influencer's Amazon storefront with prices and groups them by category for product ideas.
- Size up a marketplace niche before you launch: Modelyx collects hundreds of listings in a niche on Wildberries and Ozon and tells you whether there is room for a newcomer and at what price.
- Spot product trends in a category from search results: Modelyx groups search results in a category by features like color, material or design and shows which variants gather the most reviews.
- Track new competitors entering your niche: Modelyx runs your niche search every week and reports new listings in the top results with their prices and ratings.
Social media and influencers
- Analyze what a competitor posts on LinkedIn: Modelyx collects a competitor's recent LinkedIn company posts, groups them by topic and format and shows what earns the most reactions.
- Benchmark your social account against competitors: Modelyx puts your account and your competitors side by side on followers, views, engagement and posting rhythm, with real numbers from public posts.
- Check if a Telegram channel ad is worth the price: Modelyx calculates average post views and cost per 1,000 views for a Telegram channel, so you know if the ad price is fair.
- Compare Shorts and long videos on a YouTube channel: Modelyx compares how a YouTube channel's Shorts and long videos perform, so you can decide which format to invest in.
- Compare creators on a shortlist and pick the best for your budget: Modelyx calculates views, engagement and cost per 1,000 views for every creator on your shortlist and picks the best mix for your budget.
- Find a creator's business email and links: Modelyx collects a creator's public business contacts and links from the profile, channel description and link-in-bio page.
- Find brands and creators in an account's followers: Modelyx looks through who an account follows and who recently followed it and picks out brands and creators, so you see its network.
- Find brands that sponsor YouTube videos in your niche: Modelyx checks popular YouTube videos in your niche and lists the brands that sponsor them, so you know who buys integrations there.
- Find creators who already tag a brand on Instagram: Modelyx collects posts where people tag a brand on Instagram and shows which creators already make content for it or for your competitors.
- Find customer pain points on Reddit: Modelyx searches Reddit posts and comments about your topic and collects the problems people describe, ranked by how often they come up.
- Find local brands on Instagram and Threads for a collab: Modelyx finds local businesses in your city on Instagram and Threads and lists them with followers and engagement for a collaboration.
- Find micro-influencers in your niche and country: Modelyx searches TikTok, Instagram and YouTube for creators in your niche, filters them by audience size and language, and returns a ready shortlist.
- Find popular TikTok creators in a specific country: Modelyx lists popular TikTok creators in the country you choose, filtered by audience size, with followers and engagement for each.
- Find potential buyers in social media comments: Modelyx scans comments under competitors' or niche posts for people asking about price, availability or delivery, and lists them with links.
- Find subreddits and communities to promote in: Modelyx finds subreddits, Facebook groups and X communities around your topic and compares their size, activity and rules.
- Find the most-viewed videos on a topic: Modelyx searches TikTok, Instagram Reels, YouTube and Facebook for a topic and ranks the videos by views, so you get proven references fast.
- Find the top-performing posts of any account: Modelyx collects an account's recent posts, ranks them by views and engagement and explains what the best ones have in common.
- Find what customers complain about under competitors' posts: Modelyx reads comments under competitors' social posts and collects complaints by theme, so you see weaknesses you can fix in your own product.
- Find which hooks work in top videos of your niche: Modelyx collects the most-viewed videos in your niche, reads their opening lines and groups the hooks that drive views.
- Find your most engaged followers from comments: Modelyx goes through comments on your recent posts and finds the people who comment most often, ready for an ambassador or loyalty program.
- Map a creator's accounts and reach across all platforms: Modelyx finds a creator's accounts on every platform and compares followers and typical views, so you can see where an integration will reach the most people.
- See which brands Reddit recommends in your category: Modelyx reads Reddit threads where people ask for recommendations in your category and counts which brands get recommended and why.
- See which brands a creator has already worked with: Modelyx reviews a creator's recent posts, video sponsors and product picks to show which brands they have promoted and how those posts performed.
- Track how often competitors post and in which formats: Modelyx counts how often your competitors publish, in which formats and on which days, and compares it with how those posts perform.
- Vet an influencer before you pay for an ad: Modelyx checks a creator's recent public posts and calculates average views, engagement rate and cost per 1,000 views before you pay.
Ads and competitors
- Analyze an ad research file you already have: Modelyx reads your exported list of competitor ads, cleans it and calculates run times, format shares and top offers in the Cloud Sandbox.
- Build a dashboard of competitor ad activity: Modelyx collects ads for several competitors across public ad libraries and builds an interactive dashboard of counts, formats, offers and run times.
- Build a swipe file of ad hooks from competitor ads: Modelyx collects competitor ads, pulls out the opening lines and groups the hooks by angle into a swipe file you can reuse.
- Compare competitor pricing pages in one table: Modelyx reads competitors' public pricing pages and puts plans, prices, limits and trial terms side by side in one table.
- Compare competitors' lead magnets and free trial offers: Modelyx reads competitors' websites and ads and lists every lead magnet, free trial and demo offer they use to capture leads.
- Compare menu prices of competing restaurants and cafes: Modelyx reads competitors' public menus on their websites and compares prices for the same dishes and drinks in one table.
- Compare the ad format mix of your competitors: Modelyx counts competitors' image, video and carousel ads in public ad libraries and shows the format share per brand in one chart.
- Compare your page's on-page SEO with top competitors: Modelyx reads your page and the top Google results for your query, then compares titles, headings, topics and length to show what you're missing.
- Find all competitors in a niche and city: Modelyx searches the web and ad libraries for players in your niche and returns a market map with websites, offers and price levels.
- Find companies that advertise actively to pitch your agency: Modelyx searches public ad libraries for active advertisers in a niche and country and builds a prospect list with their ad activity.
- Find competitor ads that have been running the longest: Modelyx pulls competitors' active ads from public ad libraries and ranks them by days running, so you see the ads they keep paying for.
- Find out which countries a competitor advertises in: Modelyx checks a competitor's ads across public ad libraries and maps the countries they target, a strong hint of their expansion plans.
- Find who advertises on Google in your niche: Modelyx searches the Google ad library for your niche and country and lists the advertisers, their ad counts and the formats they use.
- Make a USP comparison table for your competitors: Modelyx reads each competitor's homepage and ads, extracts their main promises and builds a table that shows which claims are taken and which are free.
- Map where competitor ads send their traffic: Modelyx follows the links in competitors' ads and groups the destinations: landing pages, app stores, catalogs or messengers.
- Measure how deep competitors discount in their ads: Modelyx finds discount ads from your competitors, pulls out the percentages and price cuts and shows the typical discount in your niche.
- See which offers advertisers use in a niche and country: Modelyx searches public ad libraries by keyword and country, groups the ads by offer type and shows which offers dominate your niche.
Content and design
- Build a monthly content plan in Excel or a Page: Modelyx builds a month of posts with date, platform, format, topic, hook and call to action, as an Excel file or an editable Page.
Data, files and reports
- Analyze a CSV file too large to open in Excel: Modelyx analyzes CSV files with millions of rows that Excel can't open, and returns totals, breakdowns and a smaller file you can work with.
- Analyze customer reviews you exported from your store: Modelyx reads your exported customer reviews, finds recurring complaints and praise per product and shows which issues hurt ratings most.
- Analyze employee turnover from an HR export: Modelyx calculates turnover by department, tenure and manager from your HR export and shows where and when people leave.
- Analyze survey results with charts: Modelyx turns a survey export into percentages, cross-tabs and charts, and summarizes open answers into themes.
- Analyze your Wildberries or Ozon seller report: Modelyx reads your marketplace sales report export and shows net payout, commissions, logistics, returns and profit for every SKU.
- Build a cohort retention table from your orders: Modelyx groups customers by first purchase month and shows how many come back each month after, as a retention table and heatmap.
- Build a contract register from a folder of contracts: Modelyx reads many contracts and builds one register with parties, amounts, start and end dates, renewal terms and notice periods.
- Build a sales pivot by month, region and SKU: Modelyx turns a raw sales export into pivot tables by month, region and SKU with totals, growth and a chart, calculated over every row.
- Build a unit economics model in Excel: Modelyx builds a unit economics workbook with live formulas: margin per order, CAC, LTV and payback, plus scenarios you can change.
- Build an accounts receivable aging report: Modelyx groups unpaid invoices by how overdue they are, totals debt per client and lists who to call first.
- Build an ad spend report by channel: Modelyx combines your ad account exports and sales data into one report with spend, CPA, ROAS and the best and worst campaigns.
- Calculate reorder points and safety stock: Modelyx calculates reorder points, safety stock and order quantities for every SKU from your sales history and supplier lead times.
- Calculate sales commissions from a deals export: Modelyx applies your commission rules to the closed deals in your export and gives you a payout table per manager with every deal listed.
- Calculate sales funnel conversion by stage: Modelyx calculates conversion between every funnel stage from your deals export and shows where you lose the most leads and by which manager.
- Categorize NPS comments into themes: Modelyx calculates your NPS and sorts every comment into themes, so you see what promoters love and what detractors complain about.
- Categorize business expenses from a statement: Modelyx sorts every transaction in your bank or card statement into expense categories and shows where the money goes each month.
- Check a product catalog for errors before import: Modelyx checks your product catalog for missing fields, duplicate SKUs, broken barcodes and odd prices before you upload it anywhere.
- Clean and deduplicate a CRM contact export: Modelyx removes duplicate contacts, fixes phone and email formats and fills obvious gaps in your CRM export, then returns a clean file to re-import.
- Compare budget vs actual and explain the variances: Modelyx matches your budget and actual spending line by line, calculates variances and lists the biggest gaps with short explanations.
- Compare this year with last year and explain the change: Modelyx compares two periods of your data, such as this year vs last, and breaks the change down by price, volume and product mix.
- Compare two supplier price lists: Modelyx matches items across two price lists, even with different names and codes, and shows price differences and items only one supplier has.
- Convert files between CSV, Excel and PDF: Modelyx converts your files between CSV, Excel, PDF, Word and JSON, fixing encodings, delimiters and number formats along the way.
- Extract tables from PDF reports into Excel: Modelyx pulls tables out of PDF reports, keeps columns and numbers intact and puts them into an Excel file, one sheet per table.
- Fill a marketplace upload template from your catalog: Modelyx maps your own product table into a Wildberries or Ozon bulk upload template, column by column, and flags missing data.
- Find outliers and anomalies in daily sales data: Modelyx scans your daily sales or transactions for unusual spikes, drops and suspicious entries and explains which ones need a look.
- Forecast cash flow from a bank statement export: Modelyx categorizes your bank transactions, finds recurring payments and projects your cash balance for the next 13 weeks.
- Forecast next quarter's sales from your history: Modelyx forecasts sales by month or SKU from your history, taking trend and seasonality into account, with a range you can plan around.
- Format a price list for clients: Modelyx turns your raw product table into a clean client price list with categories, discounts and your contacts, as Excel and PDF.
- Merge dozens of Excel files into one table: Modelyx combines many Excel or CSV files into one clean table, even when sheets and column names differ, and returns a single workbook.
- Recalculate prices and margins after a cost increase: Modelyx recalculates prices for your whole range after a supplier or currency change and shows how margins move at each price.
- Reconcile two spreadsheets and find mismatches: Modelyx compares two tables row by row, such as your payments and a counterparty's act, and lists missing, extra and mismatched records.
- Run an ABC/XYZ analysis of your assortment: Modelyx ranks your SKUs by revenue share (ABC) and demand stability (XYZ) and shows which products to push, keep or cut.
- Screen a batch of CVs into a comparison table: Modelyx reads the CVs candidates sent you and builds one table with experience, skills and fit against your requirements.
- Segment customers with RFM analysis: Modelyx scores your customers by recency, frequency and spend, sorts them into segments and suggests what to send each one.
- Summarize timesheets into hours and overtime: Modelyx totals hours from your timesheet exports per employee and week, calculates overtime and flags missing or odd entries.
- Turn scanned invoices into an Excel table: Modelyx reads scanned invoices and receipts, extracts supplier, date, amounts and VAT into one table and flags possible duplicates.
Research, sales and hiring
- Benchmark salaries for a role by experience on HH.ru: Modelyx collects HH.ru vacancies for a role and calculates median and quartile salaries by experience level, with a chart and an Excel file.
- Build a hiring funnel dashboard from your candidate export: Modelyx turns your candidate export into a hiring dashboard: conversion between stages, time to hire, best sources and where candidates drop out.
- Build a lead list of local businesses from Google Maps: Modelyx collects businesses of one category in a city from Google Maps with name, address, phone and rating, and returns a clean Excel lead list.
- Check café competition in a neighborhood before opening: Modelyx counts cafés and coffee shops near your planned location from Google Maps and shows how crowded and how well rated the area already is.
- Compare franchise terms from public pages: Modelyx reads franchise offers on brands' websites and compares entry fee, royalty, required investment and claimed payback in one table.
- Compare how saturated a business category is in two cities: Modelyx counts businesses of one category in each city from Google Maps, adds population from public sources and shows venues per 100,000 people.
- Compare ratings of chain branches in a city: Modelyx collects every branch of the chains you name from Google Maps and compares average rating, review volume and the weakest locations.
- Compare software tools from their public pages: Modelyx reads the websites, pricing and documentation of the tools you shortlist and builds a comparison table against your requirements.
- Compare what competing employers offer candidates: Modelyx reads competing employers' HH.ru vacancies for the same role and compares salary, schedule, remote format and benefits.
- Create a candidate scorecard in Excel: Modelyx builds a weighted candidate scorecard in Excel that totals interviewers' scores automatically and ranks candidates.
- Create a test assignment with a grading rubric: Modelyx designs a short test assignment for a role, with clear instructions, a time limit and a rubric to grade every candidate the same way.
- Define your ideal customer profile from past deals: Modelyx analyzes your won and lost deals from an uploaded file and shows which industries, sizes and cities close best and fastest.
- Draft cold emails personalized from each company's website: Modelyx reads each prospect's website and drafts a cold email that references what the company actually does, one draft per prospect.
- Enrich a target account list from public LinkedIn company pages: Modelyx reads public LinkedIn company pages for your target accounts and adds industry, size, headquarters and recent topics to your list.
- Estimate TAM, SAM and SOM with sources: Modelyx builds a rough top-down and bottom-up market size estimate with linked sources and an Excel model you can adjust.
- Estimate a hiring budget for a new team: Modelyx pulls market salaries for every role you plan to hire from HH.ru and calculates monthly and annual payroll in an editable Excel model.
- Find businesses with low Google Maps ratings to pitch a service: Modelyx finds local businesses with weak Google Maps ratings but steady traffic, ready leads for review management or service improvement offers.
- Find companies hiring in your niche as a sales signal: Modelyx finds employers with open HH.ru vacancies for a role that signals need for your product and turns them into a prospect list.
- Find distributors for your product in a new country: Modelyx finds distributors and wholesalers for your category in a target country and builds a shortlist with brands they carry, regions and contacts.
- Find grants and support programs for your business: Modelyx finds grants, accelerators and government support programs that fit your business and lists eligibility, deadlines and links to apply.
- Find local businesses to partner with for cross-promotion: Modelyx finds businesses in your city that share your audience, from Google Maps and their websites, and drafts a partnership pitch for each type.
- Find suppliers and manufacturers from public websites: Modelyx finds suppliers for your product on the web and builds a shortlist with location, minimum order, certifications and contacts from their sites.
- Find the most requested skills for a role: Modelyx analyzes HH.ru vacancies for a role and ranks the skills and tools employers ask for most, split by experience level.
- Find trade shows and industry events to attend: Modelyx finds exhibitions and conferences in your industry and lists dates, city, audience, exhibitor costs where public and links.
- Plan field sales visits by district from Google Maps: Modelyx collects target businesses from Google Maps, groups them by district and builds a day-by-day visit plan for your field sales reps.
- Prepare a customer interview guide for a new product: Modelyx writes a customer discovery interview guide with open questions, follow-ups and a template to log answers across interviews.
- Prioritize local leads by rating and review count: Modelyx splits Google Maps leads into priority tiers by rating and review count and suggests which tier to call first for your offer.
- Qualify a list of inbound leads against your criteria: Modelyx checks each lead's website against your ideal customer criteria and scores every company, so your team calls the best fits first.
- Turn a trade show exhibitor list into a lead list: Modelyx reads an event's public exhibitor list, visits each exhibitor's site and builds a qualified lead list to work before and after the show.
Automation and agents
- Refresh your influencer shortlist every week: Modelyx rechecks your influencer shortlist every week, updates reach and engagement, flags drops and adds new creators that fit your brief.
- Refresh your local lead list with new businesses every week: Modelyx searches Google Maps every week for businesses that match your criteria and adds only the new ones to your lead list.
- Track salaries for key roles on HH.ru every week: Modelyx collects new HH.ru vacancies for your roles every week and shows how salary ranges move, so your offers stay competitive.