Extract Basic Contact Lists from Excel Files
npm install xlsx-contacts-parser
const xlsxToJson = require('xlsx-to-json-parser');
const json = await xlsxToJson({
path: 'path/to/excel/file.xlsx',
password: 'SuperSecretPassword',
});
-
path
(string, required): Path to the Excel file. -
password
(string, optional): Password to open the Excel file.
The output is a JSON object with the following structure:
{
"path": "path/to/excel/file.xlsx",
"lists": [
{
"name": "List 1",
"contacts": [
{
"email": "joe.blow@nowhere.com",
"name": "Joe Blow"
},
{
"email": "mike.smith@nowhere.com",
"name": "Mike Smith"
}
]
}
]
}
If you ever need a hand or have any questions, feel free to reach out.
Fred Lackey
https://fredlackey.com
fred.lackey@gmail.com