ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel (by dfinke)

ImportExcel Alternatives

Similar projects and alternatives to ImportExcel

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better ImportExcel alternative or higher similarity.

Suggest an alternative to ImportExcel

Reviews and mentions

Posts with mentions or reviews of ImportExcel. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-23.
  • Is there a better way than using a CSV?!
  • List all users with populated extensionattribute
    If you want to avoid the intermediate CSV step and needing to create the filters by hand, check out the ImportExcel module.
  • Is Join-object case sensitive?
    The times I've needed this, I've had good luck with Import-Excel.
  • Question on using Powershell to merge a lot of excel files into one
    Get away from using com objects. Use this instead: https://github.com/dfinke/ImportExcel
  • How to compare 2 excel sheets to find the common values in a column A and compare their column B and keep the latest one?
    To get those files into powershell, save as csv or use the ImportExcel module
  • Can Powershell sort data from excel files into a single master sheet - without the data being in fixed cell positions?
    If your data actually lives in a real Table, then Get-ExcelTableName (from the ImportExcel module) will probably make quick work of the problem.
  • Delete excel rows based on a specific value with Powershell
    Import the Excel data and process the resulting PSCustomObjects as needed; export the result to back Excel. Requires an additional module.
  • Duplicate a file 40 times, while giving each a custom name from a list?
    You can use ImportExcelto read the read the filenames from the Excel.
  • Offboarding script: pull username and exit date from the excel file in sharepoint - struggling with this bit
    The module ImportExcelis pretty good for working with Excel. You can find the examples on github or google it or for example this one.
  • API Call
    reddit.com/r/CyberARk | 2021-08-06
    Look at something like the PowerShell module ImportExcel to do the updating after you have the data from the API (I would also recommend psPAS.)
  • I was hired partly because of my knowledge of python, but head of IT won’t let me install it…
    reddit.com/r/Python | 2021-08-04
    Since excel seems to be involved, the Import-Excel package is a nice addition to PowerShell and can be installed with user rights. https://github.com/dfinke/ImportExcel
  • Transcript missing console output from a command + Another function I'm wondering about
    ImportExcel
  • SQL data to Excel: most direct/proper way ?
    I’ve not used it, but this exists: https://github.com/dfinke/ImportExcel
  • Tools & Info for Sysadmins - Carrier Lookup, Network Podcast, Identification Tool & More
    reddit.com/r/sysadmin | 2021-06-22
    The ImportExcel function in Powershell (all bow before the great and mighty Doug Finke) is life-changing if you manipulate data inside Powershell. If anything deserves a shout-out, it does.

Stats

Basic ImportExcel repo stats
33
1,655
6.2
9 days ago

dfinke/ImportExcel is an open source project licensed under Apache License 2.0 which is an OSI approved license.

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com

Popular Comparisons

Find remote jobs at our new job board 99remotejobs.com. There are 25 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.