Firestore-to-excel NPM

Firestore to Excel

Description

Firestore to Excel is a Node.js utility designed to facilitate the export of data from Firebase Firestore to Excel files. This tool is ideal for users who need to manipulate or analyze Firestore data in a spreadsheet format.

Features

Fetch data from Firestore collections based on custom queries.
Filter and sort data from Firestore.
Export data to Excel files with customizable structure.

Installation

npm install firestore-to-excel

Usage

To use this package, you need a Firebase Service Account JSON file. Ensure this file is accessible to your script.

Basic Command Run the script with the following command, replacing path-to-your-firebase-service-account.json with the path to your Firebase Service Account JSON file.

firestore-to-excel path-to-your-firebase-service-account.json

Follow the command-line prompts to specify:

Firestore collection name.
Filter and sorting criteria (optional).
Output Excel file details.

Command Line Interface

The tool provides an interactive CLI to guide you through the necessary steps to export your data.

Configuration

Customize the export structure by editing the documentStructure.json file to match your Firestore data schema.

API Reference

The FirestoreDataExporter class offers various methods for interacting with Firestore and generating Excel files. Explore the index.js file for detailed method descriptions and usage.