89% import-spreadsheets-from-microsoft-excel

Code Review | Import Spreadsheets from Microsoft Excel

WordPress plugin Import Spreadsheets from Microsoft Excel scored89%from 54 tests.

About plugin

  • Plugin page: import-spreadshee...
  • Plugin version: 10.1.4
  • PHP compatiblity: 5.2.4+
  • PHP version: 7.4.16
  • WordPress compatibility: 4.5-6.1.1
  • WordPress version: 6.3.1
  • First release: Jun 21, 2018
  • Latest release: Nov 2, 2023
  • Number of updates: 36
  • Update frequency: every 54.5 days
  • Top authors: spreadsheetconverter (100%)

Code review

54 tests

User reviews

4 reviews

Install metrics

1,000+ active /18,381 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
Install script ran successfully

Server metrics [RAM: ▲0.14MB] [CPU: ▼3.81ms] Passed 4 tests

Analyzing server-side resources used by Import Spreadsheets from Microsoft Excel
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.60 ▲0.1442.91 ▼0.18
Dashboard /wp-admin3.44 ▲0.0949.68 ▼11.33
Posts /wp-admin/edit.php3.56 ▲0.2048.35 ▲2.38
Add New Post /wp-admin/post-new.php6.31 ▲0.4297.18 ▼6.10
Media Library /wp-admin/upload.php3.37 ▲0.1438.72 ▲3.54
Add New /wp-admin/post-new.php?post_type=imsfmessc-file3.5644.48
All Calculators /wp-admin/edit.php?post_type=imsfmessc-file3.4139.47

Server storage [IO: ▲0.64MB] [DB: ▲0.00MB] Passed 3 tests

How much does this plugin use your filesystem and database?
There were no storage issued detected upon installing this plugin
Filesystem: 31 new files
Database: no new tables, 6 new options
New WordPress options
theysaidso_admin_options
can_compress_scripts
widget_recent-posts
widget_recent-comments
widget_theysaidso_widget
db_upgraded

Browser metrics Passed 4 tests

Checking browser requirements for Import Spreadsheets from Microsoft Excel
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,931 ▲18514.35 ▼0.011.59 ▼0.0342.28 ▼5.19
Dashboard /wp-admin2,329 ▲1484.78 ▼0.9086.56 ▼7.9640.04 ▲0.58
Posts /wp-admin/edit.php2,251 ▲1512.43 ▲0.4045.83 ▲11.3834.60 ▼0.29
Add New Post /wp-admin/post-new.php1,678 ▲14919.51 ▼3.69646.58 ▲39.3646.85 ▼6.36
Media Library /wp-admin/upload.php1,562 ▲1684.33 ▲0.0697.59 ▼2.3039.99 ▼2.92
Add New /wp-admin/post-new.php?post_type=imsfmessc-file1,6362.7362.8436.80
All Calculators /wp-admin/edit.php?post_type=imsfmessc-file1,2232.5447.4329.04

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 75% from 4 tests

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
The following items require your attention
  • The uninstall procedure has failed, leaving 6 options in the database
    • db_upgraded
    • widget_theysaidso_widget
    • theysaidso_admin_options
    • widget_recent-posts
    • can_compress_scripts
    • widget_recent-comments

Smoke tests Passed 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
Even though no errors were found, this is by no means an exhaustive test

SRP Passed 2 tests

🔹 Tests weight: 20 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Congratulations! This plugin passed the SRP test

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a smoke test targeting browser errors/issues
No browser issues were found

Optimizations

Plugin configuration 93% from 29 tests

readme.txt 94% from 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
These attributes need to be fixed:
  • Tags: You are using too many tags: 12 tag instead of maximum 10
You can take inspiration from this readme.txt

import-spreadsheets-from-microsoft-excel/import-spreadsheets-from-microsoft-excel.php 92% from 13 tests

The main file in "Import Spreadsheets from Microsoft Excel" v. 10.1.4 serves as a complement to information provided in readme.txt and as the entry point to the plugin
You should first fix the following items:
  • Text Domain: The text domain should only use lowercase characters and dashes

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is a short overview of programming languages used in this plugin, detecting executable files
Good job! No executable or dangerous file extensions detected1,083 lines of code in 6 files:
LanguageFilesBlank linesComment linesLines of code
PHP114293634
CSS34027268
JavaScript2628181

PHP code Passed 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
There were no cyclomatic complexity issued detected
Cyclomatic complexity
Average complexity per logical line of code0.24
Average class complexity0.00
▷ Minimum class complexity0.00
▷ Maximum class complexity0.00
Average method complexity0.00
▷ Minimum method complexity0.00
▷ Maximum method complexity0.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes0
▷ Abstract classes00.00%
▷ Concrete classes00.00%
▷ Final classes00.00%
Methods0
▷ Static methods00.00%
▷ Public methods00.00%
▷ Protected methods00.00%
▷ Private methods00.00%
Functions29
▷ Named functions29100.00%
▷ Anonymous functions00.00%
Constants1
▷ Global constants1100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Often times overlooked, PNG files can occupy unnecessary space in your plugin
20 PNG files occupy 0.06MB with 0.01MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
icon/icon-googleplus.png0.80KB0.89KB0.00%
icon/icon-apple.png1.72KB0.63KB▼ 63.51%
icon/icon-flickr.png0.32KB0.25KB▼ 21.47%
icon/plus.png0.42KB0.41KB▼ 4.15%
icon/icon-facebook.png0.35KB0.29KB▼ 16.11%