Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More
Socket
Sign inDemoInstall
Socket

xl2sitemap

Package Overview
Dependencies
Maintainers
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

xl2sitemap

Generate heavy sitemap files using excel sheets

  • 0.1.3
  • PyPI
  • Socket score

Maintainers
1

Excel to Sitemap (xl2sitemap)

PyPI version

Xl2sitemap is a command line tool to generate sitemaps using data in an excel sheet. Xl2sitemap reads data from an excel sheet and converts the data into SEO friendly sitemaps that can be submitted to search engines directly after uploading.

  • Generates a .xml file
  • Generates a .xml.gz file (compressed)
  • Gives you flexibility with the number of urls in a single file

New Features!

  • Ability to create multiple sitemaps based on classifiers. Classifiers are nothing but different groups for which it is ideal to create different sitemaps. This makes it easier for indexation problem debugging as mentioned on the blog XML Sitemaps by Moz

You can also:

  • Add attributes such as priority, changefreq, lastmod to your urlsets

Requirements

Dillinger uses a number of open source projects to work properly:

  • Python 3 - Python 3 and above
  • A well structured excel file with appropriate column names as mentioned below
Structuring your excel sheet

Excel sheet format

  • The column url is a compulsory column in your excel sheet. This contains the urls of your website
  • The classifier column is an optional column. This contains the classifier based on which the sitemap file will be split into multiple files. If you are including this column in your excel sheet, make sure you use the -c flag
  • The lastmod column is an optional column. This contains the last modified date of the corresponding url in DD/MM/YYYY format. If you are including this column in your excel sheet, make sure you use the -l flag
  • The changefreq column is an optional column. This contains the last change frequency of the corresponding url. If you are including this column in your excel sheet, make sure you use the -f flag
  • The priority column is an optional column. This contains the priority of the corresponding url. If you are including this column in your excel sheet, make sure you use the -p flag

Installation

Installation of xl2sitemap requires running the following command form your command line utility

pip install xl2sitemap

Running from command line

Running xl2sitemap with the basic default configuration requires running the following command

xl2sitemap example-input.xlsx

The example-input.xlsx can be any excel sheet with the appropriate columns in it

Other options that can be enabled are

FlagUsage
-fWill add <changefreq> tag in your sitemap
-pWill add <priority> tag in your sitemap
-lWill add <lastmod> tag in your sitemap
-cWill split sitemap into multiple files based on the classifier column
-m 50000Will add a maximum of 50,000 urls only in a single sitemap. If urls are greater than 50,000 then multiple files will be generated

Example

xl2sitemap example-input.xlsx -m 40000 -p -f -l

This will generate sitemaps with 40,000 urls in each file with <changefreq>, <priority>, <lastmod> attributes for each <urlset>.

Development

Want to contribute? Great! Open your favorite Terminal and run these commands.

git clone https://github.com/antiproblemist/excel-to-sitemap.git

License

BSD 3-Clause

Author

Follow the author on Linkedin

Free Software, Hell Yeah!

FAQs


Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc